[teiid-issues] [JBoss JIRA] (TEIID-4304) Correct handling with subquery in on clause

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4304:
-------------------------------------

             Summary: Correct handling with subquery in on clause
                 Key: TEIID-4304
                 URL: https://issues.jboss.org/browse/TEIID-4304
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 7.7
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 9.1, 9.0.1


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.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)