[teiid-issues] [JBoss JIRA] (TEIID-2190) Key usage can remove predicates
RH Bugzilla Integration (JIRA)
jira-events at lists.jboss.org
Mon Sep 10 11:15:33 EDT 2012
[ https://issues.jboss.org/browse/TEIID-2190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
RH Bugzilla Integration updated TEIID-2190:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=855910
> 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
More information about the teiid-issues
mailing list