[sqlite] small bug using like/glob without wildcard?

Dear all, I'm looking to resolve a small problem using like/glob function with indexes starting from version 3.6.23.1 (It worked with 3.6.13) Using a where condition such as "WHERE MY_INDEXED_COLUMN LIKE 'X' " ,sqlite doesn't use the index on that column while it uses the index if I use a wild

[sqlite] Like doesn't always use index with callate nocase

Dear all, I have a problem using sqlite 3.6.22. I create a table with callate nocase definition and an index as following: create table Test ( Text_Value text collate nocase ); create index Test_Text_Value_Index on Test (Text_Value collate nocase); Running the statement: select * from Tes

[sqlite] R: RE: Like do not use index as previous version

ta: 21/10/2009 20.15 >A: , "General Discussion of SQLite Database" >Ogg: RE: [sqlite] Like do not use index as previous version > > > >- Original Message- >From: sqlite-users-boun...@sqlite.org >[mailto:sqlite- users-boun...@sqlite.org] On Behalf Of ge...@iol.

[sqlite] Like do not use index as previous version

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);