From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: rules regression test failed on mingw |
Date: | 2008-12-22 00:22:29 |
Message-ID: | 3073cc9b0812211622q560eb96fne18a1f07b0938caa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Dec 15, 2008 at 11:27 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I wrote:
>> But I don't see this sorting behavior with glibc on Linux (Fedora 9 to
>> be exact, testing LC_COLLATE=es_ES.utf8).
>
doh! i'm seeing this again in HEAD (and in 8.3.5) when executing make
installcheck on openSuse 11
when initdb'ing i get this, that i think is right 'cause i was using
--locale=es_EC.UTF8:
The database cluster will be initialized with locale es_EC.UTF8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "spanish".
then i can confirm that in psql:
postgres=# show LC_COLLATE;
lc_collate
------------
es_EC.UTF8
(1 row)
nevertheless i get (and of course failed regression tests):
postgres=# select 'wieck'::text < 'wiech'::text;
?column?
----------
t
(1 row)
postgres=# select 'wieck'::text > 'wiech'::text;
?column?
----------
f
(1 row)
even worse, seems like the ordering is case insensitive in both 8.3.5
and HEAD, is this intended?
regression=# select 'S1' union all select 's1'
regression-# union all
regression-# select 'S2' union all select 's2'
regression-# order by 1;
?column?
----------
s1
S1
s2
S2
(4 rows)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
Attachment | Content-Type | Size |
---|---|---|
regression.diffs | application/octet-stream | 13.1 KB |
version.txt | text/plain | 422 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2008-12-22 01:56:06 | Re: [PATCHES] GIN improvements |
Previous Message | Jeff Davis | 2008-12-22 00:22:20 | Re: GIN index build speed |