[Firebird-devel] Firebird 2 RC2: STARTS WITH not working properly on an indexed column with charset UTF8

[Michael W. <web...@de...>]

Hi,
i created a simple test table and I've run across a problem with an 
indexed column:

CREATE TABLE PERSON (ID NUMERIC(18, 0) NOT NULL,
         NACHNAME VARCHAR(50) CHARACTER SET UTF8 NOT NULL COLLATE UNICODE,
         VORNAME VARCHAR(50) CHARACTER SET UTF8 NOT NULL COLLATE UNICODE,
PRIMARY KEY (ID));
insert into person (id,nachname,vorname) values (1,'Doe','John');
insert into person (id,nachname,vorname) values (2,'Doe','Jane');
// works ok so far, the select returns 2 rows
select * from person where vorname starts with 'J';

//now create an index
create index person_vorname on person(vorname);
//both return 0 rows
select * from person where vorname starts with 'J';
select * from person where vorname like 'J%';
//this works, as it forces to ignore the index
select * from person where vorname||'' starts with 'J';

I have not tested it with other charsets/collations yet. I hope this is 
a proper bug report.

kind regards,
Michael
-- 
/============================================================\
|       Michael Weissenbacher <web...@de...>       |
|                  http://www.dermichi.com/                  |
|       "When in doubt, tell the truth" -- Mark Twain        |
\============================================================/