Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14524: Commands compare with nested subqueryexpressions fail with "should not reference subplan var" - Mailing list pgsql-bugs

From CR VV
Subject Re: [BUGS] BUG #14524: Commands compare with nested subqueryexpressions fail with "should not reference subplan var"
Date
Msg-id CAPxZtjFpCYheCi0gENwdggZCSVVR32d2MaGdjDyWTx130jV7Xg@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
Thanks for your reply.

By turning off 'enable_material', I can execute these SQL successfully.

Will this be fixed in minor release or next major release?


2017-02-03 6:48 GMT+08:00 Tom Lane <tgl@sss.pgh.pa.us>:
crvv.mail@gmail.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



pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [BUGS] BUG #14526: no unique or exclusion constraint matching theON CONFLICT
Next
From: naveenallin@gmail.com
Date:
Subject: [BUGS] BUG #14531: server process (PID 12714) was terminated by signal 11:Segmentation fault