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

Reply via email to