Skip site navigation (1) Skip section navigation (2)

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:25
Message-ID: 20050928211725.712FAD9AED@svr1.postgresql.org (view raw or flat)
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:
----
REL8_0_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        initsplan.c (r1.104 -> r1.104.4.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/initsplan.c.diff?r1=1.104&r2=1.104.4.1)
        planmain.c (r1.81 -> r1.81.4.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/planmain.c.diff?r1=1.81&r2=1.81.4.1)
    pgsql/src/include/optimizer:
        planmain.h (r1.79 -> r1.79.4.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/optimizer/planmain.h.diff?r1=1.79&r2=1.79.4.1)

pgsql-committers by date

Next:From: Tom LaneDate: 2005-09-28 21:17:51
Subject: pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that
Previous:From: Tom LaneDate: 2005-09-28 21:17:03
Subject: pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group