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)
commit0cae3ddf51841fa2314b3a83f0e9ea538a9cd4ed
tree04ef7ef7bbc15c88b6edb1bdbaa11fd7c4ddad4c
parentb403e5bd036e8e18e7464b2d74ce58a55ab63dbd
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