Re: [HACKERS] Open 6.4 items - Mailing list pgsql-hackers

David Hartwig wrote:
>
> >
> > Is anybody working on fix ?
> >
>
> Not I, but I can give you some background.   The crash seems to only
> occur when the argument of the GROUPed by function is not used elsewhere
> in the target list.

Yes, I see that it comes from replace_agg_clause() after
match_varid() call: for some reasons varoattno of
target list var is changed and so var is not matched...

>
> example:
>     select upper(usename), count(usename) from pg_shadow group by 1;
>         OK
>     select upper(usename), count(oid) from pg_shadow group by 1;
>         CRASH
>
> It did work in 6.3.

As I remember, someone re-implemented GroupBy node in 6.4...

Vadim