BUG #2317: Wrong sorting order for (VW)

Поиск
Список
Период
Сортировка
От TomasKlockar
Тема BUG #2317: Wrong sorting order for (VW)
Дата
Msg-id 20060313155522.234FDF0A02@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2317: Wrong sorting order for (VW)  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: BUG #2317: Wrong sorting order for (VW)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2317
Logged by:          TomasKlockar
Email address:      tomask@omicron.se
PostgreSQL version: 7.3.2/7.4.7
Operating system:   linux(fedora)
Description:        Wrong sorting order for (VW)
Details:

SELECT cname FROM clients ORDER BY cname;

sorts W before V and that is a mistake.

the result is

V
W
WHI
Vi
Wi
Volvo

Correct order would be to place all vV before all wW.

I think the database was initialized with UTF8 but it might have been
ISO_8859-1, however the error is easily repeatable and ill be happy to
provide a dump.

I tested this on 7.3.2 and 7.4.7 and the error was repeatable.

regards,

/Tomas

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Teofilo Santos"
Дата:
Сообщение: BUG #2316: problems when Restore Backup in RHEL4
Следующее
От: "L.Jumadi"
Дата:
Сообщение: BUG #2314: The Order changed?