[teiid-issues] [JBoss JIRA] (TEIID-5016) Exploit left outer join associativity prior to join planning

[Steven Hawkins (JIRA)]

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

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


Updated the logic to perform tree manipulations prior to join planning that are more conducive to our optimizations.  We may need to consider putting in checks for the preserve hint, but for now that was left out as these are narrow changes to the join structure.

> Exploit left outer join associativity prior to join planning
> ------------------------------------------------------------
>
>                 Key: TEIID-5016
>                 URL: https://issues.jboss.org/browse/TEIID-5016
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 10.0
>
>
> Building upon TEIID-3652 there are circumstances where nested left outer joins can have be converted to an inner join prior to join planning.  They can be converted back to a left outer join by TEIID-3652 if needed for pushdown after join planning.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)