[teiid-issues] [JBoss JIRA] (TEIID-2190) Key usage can remove predicates

Key usage can remove predicates ------------------------------- Key: TEIID-2190 URL: https://issues.jboss.org/browse/TEIID-2190 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Blocker Fix For: 8.2 The implementation strategy for predicate realignment can drop non-column equi join predicates and predicates involving the same column reused multiple times. i.e. create local temporary table x (e1 string, e2 integer, primary key (e1)); create local temporary table x1 (e1 string, e2 integer) ... select x.e1 from x inner join x1 on x.e1 = x1.e1 and upper(x.e1) = x1.e2 May end up not applying the upper predicate.