Repair planning bug introduced in 7.4: outer-join ON clauses that referenced
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 28 Sep 2005 21:17:50 +0000 (21:17 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 28 Sep 2005 21:17:50 +0000 (21:17 +0000)
commitbf40278227f9218527843bf037b8477db9a8ad08
tree0a53815904d80907c6ae4f68a4f68a8abe17d51a
parent05a311c8c5647cd441fa0451fdb02b0eee824e4c
Repair planning bug introduced in 7.4: outer-join ON clauses that referenced
only the inner-side relation would be considered as potential equijoin clauses,
which is wrong because the condition doesn't necessarily hold above the point
of the outer join.  Per test case from Kevin Grittner (bug#1916).
src/backend/optimizer/plan/initsplan.c
src/backend/optimizer/plan/planmain.c
src/include/optimizer/planmain.h