[sqlite] Virtual Table LIKE operator constaint?

[Evans, Mark (Tandem)]

Hi all,

In a virtual table context,  I expected a statement such as

select * from t where x like 'abc%'

to pass a constraint for the LIKE clause to xBestIndex method of virtual
table module but it doesn't get such a constraint.  I expected
SQLITE_INDEX_CONSTRAINT_MATCH.  Do I have to do something special to
enable this constraint to be passed or does it just do a full-table scan
when it sees the LIKE, GLOB, etc. operator?

Thanks,
Mark