[teiid-issues] [JBoss JIRA] (TEIID-3208) Remove outer join based solely on join predicates
Steven Hawkins (JIRA)
issues at jboss.org
Tue Nov 11 09:35:13 EST 2014
Steven Hawkins created TEIID-3208:
-------------------------------------
Summary: 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.8#6338)
More information about the teiid-issues
mailing list