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

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

2010-09-23 Thread Ben Harper

users-boun...@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.

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 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

[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