[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

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

From: Richard Hipp <drh_at_sqlite.org>
Date: Sun, 26 Jun 2011 20:05:39 -0400

On Sun, Jun 26, 2011 at 7:28 PM, Richard Hipp <drh_at_sqlite.org> wrote:

> 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.
The one-line fix for the original problem can be seen at the link below,


Yet to do is to fix the test procedure so that all SQL statements are run
using both sqlite3_prepare() and sqlite3_prepare_v2(), to verify that the
same thing happens in both cases (modulo documented differences in the two
interfaces, of course) so that hopefully nothing like this will occur again
with a future release.

D. Richard Hipp
Received on 2011-06-27 02:06:32 CEST

This is an archived mail posted to the Subversion Dev mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.