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)
commit196c9d289e9becdc576c48dcc7e12d52b0bf1833
treedc2081fb45efc6afe45d0b0b12d0adbb5f66c9e1
parent6a2c659b31879d269c39374757968561b689bf03
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