Обсуждение: BUG #1330: Incorrect String Order By In tr_TR Locale

The following bug has been logged online:

Bug reference:      1330
Logged by:          Özgür Çaycı

Email address:      ozgur@cayci.org

PostgreSQL version: 8.0 Beta

Operating system:   Debian Woody

Description:        Incorrect String Order By In tr_TR Locale

Details:

I use 8.0 Beta-5.

I am using a PostgreSQL cluster which I have created with locale tr_TR. When
I use "Order By", the strings are not ordered correctly. The spaces are
ignored when I use "Order By" clause. Here is a sample SQL dump to re-create
this situation:

CREATE TABLE mytable (
    mytext character varying(255)
);

INSERT INTO mytable VALUES ('Güngör, Ahmet');
INSERT INTO mytable VALUES ('Güngör, Bengi');
INSERT INTO mytable VALUES ('Güngördü, Ersin');
INSERT INTO mytable VALUES ('Güngören, Bora');
INSERT INTO mytable VALUES ('Güngör, Erhan');
INSERT INTO mytable VALUES ('Güngör, Erol');

When I try 'Select * FROM mytable ORDER BY mytext ASC'

I get the following output:

Güngör, Ahmet
Güngör, Bengi
Güngördü, Ersin
Güngören, Bora
Güngör, Erhan
Güngör, Erol

The expected result is as follows:

Güngör, Ahmet
Güngör, Bengi
Güngör, Erhan
Güngör, Erol
Güngördü, Ersin
Güngören, Bora

Özgür

This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

--8323328-739246297-1101486737=:29733
Content-Type: TEXT/PLAIN; charset=iso-8859-9; format=flowed
Content-Transfer-Encoding: 8BIT

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Fri, 26 Nov 2004, PostgreSQL Bugs List wrote:

> I use 8.0 Beta-5.
>
> I am using a PostgreSQL cluster which I have created with locale tr_TR. When
> I use "Order By", the strings are not ordered correctly. The spaces are
> ignored when I use "Order By" clause. Here is a sample SQL dump to re-create
> this situation:

<snip>
> When I try 'Select * FROM mytable ORDER BY mytext ASC'
>
> I get the following output:
>
> Güngör, Ahmet
> Güngör, Bengi
> Güngördü, Ersin
> Güngören, Bora
> Güngör, Erhan
> Güngör, Erol
>
> The expected result is as follows:
>
> Güngör, Ahmet
> Güngör, Bengi
> Güngör, Erhan
> Güngör, Erol
> Güngördü, Ersin
> Güngören, Bora


Upgrade to latest glibc. Debian unstable does not have this problem.
http://sources.redhat.com/cgi-bin/cvsweb.cgi/libc/localedata/locales/tr_TR?cvsroot=glibc

See

http://yunus.listweb.bilkent.edu.tr/Linux/linux-programlama/2004/May/0061.html
and all mails in the thread for more information.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org                devrim.gunduz~linux.org.tr
             http://www.tdmsoft.com
             http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBp1qStl86P3SPfQ4RAncwAJ9hXpZjz7FF3I/LgEKrVFqhvbbtVgCgtvsl
89QTPJs/hMk2jY292mGY8Iw=
=kPSL
-----END PGP SIGNATURE-----
--8323328-739246297-1101486737=:29733--