Copy criteria within a left outer join removes predicates
---------------------------------------------------------
Key: TEIID-3236
URL:
https://issues.jboss.org/browse/TEIID-3236
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.4
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.10
With a query such as:
select bqt1.smalla.intkey from bqt1.smalla inner join (select bqt3.smalla.intkey from
bqt2.smalla left outer join bqt3.smalla on bqt2.smalla.intkey = bqt3.smalla.intkey and
bqt3.smalla.intkey = 1) foo on bqt1.smalla.intkey = foo.intkey
where the left outer join is not pushed to the source, we will process it as if
bqt2.smalla.intkey = bqt3.smalla.intkey doesn't exist.
This is somewhat unlikely to occur for user queries as the join predicates are not likely
to occur and could easily be simplified.