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/15 15:59:00 UTC

[jira] [Resolved] (OAK-2941) RDBDocumentStore: avoid use of "GREATEST"

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

Julian Reschke resolved OAK-2941.
---------------------------------
    Resolution: Fixed

> 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.2.2, 1.0.14, 1.3
>            Reporter: Julian Reschke
>            Assignee: Julian Reschke
>            Priority: Minor
>
> In the RDBDocumentStore 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)