BUG #14523: Commands which compare with nested subquery expression fails with "should not reference subplan var"

From: crvv(dot)mail(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14523: Commands which compare with nested subquery expression fails with "should not reference subplan var"
Date: 2017-02-02 05:34:38
Message-ID: 20170202053438.1411.21129@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14523
Logged by: Wei Congrui
Email address: crvv(dot)mail(at)gmail(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message crvv.mail 2017-02-02 06:00:20 BUG #14524: Commands compare with nested subquery expressions fail with "should not reference subplan var"
Previous Message Kyotaro HORIGUCHI 2017-02-02 02:28:29 Re: [HACKERS] Bug in Physical Replication Slots (at least 9.5)?