Re: BUG #8118: Wrong sorting text

also reproduce on SUSE linux 10 x86_64 pgsql9.2.4:

test=# SELECT t.name
FROM
(
SELECT '_A'::varchar as name
UNION ALL
SELECT ' B'::varchar
) t
ORDER BY t.name;
name
------
_A
B
(2 rows)

test=# SELECT t.name
FROM
(
SELECT '_A'::varchar as name
UNION ALL
SELECT ' A'::varchar
) t
ORDER BY t.name;
name
------
A
_A
(2 rows)

2013/4/27 <whiplash(at)bss(dot)org(dot)ua>

> The following bug has been logged on the website:
>
> Bug reference: 8118
> Logged by: whiplash
> Email address: whiplash(at)bss(dot)org(dot)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.
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

--
Jov
blog: http:amutu.com/blog <http://amutu.com/blog>