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
