BUG #8118: Wrong sorting text - Mailing list pgsql-bugs

From whiplash@bss.org.ua
Subject BUG #8118: Wrong sorting text
Date
Msg-id E1UVnVT-00085i-Ed@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8118: Wrong sorting text  (Jov <amutu@amutu.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8118
Logged by:          whiplash
Email address:      whiplash@bss.org.ua
PostgreSQL version: 9.2.2
Operating system:   Linux (Fedora 11, Fedora 16 and Ubuntu 12.04)
Description:        =


I execute query (1):

SELECT t.name
FROM
(
    SELECT 'AAA AAA' AS name
    UNION ALL
    SELECT 'AAA_AAA'
    UNION ALL =

    SELECT 'BBB_AAA'
    UNION ALL
    SELECT 'BBB AAB'
) t
ORDER BY t.name

and I getting a result:

AAA AAA
AAA_AAA
BBB_AAA
BBB AAB

I think this is result more correct:

AAA AAA
AAA_AAA
BBB AAB
BBB_AAA

On Windows 7 and FreeBSD 9.x query (1) returns correct result.

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #8114: Peer authentication in cgi-perl
Next
From: Jov
Date:
Subject: Re: BUG #8118: Wrong sorting text