Multi-way join predicate inappropriately removed
------------------------------------------------
Key: TEIID-4448
URL:
https://issues.jboss.org/browse/TEIID-4448
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 9.1, 8.13.7, 9.0.5, 8.7.10.6_2, 8.12.8.6_3
In a situation where copy criteria can work against a multi-way join predicate, such that
the predicate is not pushed:
t1.a = coalesce(t2.b, t3.c, t4.d) ... t1.a = t4.d
The multi-way predicate can be marked as optional and removed.