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

left join is reversed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 11.1, 11.0.1, 10.3.3
    • 10.3.1, 10.3.2
    • Query Engine
    • None

      A query that is run on teiid 9.1 results in 56186 rows.

      The same query that is run on teiid 10.3.2 results in 5919 rows.

      It seems like the left join is reversed.

      I've attached both query plans.

      The queries are exactly the same. Note that on 9.1 we've prefixed table names with cos2_5_.

        1. plan_teiid_10.3.2.txt
          79 kB
        2. plan_teiid_9.1.txt
          83 kB

              rhn-engineering-shawkins Steven Hawkins
              gadeynebram Bram Gadeyne (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: