Hi all, it seems that in last versions on sqlite3 LIKE clause stopped to use indexes; I created a new empty database with SQLIte 3.6.13 and I run these statements :
CREATE TABLE TEST (TEXT_1 text PRIMARY KEY, TEXT_2 text, TEXT_3 text COLLATE NOCASE); CREATE INDEX TEST_IDX_2 ON TEST (TEXT_2); CREATE INDEX TEST_IDX_3 ON TEST (TEXT_3); Running explain query plan on "select * from test where text_3 like 'x';", I have the following result: 0|0|TABLE test WITH INDEX TEST_IDX_3 And it's what I expected. If I execute the some statements in SQLite 3.6.16 and 3.6.19, I have this result: 0|0|TABLE test So It's not using the index as in 3.6.13 version. The some if I try to use the operator GLOB with field text_2: in SQLite 3.6.13 it uses the TEST_IDX_2 index but it's not used in SQLite 3.6.19. Any suggestions? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
