Horton

Re: Weird behaviour of ROLLUP/GROUPING

Guillaume Lelarge <guillaume@lelarge.info>

View thread View on postgr.es
From: Guillaume Lelarge <guillaume@lelarge.info>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: PostgreSQL General <pgsql-general@postgresql.org>
Date: 2019-01-17T08:23:29Z
Lists: pgsql-general 
Le jeu. 17 janv. 2019 à 08:27, Andrew Gierth <andrew@tao11.riddles.org.uk>
a écrit :

> >>>>> "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.
>
>
I checked on REL9_6_STABLE and REL_11_STABLE, and it works great. Thank a
lot for the quick fix!


-- 
Guillaume.

Commits

  1. Postpone aggregate checks until after collation is assigned.