pgsql: Fix an oversight in mergejoin planning: the planner would reject

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Fix an oversight in mergejoin planning: the planner would reject
Дата
Msg-id 20060817170637.EA7939FB25B@postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Fix an oversight in mergejoin planning: the planner would reject a
mergejoin possibility where the inner rel was less well sorted than
the outer (ie, it matches some but not all of the merge clauses that
can work with the outer), if the inner path in question is also the
overall cheapest path for its rel.  This is an old bug, but I'm not
sure it's worth back-patching, because it's such a corner case.
Noted while investigating a test case from Peter Hardman.

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        joinpath.c (r1.105 -> r1.106)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/joinpath.c.diff?r1=1.105&r2=1.106)

В списке pgsql-committers по дате отправления:

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Teach convert_subquery_pathkeys() to handle the case where the
Следующее
От: petere@postgresql.org (Peter Eisentraut)
Дата:
Сообщение: pgsql: Produce a clean failure in configure when dtrace is selected but