From: David Hartwig <daybee@bellatlantic.net>
To: Vadim Mikheev <vadim@krs.ru>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: PostgreSQL-development <hackers@postgreSQL.org>
Subject: Re: [HACKERS] Open 6.4 items
Date: Thu, 03 Sep 1998 23:40:49 -0400
Message-ID: <35EF6140.248BCF20@bellatlantic.net> (raw)
References: <199808290440.AAA29962@candle.pha.pa.us>
<35EF619B.14FADDCE@krs.ru>
Vadim Mikheev wrote:
> Bruce Momjian wrote:
> >
> > low level locking - status?
>
> Work in progress -:))
> This is 6.5 item...
>
> But this is 6.4 item from TODO:
> * select upper(usename), count(usesysid) from pg_shadow group by 1;
> --> CRASH
>
> - group by function is BROKEN!!!
>
> 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.
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.
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: daybee@bellatlantic.net, vadim@krs.ru, maillist@candle.pha.pa.us, hackers@postgreSQL.org
Subject: Re: [HACKERS] Open 6.4 items
In-Reply-To: <35EF6140.248BCF20@bellatlantic.net>
* 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