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
