This content has been marked as final.
Show 3 replies
-
1. Re: Pushing left outer joins in a multi-source query
shawkins Aug 25, 2015 4:12 PM (in response to mike_higgins)So you have:
(s1.t1 t1 left outer join s2.t2 t2 on (t1.id = t2.id)) left outer join s2.t3 t3 on (t2.id2 = t3.id2)
And you need:
s1.t1 t1 left outer join (s2.t2 t2 left outer join s2.t3 t3 on (t2.id2 = t3.id2)) on (t1.id = t2.id)
That is allowable assuming that the join predicates are not satisfiable for null values (which is true here with the equi-joins). Unfortunately we aren't yet looking to perform this reordering. Can you log an issue for that?
-
2. Re: Pushing left outer joins in a multi-source query
mike_higgins Aug 25, 2015 5:48 PM (in response to shawkins) -
3. Re: Pushing left outer joins in a multi-source query
shawkins Sep 4, 2015 10:52 AM (in response to mike_higgins)I've added an initial commit, but will likely refine this a little more. So this will be included in Teiid 8.12 CR1.