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

Reply via email to