I'm using System.Data.SQLite version 1.0.95.0 and have what appears to be a bug with Virtual Tables. Queries using 'like' in the where clause are not getting the like clause passed to BestIndex as a query constraint. Specifically:
- Simple query: select * from foo where name like 'a%' - Break inside module BestIndex - SQLiteIndex.Inputs.Constraints has 0 length (no constraints) The above causes a full table scan of the virtual table for queries using 'like', which is very bad for any virtual table of a substantial size. Virtual tables need to be able to use 'like' clauses to restrict result set size. Before I bug this issue, is anyone aware of it and have any workaround? Currently, the only workaround I've got, is telling users don't use 'like' in their queries (obviously not a good thing). Thanks, MikeN
