Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2747

Wrong results with merge join SORT_DISTINCT with a full sort that is distinct beyond the join columns

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 7.4
    • Fix Version/s: 8.4.1, 8.6
    • Component/s: Query Engine
    • Labels:
      None

      Description

      To speed up processing of a sort merge join we attempt to eliminate extra comparisons by detecting if the equi-join column values are distinct. In plans where the sorted values are distinct beyond the equi-join values such that the equi-join column values are non-distinct, then incorrect results can be returned.

        Attachments

          Activity

            People

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: