From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: create index regression fail |
Date: | 2012-01-12 19:38:02 |
Message-ID: | 1326397000-sup-9175@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Excerpts from Jaime Casanova's message of jue ene 12 16:22:17 -0300 2012:
> On Thu, Jan 12, 2012 at 1:59 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Jaime Casanova <jaime(at)2ndquadrant(dot)com> writes:
> >> the query where the regression fails is:
> >
> >> SELECT count(*) FROM dupindexcols
> >> WHERE f1 > 'LX' and id < 1000 and f1 ~<~ 'YX';
> >
> >> my first theory was that it was because some locale because mine is
> >> es_EC.UTF-8 but the content of the table doesn't justify that,
> >
> > [ experiments... ] Looks like you're wrong about that. In ec_EC locale
> > on my machine, the test accepts these rows that are not accepted in C
> > locale:
> >
> > 223 | LLKAAA
> > 738 | LLEAAA
> >
>
> oh! i remember now a thread where we talk about glibc not doing the
> right thing about this:
> http://archives.postgresql.org/message-id/20081215160148.GF4067@alvh.no-ip.org
>
> an update to that post would be that in that time CH and LL where
> independent letters but sorted as if they weren't, now they both were
> degraded to be a combination of two letters.
Yeah, some of these are pretty recent developments by the "real academia
de la lengua", I guess glibc hasn't gotten word about it 100% yet. On
the other hand I wonder if es_EC is different from other spanish locales
for some reason ...
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-01-12 20:04:32 | Re: pgbench post-connection command |
Previous Message | Kevin Grittner | 2012-01-12 19:23:53 | Re: Remembering bug #6123 |