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

    • Bug
    • Resolution: Done
    • Major
    • 8.12
    • 8.11.2
    • Query Engine
    • None
    • 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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            mike.higgins@certara.com Mike Higgins (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: