Repair bug in 8.2's new logic for planning outer joins: we have to allow joins
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 13 Feb 2007 02:31:12 +0000 (02:31 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 13 Feb 2007 02:31:12 +0000 (02:31 +0000)
commit0383c1bd893945cf738791a7c8f32acb2cb3960f
tree1b1301df23d368b6f8b2e560e71ebc2a07392685
parent5e419b13cd594a4333f42373c24a59313007aa9f
Repair bug in 8.2's new logic for planning outer joins: we have to allow joins
that overlap an outer join's min_righthand but aren't fully contained in it,
to support joining within the RHS after having performed an outer join that
can commute with this one.  Aside from the direct fix in make_join_rel(),
fix has_join_restriction() and GEQO's desirable_join() to consider this
possibility.  Per report from Ian Harding.
src/backend/optimizer/README
src/backend/optimizer/geqo/geqo_eval.c
src/backend/optimizer/path/joinrels.c
src/backend/optimizer/plan/initsplan.c