Re: [BUGS] Improper const-evaluation of HAVING with grouping sets and subquery pullup

Andrew Gierth <andrew@tao11.riddles.org.uk>

From: Andrew Gierth <andrew@tao11.riddles.org.uk>

To: Michael Paquier <michael.paquier@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Heikki Linnakangas <hlinnaka@iki.fi>, Pg Bugs <pgsql-bugs@postgresql.org>

Date: 2017-11-29T06:44:41Z

Lists: pgsql-bugs

>>>>> "Michael" == Michael Paquier <michael.paquier@gmail.com> writes:

 Michael> Tom, are you planning to finish wrapping up this one? For now
 Michael> I am moving it to next CF.

I can take it if Tom and Heikki are busy.

-- 
Andrew.

Commits

Fix incorrect handling of subquery pullup in the presence of grouping sets.
- ff99d7761aa4 9.5.11 landed
- d3ca1a6c3721 10.2 landed
- 90947674fc98 11.0 landed
- 6520d4a96928 9.6.7 landed
Make setrefs.c match by ressortgroupref even for plain Vars.
- 6a81ba1d4d26 10.1 landed
- 37b4e0fe9964 9.6.6 landed
- 08f1e1f0a47b 11.0 landed
Make the upper part of the planner work by generating and comparing Paths.
- 3fc6e2d7f5b6 9.6.0 cited