Re: [HACKERS] 9.6beta subplan target list bug

2016-07-23 Thread Tom Lane
Jeff Janes writes: > Found a bug: Fixed, thanks. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] 9.6beta subplan target list bug

2016-07-23 Thread Jeff Janes
Found a bug: create table foo as select x, floor(random()*100)::int as y, floor(random()*100)::int as z from generate_series(1,100) f(x); explain select count(y) filter (where y<0.01) from foo where x < 1; ERROR: variable not found in subplan target list STATEMENT: select count(y) filt