[teiid-issues] [JBoss JIRA] (TEIID-5566) Outer join prevents dependent join creation
Steven Hawkins (Jira)
issues at jboss.org
Fri Dec 7 14:40:00 EST 2018
[ https://issues.jboss.org/browse/TEIID-5566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-5566:
----------------------------------
Attachment: (was: missing_dep_inner_plan.txt)
> Outer join prevents dependent join creation
> -------------------------------------------
>
> Key: TEIID-5566
> URL: https://issues.jboss.org/browse/TEIID-5566
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 11.0.1
> Reporter: Mike Higgins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 11.1.2, 12.0, 11.2.2
>
>
> This query:
> Edit: <I was asked to remove the query text from the top level description>
> The query is between three different databases chained together with joins (see plans).
> does not create a dependent join on the middle table. If you change the join to the middle table to inner, it does.
> Plans and debug plans for both cases are attached. As a note, an older version of Teiid that we are also using (9.3.4) always creates the dependent join. 11.0.1 and 10.2.3 do not create the dependent join if the table is outer joined.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
More information about the teiid-issues
mailing list