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

Remove outer join based solely on join predicates

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 8.10
    • None
    • Query Engine
    • None

    Description

      We currently remove outer joins based upon where clause predicates, but won't necessarily detect when to remove the the outer join based solely on join predicates:

      SELECT * from pm1.g1 inner join (pm1.g2 left outer join pm1.g3 on pm1.g2.e1=pm1.g3.e1) on pm1.g1.e1=pm1.g3.e1

      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: