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 2015/06/01 16:54:17 UTC

[jira] [Created] (OAK-2941) RDBDOcumentStore: avoid use of "GREATEST"

Julian Reschke created OAK-2941:
-----------------------------------

             Summary: RDBDOcumentStore: avoid use of "GREATEST"
                 Key: OAK-2941
                 URL: https://issues.apache.org/jira/browse/OAK-2941
             Project: Jackrabbit Oak
          Issue Type: Improvement
          Components: rdbmk
    Affects Versions: 1.0.14, 1.2.2, 1.3
            Reporter: Julian Reschke
            Assignee: Julian Reschke
            Priority: Minor


In the RDBDocumenStore we currently use "GREATEST" for conditional updates of the MODIFIED column (implementing the "max" operation). This isn't supported by SQLServer, thus requiring DB-specific code.

It appears we can use something portable instead:

"set MODIFIED = CASE WHEN ? > MODIFIED THEN ? ELSE MODIFIED END"



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