sqlite> create table blah(id integer primary key not null, x text, y integer not null); sqlite> create index blahindex on blah (y); sqlite> explain query plan select * from blah where y & ? != 0; 0|0|0|SCAN TABLE blah
But other numeric expressions do e.g. sqlite> explain query plan select * from blah where y = ?; 0|0|0|SEARCH TABLE blah USING INDEX blahindex (y=?) sqlite> explain query plan select * from blah where y > ?; 0|0|0|SEARCH TABLE blah USING INDEX blahindex (y>?) Is this a known issue? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users