Re: [sqlite] bug in the RTree module

2008-09-10 Thread Dan
>> I think I have found a bug in the RTree extension (v3.6.2) It got fixed a day or two ago here: http://www.sqlite.org/cvstrac/chngview?cn=5682 Grab the new rtree.c file from here if you want the fix before 3.6.3 comes out: http://www.sqlite.org/cvstrac/getfile?f=sqlite/ext/rtree/ rtree

Re: [sqlite] bug in the RTree module

2008-09-10 Thread Xavier Naval
Hi, I think there has to be something wrong with the first insert that you do in a RTree table. If before copying the records to the virtual table you do a dummy insert then everything works OK. sqlite> CREATE VIRTUAL TABLE test_rtree USING RTREE(pkid, xmin, xmax, ymin, ymax); sqlite> INSERT INTO

[sqlite] bug in the RTree module

2008-09-07 Thread Alessandro Furieri
Hi, I think I have found a bug in the RTree extension (v3.6.2) a copy of the test database is available for download at: http://www.gaia-gis.it/rtreebug.zip [1.5 MB] - SQLite version 3.6.2 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables test sqli