]> granicus.if.org Git - postgresql/commit
Don't try to optimize EXISTS subqueries with empty FROM-lists: we need to
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 8 Dec 2008 00:16:09 +0000 (00:16 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 8 Dec 2008 00:16:09 +0000 (00:16 +0000)
commit173a6760278f4c25aaa41c3ed70bae6fecb732aa
tree1962f5c9f63d1311f7736ad45e4b813251a0e356
parentaa7f00464d60f02ee0b1d66b72c8a2a2734f3907
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.
src/backend/optimizer/plan/subselect.c