[sqlite] Indexes problem in unicode extension support

[Alexey Pechnikov]

Hello!

I'm using extension for base unicode support 
(http://mobigroup.ru/files/sqlite-ext/unicode/), but in last two releases find 
the problem with indexes by columns with redefined NOCASE collation 
(groups.name autoindex and composite index with 
const_telephony_direction.name): 
=========================
$ sqlite3 :memory:
SQLite version 3.6.18
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> BEGIN TRANSACTION;
sqlite> CREATE TABLE groups
   ...> (
   ...>         name TEXT collate NOCASE UNIQUE NOT NULL DEFAULT ''
   ...> );
sqlite> INSERT INTO "groups" VALUES('Администраторы');
sqlite> CREATE TABLE const_telephony_direction (
   ...>         name text not null,
   ...>         destcode text not null
   ...> );
sqlite> INSERT INTO "const_telephony_direction" 
VALUES('Совинтел_МГМН_старые_кмст','7485');
sqlite> CREATE INDEX const_telephony_direction_complex_idx on 
const_telephony_direction(name,destcode);
sqlite> COMMIT;
sqlite>
sqlite> pragma integrity_check;
rowid 1 missing from index sqlite_autoindex_groups_1
=========================
Without indexes on redefined NOCASE collated fields this database is correct:
=========================
$ sqlite3 :memory:
SQLite version 3.6.18
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
sqlite> BEGIN TRANSACTION;
sqlite> CREATE TABLE groups
   ...> (
   ...>         name TEXT collate NOCASE NOT NULL DEFAULT ''
   ...> );
sqlite> INSERT INTO "groups" VALUES('Администраторы');
sqlite> CREATE TABLE const_telephony_direction (
   ...>         name text not null,
   ...>         destcode text not null
   ...> );
sqlite> INSERT INTO "const_telephony_direction" 
VALUES('Совинтел_МГМН_старые_кмст','7485');
sqlite> CREATE INDEX const_telephony_direction_complex_idx on 
const_telephony_direction(destcode);
sqlite> COMMIT;
sqlite>
sqlite> pragma integrity_check;
ok
=========================
Can anybody help me to to fix it?

Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users