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

Поиск
Список
Период
Сортировка
От tgl@svr1.postgresql.org (Tom Lane)
Тема pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that
Дата
Msg-id 20050928211751.0F468D9B0A@svr1.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Repair planning bug introduced in 7.4: outer-join ON clauses that
Следующее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Mention fix for bug #1916 in release notes for affected versions.