[sqlite] How does xBestIndex know that a LIKE query is case insensitive?

2010-09-23 Thread Ben Harper
I have a virtual table implementation that implements the xBestIndex/xFilter functions. Problem: A LIKE query (for eg. field LIKE prefix%) gets sets to xBestIndex as a GT/LT pair. However, I can't tell from the sqlite3_index_info whether that GT/LT should be NOCASE collation or BINARY

Re: [sqlite] How does xBestIndex know that a LIKE query is case insensitive?

2010-09-23 Thread Richard Hipp
On Thu, Sep 23, 2010 at 7:16 AM, Ben Harper b...@imqs.co.za wrote: I have a virtual table implementation that implements the xBestIndex/xFilter functions. Problem: A LIKE query (for eg. field LIKE prefix%) gets sets to xBestIndex as a GT/LT pair. However, I can't tell from the

Re: [sqlite] How does xBestIndex know that a LIKE query is case insensitive?

2010-09-23 Thread Ben Harper
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: 23 September 2010 01:57 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] How does xBestIndex know that a LIKE query is case insensitive? On Thu, Sep 23, 2010 at 7:16 AM, Ben Harper b...@imqs.co.za