OSDN Git Service

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:03 +0000 (02:31 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 13 Feb 2007 02:31:03 +0000 (02:31 +0000)
commitc17117649b9ae23d5290c9626090dcaae333ea59
tree5c0c76478997fe79bc3ff62b77615bf476a67aa1
parent849b0707079e3ba676e2e5407322f20f14f8b076
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