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