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

Cross source join reduced to cross join returns the wrong data

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 7.4.1, 7.6
    • 7.4.1
    • Query Engine
    • None

      A cross source join of the form "select x.e2 from pm1.g2 y, pm2.g1 x where x.e1 = y.e1 and x.e1 = 'a'"

      will incorrectly return the dummy results from y. If the join order is reversed the correct results are returned.

        1. MMSP07_plan.txt
          8 kB
          Paul Nittel

              rhn-engineering-shawkins Steven Hawkins
              pnittel_jira Paul Nittel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: