Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgsql: Fix an oversight in convert_EXISTS_sublink_to_join: we can't

pgsql: Fix an oversight in convert_EXISTS_sublink_to_join: we can't

From
tgl@postgresql.org (Tom Lane)
Date:
Log Message:
-----------
Fix an oversight in convert_EXISTS_sublink_to_join: we can't convert an
EXISTS that contains a WITH clause.  This would usually lead to a
"could not find CTE" error later in planning, because the WITH wouldn't
get processed at all.  Noted while playing with an example from Ken Marshall.

Modified Files:
--------------
    pgsql/src/backend/optimizer/plan:
        subselect.c (r1.157 -> r1.158)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/subselect.c?r1=1.157&r2=1.158)