Re: BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: crvv(dot)mail(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"
Date: 2017-02-02 22:48:05
Message-ID: 18419.1486075685@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

crvv(dot)mail(at)gmail(dot)com writes:
> SELECT '1' IN (SELECT (SELECT '1'::BOOL))
> Error message is "plan should not reference subplan's variable".

Seems to be a problem with pasting on Material nodes at the last minute.
As a short-term workaround, you might try turning off enable_material.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2017-02-03 03:16:49 Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)?
Previous Message David G. Johnston 2017-02-02 19:14:26 Re: Parser failed to return an error