pgsql: Don't try to optimize EXISTS subqueries with empty FROM-lists: we

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Don't try to optimize EXISTS subqueries with empty FROM-lists: we
Дата
Msg-id 20081208001609.A28087545A5@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Дерево обсуждения 
Log Message:
-----------
Don't try to optimize EXISTS subqueries with empty FROM-lists: we need to
form a join and that case doesn't have anything to join to.  (We could
probably make it work if we didn't pull up the subquery, but it seems to
me that the case isn't worth extra code.)  Per report from Greg Stark.

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        subselect.c (r1.142 -> r1.143)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/subselect.c?r1=1.142&r2=1.143)

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

Предыдущее
От: alvherre@postgresql.org (Alvaro Herrera)
Дата:
Сообщение: pgsql: Desultorily enclose programlisting tags in CDATA, to get rid of
Следующее
От: itagaki@pgfoundry.org (User Itagaki)
Дата:
Сообщение: reorg - pg_reorg: Imported Sources