Re: BUG #2317: Wrong sorting order for (VW) - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: BUG #2317: Wrong sorting order for (VW)
Date
Msg-id 20060315152751.U69512@megazone.bigpanda.com
Whole thread Raw
In response to BUG #2317: Wrong sorting order for (VW)  ("TomasKlockar" <tomask@omicron.se>)
List pgsql-bugs
On Mon, 13 Mar 2006, TomasKlockar wrote:

>
> 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.

I think the most important thing we'd need to know is what locale the
database was initialized with in order to try to reproduce.

If you put similar data in a file and use the unix "sort" command with the
same locale, do you get the same order?

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: BUG #2314: The Order changed?
Next
From: Tom Lane
Date:
Subject: Re: BUG #2315: Crash engine after modify "active" function