Sender: root@dune.krs.ru
Message-ID: <35EF6A65.C5CC68FB@krs.ru>
Date: Fri, 04 Sep 1998 12:19:49 +0800
From: Vadim Mikheev <vadim@krs.ru>
Organization: OJSC Rostelecom (Krasnoyarsk)
MIME-Version: 1.0
To: David Hartwig <daybee@bellatlantic.net>
CC: Bruce Momjian <maillist@candle.pha.pa.us>,
	PostgreSQL-development <hackers@postgreSQL.org>
Subject: Re: [HACKERS] Open 6.4 items
References: <199808290440.AAA29962@candle.pha.pa.us>
	<35EF619B.14FADDCE@krs.ru> <35EF6140.248BCF20@bellatlantic.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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