From: Vadim Mikheev <vadim@krs.ru>
To: David Hartwig <daybee@bellatlantic.net>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: PostgreSQL-development <hackers@postgreSQL.org>
Subject: Re: [HACKERS] Open 6.4 items
Date: Fri, 04 Sep 1998 12:19:49 +0800
Message-ID: <35EF6A65.C5CC68FB@krs.ru> (raw)
References: <199808290440.AAA29962@candle.pha.pa.us>
<35EF619B.14FADDCE@krs.ru>
<35EF6140.248BCF20@bellatlantic.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: vadim@krs.ru, daybee@bellatlantic.net, maillist@candle.pha.pa.us, hackers@postgreSQL.org
Subject: Re: [HACKERS] Open 6.4 items
In-Reply-To: <35EF6A65.C5CC68FB@krs.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox