[jira] [Commented] (OAK-6238) support cockroachdb

["Julian Reschke (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-6238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16018531#comment-16018531 ] 

Julian Reschke commented on OAK-6238:
-------------------------------------

Apparently we could use

{noformat}
SELECT VERSION()
{noformat}

to distinguish Cockroachdb from PostgrSQL.

> support cockroachdb
> -------------------
>
>                 Key: OAK-6238
>                 URL: https://issues.apache.org/jira/browse/OAK-6238
>             Project: Jackrabbit Oak
>          Issue Type: Technical task
>          Components: rdbmk
>            Reporter: Julian Reschke
>            Priority: Minor
>
> 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 tzable with 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...



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)