]
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.