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

PRAGMA bug in 3.7.7 (but fine in 3.7.6.3)

From: Greg Stein <gstein_at_gmail.com>
Date: Sun, 26 Jun 2011 15:59:33 -0400

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;
}
]]]
Received on 2011-06-26 22:00:07 CEST

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