-------- 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). -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
