Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1128

Switch JOINT prefetches to generate OUTER Joins.

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

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0
    • 3.0M5, 3.0
    • Core Library
    • None

    Description

      Switch JOINT prefetches to OUTER Joins. This is related to CAY-1025. JOINT_PREFETCH_SEMANTICS using inner joins makes little sense and is a complete hack. Changing it to use OUTER joins suddenly makes it usable (and in fact even more robust than DISJOINT prefetches - see the problem described in CAY-1025).

      Needed code was committed as a part of CAY-1025 work, so here we'll need to update the docs and the UPGRADE-NOTES.txt.

      Attachments

        Activity

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

          People

            andrus Andrus Adamchik
            andrus Andrus Adamchik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment