Received: from iconmail.bellatlantic.net (iconmail.bellatlantic.net [199.173.162.30]) by hub.org (8.8.8/8.7.5) with ESMTP id BAA07304 for ; Fri, 4 Sep 1998 01:19:25 -0400 (EDT) Received: from bellatlantic.net (client196-126-43.bellatlantic.net [151.196.126.43]) by iconmail.bellatlantic.net (IConNet Sendmail) with ESMTP id BAA19394; Fri, 4 Sep 1998 01:16:27 -0400 (EDT) Sender: postgres@iconmail.bellatlantic.net Message-ID: <35EF3A08.1E3E48F5@bellatlantic.net> Date: Thu, 03 Sep 1998 20:53:28 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.04 [en] (X11; I; Linux 2.0.29 i586) MIME-Version: 1.0 To: Vadim Mikheev CC: Bruce Momjian , PostgreSQL-development Subject: Re: [HACKERS] Open 6.4 items References: <199808290440.AAA29962@candle.pha.pa.us> <35EF619B.14FADDCE@krs.ru> <35EF6140.248BCF20@bellatlantic.net> <35EF6A65.C5CC68FB@krs.ru> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Vadim Mikheev wrote: > > > > 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... You may be referring to me. I made some changes to the SortGroupBy parse node to allow espressions. I didn't touch the GroupClause node. Also, I think this bug arrived before I made my changes in 6.4