Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-2941

RDBDocumentStore: avoid use of "GREATEST"

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 1.0.14, 1.2.2
    • None
    • rdbmk
    • None

    Description

      In the RDBDocumentStore 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"

      Attachments

        Issue Links

        duplicates

        Sub-task - The sub-task of the issue OAK-2949 RDBDocumentStore: no custom SQL needed for GREATEST

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

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment