I had to back away from 3.7.7 too because my program hung during startup. Wonder if it's related to this? I haven't looked any deeper at it. It hung, I switched back to my older library and it worked.
C Sunday, June 26, 2011, 3:59:33 PM, you wrote: GS> Hey all, GS> There is a bug in 3.7.7 that affects Apache Subversion. We've verified GS> that it is this latest release, as prior releases have worked just GS> fine for us. GS> Below is the reproduction script, thanks to Daniel Shahaf. With this GS> pragma not working, we cannot even start up :-( GS> Please help! GS> Thanks, GS> -g GS> ps. maybe this belongs on -dev, but I'm pending on its moderated subscription... GS> [[[ GS> #include <assert.h> GS> #include <stdio.h> GS> #include "sqlite3.h" GS> #define BUSY_TIMEOUT 10000 GS> int main(void) GS> { GS> sqlite3 *db3; GS> const char *path = "foo.db"; GS> int flags = SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE; GS> #ifdef SQLITE_OPEN_NOMUTEX GS> flags |= SQLITE_OPEN_NOMUTEX; GS> #endif GS> assert(SQLITE_OK == sqlite3_open_v2(path, &db3, flags, NULL)); GS> assert(SQLITE_OK == sqlite3_busy_timeout(db3, BUSY_TIMEOUT)); GS> assert(SQLITE_OK == sqlite3_busy_timeout(db3, BUSY_TIMEOUT)); GS> { GS> char *errmsg; GS> int err = sqlite3_exec(db3, "PRAGMA case_sensitive_like=1;", NULL, GS> NULL, &errmsg); GS> if (err != SQLITE_OK) GS> printf("Error %d: %s\n", err, errmsg), sqlite3_free(errmsg); GS> } GS> return 0; GS> } GS> ]]] GS> _______________________________________________ GS> sqlite-users mailing list GS> sqlite-users@sqlite.org GS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users