[OAK-6238] support cockroachdb

• Type: Technical task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: rdbmk
• Assignee: Unassigned
• Reporter: Julian Reschke
• Created: 18/May/17 12:43
• Updated: 09/Dec/17 04:41

Description

Notes from doing some limited testing with cockroachdb:

• uses PostgreSQL JDBC driver
• but pretends to be PostgreSQL, thus making runtime detection hard
• FETCH FIRST syntax is different from PostgreSQL (only supports "LIMIT")
• table metadata is broken, thus RDBDocumentStore fails to detect table width of DATA column (thinks it is 2GB)
• setting connections to readonly mode fails
• PostgreSQL-specific command to get the current time fails

(I did only run BasicDocumentStoreTest so far)

If we want to support that, we may want to start filing issues against cockroachdb...

Issue Links

• links to: cockroachdb/cockroach/issues/16032 - ResultSetMetaData.getPrecision()
• links to: cockroachdb/cockroach/issues/16033 - setReadOnly()
• links to: cockroachdb/cockroach/issues/16034 - FETCH FIRST