left join is reversed --------------------- Key: TEIID-5409 URL: https://issues.jboss.org/browse/TEIID-5409 Project: Teiid Issue Type: Bug Components: Query Engine 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 reversed. 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_.