Request a Demo
Home   >   mailing lists

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

From [email protected]
Subject [BUGS] BUG #14523: Commands which compare with nested subquery expressionfails with "should not reference subplan var"
Date
Msg-id [email protected]
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:      [email protected]
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 ([email protected])
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: [email protected]
Date:
Subject: [BUGS] BUG #14524: Commands compare with nested subquery expressions failwith "should not reference subplan var"