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)
