Hi, I tried to convert our custom tables and triggers into partial indexes. Unfortunately it seems that the query planner is unable to recognize identical terms. Could this be fixed or is there any workaround?
Thanks, Filip Navara SQLite version 3.8.1 2013-10-17 12:57:35 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE "a" ("id" INTEGER PRIMARY KEY, "flags" INTEGER); sqlite> CREATE INDEX "b" ON "a" ("flags") WHERE "flags" & 16; sqlite> EXPLAIN QUERY PLAN SELECT * FROM "a" WHERE "flags" & 16; 0|0|0|SCAN TABLE a sqlite> EXPLAIN QUERY PLAN SELECT * FROM "a" INDEXED BY "b" WHERE "flags" & 16; Error: no query solution _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users