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] [Created] (OAK-2949) RDBDocumentStore: no custom SQL needed for GREATEST
Date Tue, 02 Jun 2015 12:09:17 GMT
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

View raw message