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
