On 8/31/16, Deon Brewis <[email protected]> wrote: > > CREATE INDEX FOOINDEX on FOO(func(col)) > > HOWEVER, if I run: > SELECT func(col) FROM FOO INDEXED BY FOOINDEX WHERE func(col) = 42; > > It will execute the breakpoint on func(col) for every row in the table, even > though FOOINDEX is a covered index wrt. that query.
We will take this as an enhancement request. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
