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

Dependent join independent dup removal issue

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • 7.4.5, 8.1, 7.7.2
    • 7.1
    • Query Engine
    • None

    Description

      If a dependent join uses columns from the independent side beyond the join predicates and has unique values with duplicates for the predicate value from the independent side, then the duplicate removal will fail to remove the duplicates, since it is mistakenly using all columns.

      If the duplicates then span multiple dependent queries, such as would be the case with large dependent joins or when a source is used with limited value pushdown (such as sybase), then the join result can be incorrect with duplicate rows.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: