[teiid-issues] [JBoss JIRA] (TEIID-4886) Allow join grouping to optimize across left outer joins
Steven Hawkins (JIRA)
issues at jboss.org
Fri May 5 19:23:00 EDT 2017
[ https://issues.jboss.org/browse/TEIID-4886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-4886.
-----------------------------------
Resolution: Done
Updated the grouping logic to look across left outer joins in certain circumstances.
> Allow join grouping to optimize across left outer joins
> -------------------------------------------------------
>
> Key: TEIID-4886
> URL: https://issues.jboss.org/browse/TEIID-4886
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.3
>
>
> In a from clause such as:
> (a.t1 inner join b.t1 ... inner join a.t2 ...) left outer join b.t2 ...
> It is possible to group the b.t1 and b.t2 together, but generally won't be found by the grouping and then ordering logic.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list