From: | "Peter Cottingham" <cottingh(at)rci(dot)rutgers(dot)edu> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1555: bug in GROUP BY? |
Date: | 2005-03-21 19:20:04 |
Message-ID: | 20050321192004.750E2F0FEB@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1555
Logged by: Peter Cottingham
Email address: cottingh(at)rci(dot)rutgers(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis van Dok | 2005-03-21 21:06:49 | BUG #1556: psql ON_ERROR_STOP returns 3 when scripts ends in C style comment |
Previous Message | Guido Barosio | 2005-03-21 17:22:02 | BUG #1554: wrong character on the sjis_to_utf8.map file |