Re: join plan with unexpected var clauses

2021-02-03 Thread Tom Lane
Luc Vlaming writes: > Given the testcase we see that the outer semi join tries to join the > outer with the inner table id columns, even though the middle table id > column is also there. Is this expected behavior? I don't see anything greatly wrong with it. The planner has concluded that _inn

join plan with unexpected var clauses

2021-02-02 Thread Luc Vlaming
Hi, At a customer we came across a curious plan (see attached testcase). Given the testcase we see that the outer semi join tries to join the outer with the inner table id columns, even though the middle table id column is also there. Is this expected behavior? The reason i'm asking is two-f