]
Steven Hawkins commented on TEIID-5409:
---------------------------------------
This is like a regression introduced by TEIID-4886
left join is ignored
--------------------
Key: TEIID-5409
URL:
https://issues.jboss.org/browse/TEIID-5409
Project: Teiid
Issue Type: Bug
Affects Versions: 10.3.1, 10.3.2
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
Priority: Blocker
Fix For: 11.1, 11.0.1, 10.3.3
Attachments: plan_teiid_10.3.2.txt, plan_teiid_9.1.txt
A query that is run on teiid 9.1 results in 56186 rows.
The same query that is run on teiid 10.3.2 results in 5919 rows.
It seems like the left join is considered as a inner join.
I've attached both query plans.
The queries are exactly the same. Note that on 9.1 we've prefixed table names with
cos2_5_.