Skip site navigation (1) Skip section navigation (2)

BUG #1555: bug in GROUP BY?

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Dennis van DokDate: 2005-03-21 21:06:49
Subject: BUG #1556: psql ON_ERROR_STOP returns 3 when scripts ends in C style comment
Previous:From: Guido BarosioDate: 2005-03-21 17:22:02
Subject: BUG #1554: wrong character on the sjis_to_utf8.map file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group