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

wrong result with distinct independent values in a depedent join

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.4.1, 8.5
    • 7.7
    • Query Engine
    • None

    Description

      This should be a fairly uncommon scenario, but if given a query such as:

      SELECT ... FROM pm1.g1, pm3.g2, /*+ makeind */ (select distinct e1, e2 from pm2.g1) x WHERE x.e1=pm1.g1.e1 AND pm3.g2.e2=x.e2

      such that the independent side of the join is seen as having distinct values and the dependent sets are targeted at different sources, we will not correctly detect that the values need pre-processed with dup removal.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: