Received: from iconmail.bellatlantic.net (iconmail.bellatlantic.net
	[199.173.162.30]) by hub.org (8.8.8/8.7.5) with ESMTP id
	AAA01533 for <hackers@postgreSQL.org>;
	Fri, 4 Sep 1998 00:07:32 -0400 (EDT)
Received: from bellatlantic.net (client196-126-7.bellatlantic.net
	[151.196.126.7])
	by iconmail.bellatlantic.net (IConNet Sendmail) with ESMTP id AAA09167;
	Fri, 4 Sep 1998 00:03:56 -0400 (EDT)
Message-ID: <35EF6140.248BCF20@bellatlantic.net>
Date: Thu, 03 Sep 1998 23:40:49 -0400
From: David Hartwig <daybee@bellatlantic.net>
Organization: Home
X-Mailer: Mozilla 4.06 [en] (Win98; I)
MIME-Version: 1.0
To: Vadim Mikheev <vadim@krs.ru>
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>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



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.