Skip site navigation (1) Skip section navigation (2)

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

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Don't try to optimize EXISTS subqueries with empty FROM-lists: we
Date: 2008-12-08 00:16:09
Message-ID: 20081208001609.A28087545A5@cvs.postgresql.org (view raw or flat)
Thread:
Lists: 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 by date

Next:From: User ItagakiDate: 2008-12-08 04:32:11
Subject: reorg - pg_reorg: Imported Sources
Previous:From: Alvaro HerreraDate: 2008-12-07 23:46:39
Subject: pgsql: Desultorily enclose programlisting tags in CDATA, to get rid of

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group