On 6/24/2014 6:04 PM, Peter Haworth wrote:
SELECT * FROM itemTable WHERE +key = 'profileName' ;
Note the + sign - this suppresses the use of index.
That's really interesting - I've never seen that use of the "+" sign
mentioned in the docs.
http://www.sqlite.org/optoverview.html
To be usable by an index a term must be of one of the following forms: ...
Adding a unary + changes the term so it's no longer one of those forms.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
