You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Julian Reschke (JIRA)" <ji...@apache.org> on 2017/12/09 04:42:00 UTC
[jira] [Updated] (OAK-6238) support cockroachdb
[ https://issues.apache.org/jira/browse/OAK-6238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Reschke updated OAK-6238:
--------------------------------
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...
was:
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 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...
> 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 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...
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)