On Wed, Oct 30, 2013 at 9:47 AM, Filip Navara <filip.nav...@gmail.com>wrote:
> 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; > Workaround: Add an "ORDER BY flags" to the query above. > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users