BUG #2286: Wrong index creation with cs_CZ locales and HYPHEN

From: "David Sauer" <profa(at)profa(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2286: Wrong index creation with cs_CZ locales and HYPHEN
Date: 2006-02-27 14:39:37
Message-ID: 20060227143937.53962F0B03@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2286
Logged by: David Sauer
Email address: profa(at)profa(dot)cz
PostgreSQL version: 8.1.2, 8.1.3
Operating system: Linux (libc6), debian
Description: Wrong index creation with cs_CZ locales and HYPHEN
Details:

I have table:

CREATE TABLE m (i TEXT);
CREATE INDEX myidx ON m(i);

... INSERT about 2000 values INTO m in the form
INSERT INTO m VALUES ('some-hack-1');
INSERT INTO m VALUES ('some-hack-2');
INSERT INTO m VALUES ('some-hack-3');
INSERT INTO m VALUES ('some-hack-4');
....... approx 2000 values with 'HYPHEN' (-)

VACUUM FULL ANALYZE;

now, the query:
SELECT * FROM m WHERE i = 'some-hack-4';

finds nothing ...

but:

SELECT * FROM m WHERE i || '' = 'some-hack-4';

finds expected row (but without index use, so it is slow).

The problem is between libc6 2.3.2 and libc6 2.3.6, definition files are
stored at:

http://img.123shop.cz/gimg/Popis/a.zip

Problem is probably in libc6 locales, but postgresql developer knows more
about libc6 ... (not true in opposite direction ?)

I'am running current version of debian linux, postgres 8.1.2 or 8.1.3
compiled myself. Feel free to contact me for more details.

Thank You,

David Sauer

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2006-02-27 17:18:09 Re: BUG #2284: missing sequence number
Previous Message Nicholas Vinen 2006-02-27 13:46:26 BUG #2285: Can not access database after successful PITR - file naming problems