pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that
Date: 2005-09-28 21:17:51
Message-ID: 20050928211751.0F468D9B0A@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Tags:
----
REL7_4_STABLE

Modified Files:
--------------
pgsql/src/backend/optimizer/plan:
initsplan.c (r1.91.2.2 -> r1.91.2.3)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/initsplan.c.diff?r1=1.91.2.2&r2=1.91.2.3)
planmain.c (r1.78 -> r1.78.4.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planmain.c.diff?r1=1.78&r2=1.78.4.1)
pgsql/src/include/optimizer:
planmain.h (r1.75 -> r1.75.4.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/planmain.h.diff?r1=1.75&r2=1.75.4.1)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-09-28 21:22:13 pgsql: Mention fix for bug #1916 in release notes for affected versions.
Previous Message Tom Lane 2005-09-28 21:17:25 pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that