Postgres Pro
Downloads
Home   >   mailing lists

[BUGS] BUG #14523: Commands which compare with nested subquery expressionfails with "should not reference subplan var" - Mailing list pgsql-bugs

From crvv.mail@gmail.com
Subject [BUGS] BUG #14523: Commands which compare with nested subquery expressionfails with "should not reference subplan var"
Date
Msg-id 20170202053438.1411.21129@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      14523
Logged by:          Wei Congrui
Email address:      crvv.mail@gmail.com
PostgreSQL version: 9.6.1
Operating system:   Linux
Description:

Error message is "plan should not reference subplan's variable"

With all other majar verions, I can get the right result.

If compare with "expression IN (subquery)" or "expression operator ANY
(subquery)", the bug only occurs on BOOL.

If compare with "expression operator ALL (subquery)", other types alse
doesn't work.

I reproduced it on Travis. https://travis-ci.org/crvv/pg


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] [BUGS] Bug in Physical Replication Slots (at least9.5)?
Next
From: crvv.mail@gmail.com
Date:
Subject: [BUGS] BUG #14524: Commands compare with nested subquery expressions failwith "should not reference subplan var"