[jira] [Updated] (OAK-1914) RDB: Oracle support

["Amit Jain (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OAK-1914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amit Jain updated OAK-1914:
---------------------------
    Attachment: OAK-1914.patch

[~reschke]

Got lot of test failures when running profile rdb-mysql. Patch attached which along with changing the db charset and collation as below made lot of tests pass. 
{code}ALTER DATABASE oak CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin;{code}.
The patch addresses the following issues currently:
* 767 byte limit for primary keys
* 65535 row size limit
* character insensitive search

I did not change the CHAR2OCTETRATIO yet but read somewhere that a character would be converted to 4 bytes for utf8mb4?

There are still a few tests failing which I haven't looked into {noformat}
Failed tests:   testInterestingStrings[1](org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest): failure to round-trip simple through RDB-H2(file) expected:<foo> but was:<null>
  testUpdatePerfSmallGrowing[1](org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest): number of revisions expected:<1909> but was:<5>
  testCollisionsModCount[1](org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest)
  testUpdatePerfSmallGrowing[2](org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest): number of revisions expected:<852> but was:<4>
  testCollisionsModCount[2](org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest)

Tests in error:
  testUpdateMultiple[1](org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest): failed update of org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest.testUpdateMultiple (race?) after 10 retries
  testUpdateMultiple[2](org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest): failed update of org.apache.jackrabbit.oak.plugins.document.BasicDocumentStoreTest.testUpdateMultiple (race?) after 10 retries
  testIsRecoveryRequired[1](org.apache.jackrabbit.oak.plugins.document.LastRevRecoveryAgentTest): root node does not exist at revision r14a7bccdfcf-0-2
  testRepeatedRecovery[1](org.apache.jackrabbit.oak.plugins.document.LastRevRecoveryAgentTest): root node does not exist at revision r14a7bccdfd6-0-2
  recoveryOfModifiedDocument[1](org.apache.jackrabbit.oak.plugins.document.LastRevRecoveryAgentTest): root node does not exist at revision r14a7bccdfdd-0-2
  testInterleavedUpdate2[0](org.apache.jackrabbit.oak.plugins.document.MultiDocumentStoreTest): failed update of org.apache.jackrabbit.oak.plugins.document.MultiDocumentStoreTest.testInterleavedUpdate2 (race?) after 10 retries
  testInterleavedUpdate2[1](org.apache.jackrabbit.oak.plugins.document.MultiDocumentStoreTest): failed update of org.apache.jackrabbit.oak.plugins.document.MultiDocumentStoreTest.testInterleavedUpdate2 (race?) after 10 retries
{noformat}

> RDB: Oracle support
> -------------------
>
>                 Key: OAK-1914
>                 URL: https://issues.apache.org/jira/browse/OAK-1914
>             Project: Jackrabbit Oak
>          Issue Type: Sub-task
>          Components: rdbmk
>            Reporter: Julian Reschke
>            Assignee: Julian Reschke
>            Priority: Minor
>             Fix For: 1.2
>
>         Attachments: OAK-1914.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)