Outer join prevents dependent join creation

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.