Horton

Re: Weird behaviour of ROLLUP/GROUPING

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

View thread View on postgr.es
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: PostgreSQL General <pgsql-general@postgresql.org>
Date: 2019-01-17T07:27:37Z
Lists: pgsql-general 
>>>>> "Guillaume" == Guillaume Lelarge <guillaume@lelarge.info> writes:

 >> I will see about fixing this, somehow.

 Guillaume> Thanks a lot.

I've committed a fix (to all supported branches, since this bug actually
precedes the addition of GROUPING SETS and can be triggered with a
simple GROUP BY if you try hard enough). The regression test says it
works now, but it'd be good if you could try it again on REL_11_STABLE
(at commit e74d8c5085 or later) to check that it fixes your case.

-- 
Andrew (irc:RhodiumToad)

Commits

  1. Postpone aggregate checks until after collation is assigned.