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; } ]]]