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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3208.
-----------------------------------
    Resolution: Done


Added logic to rule push non-join criteria to look for situations where a join is over an outer join and a generated is not null criteria can be pushed.

> 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)