On Sun, Jun 26, 2011 at 6:52 PM, Richard Hipp <d...@sqlite.org> wrote:
> The big mystery is why this problem is not showing up in our rather > extensive test suite. I'm still investigating that aspect of the issue. > > The reason our tests didn't pick up on this is that the error only occurs if you use the older sqlite3_prepare() interface instead of the newer sqlite3_prepare_v2(). (The sqlite3_exec() interface is a wrapper around sqlite3_prepare().) All of our test cases for "PRAGMA case_sensitive_like" used sqlite3_prepare_v2() and hence worked without any error. Bummer. -- D. Richard Hipp d...@sqlite.org