Hi PostgreSQL developers!
I recently got the email below and confirmed that I get the same
broken collation order in de_DE.UTF-8 as the original reporter (who
probably uses pt_PT.something). It works fine in C, though.
System: Debian unstable, according to the reporter the bug does not
happen under Windows.
Any idea?
Thank you!
Martin
----- Forwarded message from fgaroso <fgaroso@ig.com.br> -----
To: mpitt@debian.org
From: fgaroso <fgaroso@ig.com.br>
Subject: Bug PostgreSQL
Date: Wed, 1 Feb 2006 14:12:04 -0200
X-Spam-Status: No, score=2.1 required=4.0 tests=BAYES_50,DNS_FROM_RFC_POST,
RCVD_IN_NJABL_PROXY autolearn=no version=3.0.3
Content-Description: Mail message body
Version: Unstable package postgresql-8.1
Date Download: 2006-02-01 (apt-get)
Description:
create table tmp ( name char(30) );
create index tmp_idx on tmp (name);
insert into tmp values ( 'SUEKO' );
insert into tmp values ( 'SUE E' );
insert into tmp values ( 'SUE T' );
select * from tmp order by name;
Returns incorrect order:
teste=# select * from tmp order by name desc;
name
--------------------------------
SUE T
SUEKO
SUE E
(3 registros)
Note:
Version for windows tested and OK ;)
----- End forwarded message -----
--
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
