BUG #1555: bug in GROUP BY?

Поиск
Список
Период
Сортировка
Искать
От
Peter Cottingham
Тема
BUG #1555: bug in GROUP BY?
Дата
Msg-id
20050321192004.750E2F0FEB@svr2.postgresql.org
Список
Дерево обсуждения
BUG #1555: bug in GROUP BY? "Peter Cottingham" <cottingh@rci.rutgers.edu>
Re: BUG #1555: bug in GROUP BY? Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: BUG #1555: bug in GROUP BY? Michael Fuhr <mike@fuhr.org>
Re: BUG #1555: bug in GROUP BY? Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
От: Zeki
Дата:
От: Oliver Jowett
Дата:
FAQ