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

Correct handling with subquery in on clause

    XMLWordPrintable

Details

    Description

      With the translator capability supportsSubqueryInOn false, we can still plan a query with a subquery in the on clause if non-join criteria on the inner side of a left outer join is used in the user query on clause (it is temporarily pushed out of the join and then added back in rule collapse source).

      Additionally the oracle translator should not support subquery in on for oracle 11 and earlier.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: