To answer my own question: The magic is in either
SQLITE_CASE_SENSITIVE_LIKE compile time option or CASE_SENSITIVE_LIKE pragma. I have seen this before, but it just didn't stick in my small memory bank. Mark > -----Original Message----- > From: Evans, Mark (Tandem) > Sent: Monday, November 05, 2007 4:34 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Virtual Table LIKE operator constaint? > > 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 > > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------