On 2015-03-06 03:19 PM, Richard Hipp wrote: > Yikes! Actually (1) cannot be determined for normal (non-virtual) > tables either because the value could be a BLOB even if the column > affinity is TEXT. And so the current LIKE optimization is not valid > *ever*. See ticket https://www.sqlite.org/src/tktview/05f43be8fdda9f I > don't yet know how we will fix this...
True, but who uses LIKE on a BLOB? Any such usage has to be by accident - though granted, this can happen. Maybe a simple documentation note stating that LIKE operator on BLOB values will have undefined results?
