Let's say I have an expression index: CREATE INDEX FOOINDEX on FOO(func(col))
And then I use that index: SELECT bar FROM FOO INDEXED BY FOOINDEX WHERE func(col) = 42; I can see that it will use the stored value, since if I put a breakpoint on func, it won't hit. Good and well. 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. Is there a way to avoid this? I would just like to return the value that's already stored in the index. - Deon _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
