Postgres Pro
Downloads
Home   >   mailing lists

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

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Don't try to optimize EXISTS subqueries with empty FROM-lists: we
Date
Msg-id 20081208001609.A28087545A5@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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 by date:

Previous
From: alvherre@postgresql.org (Alvaro Herrera)
Date:
Subject: pgsql: Desultorily enclose programlisting tags in CDATA, to get rid of
Next
From: itagaki@pgfoundry.org (User Itagaki)
Date:
Subject: reorg - pg_reorg: Imported Sources