[teiid-issues] [JBoss JIRA] (TEIID-3208) Remove outer join based solely on join predicates

[Steven Hawkins (JIRA)]

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)