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

From: CR VV <crvv(dot)mail(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-07 12:56:00
Message-ID: CAPxZtjFpCYheCi0gENwdggZCSVVR32d2MaGdjDyWTx130jV7Xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)sss(dot)pgh(dot)pa(dot)us>:

> 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 naveenallin 2017-02-07 13:56:35 BUG #14531: server process (PID 12714) was terminated by signal 11: Segmentation fault
Previous Message Peter Geoghegan 2017-02-07 09:03:32 Re: BUG #14526: no unique or exclusion constraint matching the ON CONFLICT