[teiid-issues] [JBoss JIRA] (TEIID-3208) Remove outer join based solely on join predicates
Steven Hawkins (JIRA)
issues at jboss.org
Thu Mar 5 10:38:52 EST 2015
[ https://issues.jboss.org/browse/TEIID-3208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-3208.
---------------------------------
> Remove outer join based solely on join predicates
> -------------------------------------------------
>
> Key: TEIID-3208
> URL: https://issues.jboss.org/browse/TEIID-3208
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.10
>
>
> We currently remove outer joins based upon where clause predicates, but won't necessarily detect when to remove the the outer join based solely on join predicates:
> SELECT * from pm1.g1 inner join (pm1.g2 left outer join pm1.g3 on pm1.g2.e1=pm1.g3.e1) on pm1.g1.e1=pm1.g3.e1
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
More information about the teiid-issues
mailing list