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

Thu Sep 6 15:03:32 EDT 2012

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