BUG #1555: bug in GROUP BY?

Поиск
Список
Период
Сортировка
От Peter Cottingham
Тема BUG #1555: bug in GROUP BY?
Дата
Msg-id 20050321192004.750E2F0FEB@svr2.postgresql.org
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Zeki
Дата:
Сообщение: Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: BUG #1561: wrong detection of number of parameters in