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

[Greg Stein]

Hey all,

There is a bug in 3.7.7 that affects Apache Subversion. We've verified
that it is this latest release, as prior releases have worked just
fine for us.

Below is the reproduction script, thanks to Daniel Shahaf. With this
pragma not working, we cannot even start up :-(

Please help!

Thanks,
-g

ps. maybe this belongs on -dev, but I'm pending on its moderated subscription...

[[[
#include <assert.h>
#include <stdio.h>

#include "sqlite3.h"


#define BUSY_TIMEOUT 10000

int main(void)
{
 sqlite3 *db3;

 const char *path = "foo.db";
 int flags = SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE;
#ifdef SQLITE_OPEN_NOMUTEX
 flags |= SQLITE_OPEN_NOMUTEX;
#endif

 assert(SQLITE_OK == sqlite3_open_v2(path, &db3, flags, NULL));
 assert(SQLITE_OK == sqlite3_busy_timeout(db3, BUSY_TIMEOUT));
 assert(SQLITE_OK == sqlite3_busy_timeout(db3, BUSY_TIMEOUT));
 {
   char *errmsg;
   int err = sqlite3_exec(db3, "PRAGMA case_sensitive_like=1;", NULL,
NULL, &errmsg);
   if (err != SQLITE_OK)
     printf("Error %d: %s\n", err, errmsg), sqlite3_free(errmsg);
 }
 return 0;
}
]]]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users