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

Поиск
Список
Период
Сортировка
От CR VV
Тема Re: [BUGS] BUG #14524: Commands compare with nested subqueryexpressions fail with "should not reference subplan var"
Дата
Msg-id CAPxZtjFpCYheCi0gENwdggZCSVVR32d2MaGdjDyWTx130jV7Xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [BUGS] BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"
Список 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@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 по дате отправления: