[teiid-issues] [JBoss JIRA] (TEIID-3386) Mixed resutl with (double) full outer join and where clause

Mixed resutl with (double) full outer join and where clause ----------------------------------------------------------- Key: TEIID-3386 URL: https://issues.jboss.org/browse/TEIID-3386 Project: Teiid Issue Type: Bug Affects Versions: 8.7.1 Reporter: Juraj Duráni Assignee: Steven Hawkins Attachments: server.log If a query contains double FULL OUTER JOIN and WHERE clause that contains condition on column from last table, teiid returns mixed result (underlying oracle10). Query: SELECT BQT1.SmallA.IntKey AS SmallA_IntKey, BQT2.MediumB.IntKey AS MediumB_IntKey, BQT2.LargeB.IntKey AS LargeB_IntKey FROM (BQT1.SmallA FULL OUTER JOIN BQT2.MediumB ON BQT1.SmallA.IntKey = BQT2.MediumB.IntKey) FULL OUTER JOIN BQT2.LargeB ON BQT2.MediumB.IntKey = BQT2.LargeB.IntKey WHERE BQT2.LargeB.IntKey < 1500 ORDER BY LargeB_IntKey, MediumB_IntKey, SmallA_IntKey; Actual result: 0 0 0 1 1 1 2 2 2 3 3 3 ... ... ... 49 49 49 50 50 50 ... ... ... 999 999 999 <null> <null> 1000 ... ... ... <null> <null> 1499 Expected result: 0 0 0 1 1 1 2 2 2 3 3 3 ... ... ... 49 49 49 <null> 50 50 ... ... ... 999 999 999 <null> <null> 1000 ... ... ... <null> <null> 1499