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

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that
Date
Msg-id 20050928211751.0F468D9B0A@svr1.postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Mention fix for bug #1916 in release notes for affected versions.