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.
[~accountid:557058:0222998d-a0c8-4789-91ec-6a92d10dfb9a] stated that that condition should be pushed down into the tablereference, e.g ` ight right join (select * from child_tbl where disc = 'child_a') c on ...`
The aforementioned tests have been disabled for now, but should be reenabled when this is fixed. |
|
