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

Key usage can convert an outer join into an inner join

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 7.4.4, 8.1, 7.7.2
    • 7.4
    • Query Engine
    • None

    Description

      If a left outer join is against a table/view with a index and the join is using all equi-join predicates and there is an additional predicate beyond what is in the index, then the join will be erroneously converted to an inner join.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: