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

Teiid could push some outer joins to the source database, but does not

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 8.11.2
    • Fix Version/s: 8.12
    • Component/s: Query Engine
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      Run a similar query with two database and left outer joins. Observe that the plan calls for three SQL statements to be executed instead of the minimal two.

      Show
      Run a similar query with two database and left outer joins. Observe that the plan calls for three SQL statements to be executed instead of the minimal two.

      Description

      In the following SQL:

      select *
      from s1.t1 t1
      left outer join s2.t2 t2 on (t1.id = t2.id)
      left outer join s2.t3 t3 on (t2.id2 = t3.id2)
      where t1.name = 'x'
      option makedep s2.t2

      where t1 is in one database and t2 and t3 are in a different database,
      Teiid could push the second left outer join to the source database. Currently, it does not and performs the join itself. Some outer joins cannot be pushed, of course, but this one and others like it could be.

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: