Julian Reschke created OAK-2949: ----------------------------------- Summary: RDBDocumentStore: no custom SQL needed for GREATEST Key: OAK-2949 URL: https://issues.apache.org/jira/browse/OAK-2949 Project: Jackrabbit Oak Issue Type: Sub-task Components: rdbmk Affects Versions: 1.0.14, 1.2.2, 1.3 Reporter: Julian Reschke Assignee: Julian Reschke Priority: Minor
We currently use "GREATEST" to set MODIFIED to max(old, new). As this isn't supported by SQLServer, the code supports custom query strings. Turns out we don't need this, because we can replace it with a CASE statement (see http://stackoverflow.com/questions/30530970/equivalent-of-sql-greatest-function-for-apache-derby) -- This message was sent by Atlassian JIRA (v6.3.4#6332)