I get a segfault using a particular rtree query. Here's the simplest way I could find to reproduce it.
$ uname -a Linux odysseus 2.6.18-6-xen-vserver-amd64 #1 SMP Fri Jun 6 07:07:31 UTC 2008 x86_64 GNU/Linux $ sqlite3 -version 3.6.7 $ cat >bug.sql create table foo (id integer primary key); create virtual table bar using rtree (id, minX, maxX, minY, maxY); insert into foo values (null); insert into foo select null from foo; insert into foo select null from foo; insert into foo select null from foo; insert into foo select null from foo; insert into foo select null from foo; insert into foo select null from foo; delete from foo where id > 40; -- change to 39,38,37,... and it won't segfault insert into bar select null,0,0,0,0 from foo; select count(*) from bar b1, bar b2, foo s1 where b1.minX <= b2.maxX and s1.id = b1.id; $ sqlite3 <bug.sql Segmentation fault I compiled sqlite with rtree from sqlite-amalgamation-3.6.7.tar.gz using gcc 4.1.2 20061115 (prerelease) (Debian 4.1.1-21). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users