See JoinWithSingleTableInheritanceTest.testRightJoinOnSingleTableInheritance`and JoinWithSingleTableInheritanceTest.testFullJoinOnSingleTableInheritance for examples of this.

The problem is that the {{<tablealias>.dtype=xxx}}part gets added to the on clause, and this leads to incorrect results.

Christian Beikov stated that that condition should be pushed down into the tablereference, e.g `ight join (select * from child_tbl where disc = 'child_a') c on ...`