pgsql: Repair bug in 8.2's new logic for planning outer joins: we have

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Repair bug in 8.2's new logic for planning outer joins: we have
Date: 2007-02-13 02:31:12
Message-ID: 20070213023112.357509FB32A@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
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.

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
pgsql/src/backend/optimizer:
README (r1.35 -> r1.35.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/README.diff?r1=1.35&r2=1.35.2.1)
pgsql/src/backend/optimizer/geqo:
geqo_eval.c (r1.81.2.1 -> r1.81.2.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/geqo/geqo_eval.c.diff?r1=1.81.2.1&r2=1.81.2.2)
pgsql/src/backend/optimizer/path:
joinrels.c (r1.81.2.1 -> r1.81.2.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinrels.c.diff?r1=1.81.2.1&r2=1.81.2.2)
pgsql/src/backend/optimizer/plan:
initsplan.c (r1.123.2.2 -> r1.123.2.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/initsplan.c.diff?r1=1.123.2.2&r2=1.123.2.3)

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2007-02-13 15:01:52 pgsql: Properly parse Makefile after change from := to =.
Previous Message Tom Lane 2007-02-13 02:31:03 pgsql: Repair bug in 8.2's new logic for planning outer joins: we have