Re: create index regression fail

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: create index regression fail
Date: 2012-01-12 18:59:49
Message-ID: 25719.1326394789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

I'll change the lower bound to 'MA' and see if that's any more portable.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2012-01-12 19:19:54 Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.
Previous Message Tom Lane 2012-01-12 18:32:47 Re: Remembering bug #6123