How about the database itself?
https://dl.dropboxusercontent.com/u/4781945/like_case_example.tgz
The more I have thought about this, it seems 3.8.1 is doing the right thing.
The query with “collate nocase” has implications for unicode that I wasn’t
considering. I do wonder if the explain plan difference was intentional.
Thanks for taking a look at this,
—Chris
On Jan 15, 2014, at 11:14 PM, Richard Hipp <[email protected]> wrote:
> On Wed, Jan 15, 2014 at 6:13 PM, Chris Swinefurth <[email protected]>wrote:
>
>> The query:
>> SELECT terms.term, terms.id, terms.type, terms.product_id FROM terms
>> JOIN products ON terms.product_id = products.id JOIN
>> sub_categories ON products.category_id = sub_categories.id WHERE
>> terms.term LIKE 's%' collate nocase AND sub_categories.parent_id = 89133;
>>
>
> Thank you for the query. Can you also send the schema so that we can run
> it?
>
> --
> D. Richard Hipp
> [email protected]
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
