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 |
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:
----
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-28 21:17:51 | pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that |
Previous Message | Tom Lane | 2005-09-28 21:17:03 | pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that |