Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-1266 DocumentStore implementation for relational databases
  3. OAK-2949

RDBDocumentStore: no custom SQL needed for GREATEST

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.0.14, 1.2.2
    • 1.0.15, 1.2.3, 1.3.0, 1.4
    • rdbmk
    • None

    Description

      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)

      Attachments

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. OAK-2941 RDBDocumentStore: avoid use of "GREATEST"

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Activity

            People

              reschke Julian Reschke
              reschke Julian Reschke
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: