jackrabbit-oak-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Reschke (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (OAK-2941) RDBDocumentStore: avoid use of "GREATEST"
Date Mon, 01 Jun 2015 14:54:17 GMT

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

Julian Reschke updated OAK-2941:
--------------------------------
    Summary: RDBDocumentStore: avoid use of "GREATEST"  (was: RDBDOcumentStore: avoid use
of "GREATEST")

> 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 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)

Mime
View raw message