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

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)