On Wed, Aug 3, 2011 at 10:07 AM, Dan Kennedy <danielk1...@gmail.com> wrote:
> > > -------- Original Message -------- > Subject: Re: assert() in debug build when running query > Date: Wed, 03 Aug 2011 15:00:46 +0200 > From: Jens Miltner <j...@mac.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > > Sorry, should have mentioned that this happens with version 3.6.7.3 and > up (at least 3.6.7.3 is the version we discovered it in and I just tried > with 3.7.7.1 and it still happens there). > Since it isn't obvious, I'll point out that the bug report for this issue is http://www.sqlite.org/src/info/d635236375 and the fix is http://www.sqlite.org/src/ci/a2135ad130 > > -jens > > > Am 03.08.2011 um 12:02 schrieb Jens Miltner: > > > Hi, > > > > I suddenly get an assert() in the debug build of sqlite when running a > certain query. The same query was executed many times before and did not > assert, so I suspect it must have to do with certain data combinations. > > However, I was able to reduce to a very simple data set & fairly simple > query, so it looks like it's something that might happen more often... > > > > I have put the SQL statements to create the schema, add sample data and > execute the query in a file at < > http://dl.dropbox.com/u/1283675/sqliteassert.sql>. > > > > When executing this with the debug build of the commandline too, I get > the following assertion: > > > >> Gandalf:~ jens$ ./build/Debug/sqlite3 < sqliteassert.sql > >> sqlite3.c:64661: failed assertion `memIsValid(&aMem[u.aj.p1+u.aj.idx])' > >> Abort trap > > > > I have no idea what this assertion is flagging and whether this is > something critical, but since it's asserting we have to take this serious... > > (FWIW, this is on Mac OS X 10.6.7) > > > > Can one of the sqlite team please have a look at this and check whether > it's something critical? > > > > > > Thanks, > > -jens > > > > > > > > > > Jens Miltner > > -- > Thou shalt not follow the NULL pointer, for chaos and madness await thee > at its end. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
