Steven Hawkins created TEIID-2190: ------------------------------------- Summary: 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. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira