BUG #1555: bug in GROUP BY? - Mailing list pgsql-bugs

From Peter Cottingham
Subject BUG #1555: bug in GROUP BY?
Date
Msg-id 20050321192004.750E2F0FEB@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1555: bug in GROUP BY?  (Michael Fuhr <mike@fuhr.org>)
Re: BUG #1555: bug in GROUP BY?  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1555
Logged by:          Peter Cottingham
Email address:      cottingh@rci.rutgers.edu
PostgreSQL version: 7.4.7-3.FC3.1
Operating system:   Linix
Description:        bug in GROUP BY?
Details:

Appears that the GROUP BY clause is not working correctly on new server
(GROUP BY should order the result set in ASCENDING order, NOT DESCENDING
order.)  See below

**********************************
select dom_id, count(ste_id) as ste_count
from ste
group by dom_id
**********************************

ERRONEOUS RESULT SET:

dom_id  ste_count
-----------
5 4
3 12
2 50
1 53

pgsql-bugs by date:

Previous
From: Zeki
Date:
Subject: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
Next
From: Oliver Jowett
Date:
Subject: Re: BUG #1561: wrong detection of number of parameters in