On 4/28/2017 4:37 PM, Jens Alfke wrote:
CREATE TABLE docs (doc_id INTEGER PRIMARY KEY, docid TEXT UNIQUE NOT NULL, expiry_timestamp INTEGER); CREATE INDEX docs_docid ON docs(docid);
For the record, this index is redundant. There's already an automatically created index on docs(docid), thanks to UNIQUE clause. This might be what confuses SQLite. See whether the behavior changes if you drop it.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
