On Fri, Mar 6, 2015 at 1:21 PM, Hick Gunter <hick at scigames.at> wrote:
> And then there remain to be considered the effects of the pragma > CASE_SENSITIVE_LIKE > Good point. But that's no different from the case when an application overrides the LIKE behavior via a custom function, and the vtable can similarly decide to ignore it or not; Or can even decide changing like the semantic of LIKE, again just like an application overrides. Which is way I think the point you raise is tangential to SQLite not giving vtables the opportunity to optimize LIKE. --DD
