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, 8.7.8.6_2 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.