Hi Minar, hi Dan, there is a similar bug in the FTS3 module. But here the sqlite_last_rowid may return a wrong value.
Regards, Hartwig Am 19.03.2010 um 20:13 schrieb Dan Kennedy: > > On Mar 19, 2010, at 11:04 PM, Minář Petr wrote: > >> Hi, >> I was experimenting a bit with R*Tree extension in my project and I >> encountered weird behavior. Consider following code: >> >> CREATE VIRTUAL TABLE table USING rtree >> ( >> Id INTEGER NOT NULL PRIMARY KEY, >> MinX REAL, >> MaxX REAL, >> MinY REAL, >> MaxY REAL >> ); >> >> INSERT INTO table (MinX,MaxX,MinY,MaxY) VALUES (1,1,1,1) >> >> All the sql code executes correctly but >> sqlite3_last_insert_rowid(db) returns 0xcccccccccccccccc value >> (uninitialized variable under debug builds in VC2005 I use). While >> stepping into sqlite source code I found that rtreeUpdate method >> doesn't even touch outgoing parameter pRowid (unlike fe. >> fts3UpdateMethod in FTS3 module) that should return "new last row >> id" (at least I think). >> >> I'm using latest 3.6.23 version (amalgamation). >> >> Is it bug? Or am I missing something? Workaround? > > It's a bug. Now fixed here: > > http://www.sqlite.org/src/ci/f31d22489d > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
