[teiid-issues] [JBoss JIRA] (TEIID-3208) Remove outer join based solely on join predicates
[
https://issues.jboss.org/browse/TEIID-3208?page=com.atlassian.jira.plugin...
]
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)