The following bug has been logged on the website:
Bug reference: 14524
Logged by: Wei Congrui
Email address: crvv(dot)mail(at)gmail(dot)com
PostgreSQL version: 9.6.1
Operating system: Linux
Description:
SQLs which do not work are
SELECT '1' IN (SELECT (SELECT '1'::BOOL))
SELECT '1' = ANY (SELECT (SELECT '1'::BOOL))
SELECT '1' = ALL (SELECT (SELECT '1'::BOOL))
SELECT '1' = ALL (SELECT (SELECT '1'::TEXT))
SELECT '1' = ALL (SELECT (SELECT '1'::INT))
Similar SQLs but work are
SELECT '1' IN (SELECT (SELECT '1'::INT))
SELECT '1' = ANY (SELECT (SELECT '1'::TEXT))
Error message is "plan should not reference subplan's variable".
With all other majar verions, I can get the right result.
I reproduced it on Travis. https://travis-ci.org/crvv/pg