Re: [sqlite] PRAGMA bug in 3.7.7 (but fine in 3.7.6.3)

On Sun, Jun 26, 2011 at 6:52 PM, Richard Hipp <drh_at_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
drh_at_sqlite.org