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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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)

Browse pgsql-committers by date

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