I've reduced a problem that I'm having to the following test case.
I insert two rows into an rtree table. In the first case when I
select chromStart and chromEnd I get the same values as I inserted.
In the second case the chromEnd is 1 greater than what I inserted. In
the third case chromStart is 1 les than what I inserted.
I'm using a copy of sqlite-3.6.18 that I compiled myself, using
defaults except for rtree support, on a Suse SLES 10 system.
It seems odd. Are the values large enought that they're causing
problems with the 32-bit floats? It almost seems like odd numbers are
rounded up/down depending on whether they're min or max?
Any help would be greatly appreciated.
Thanks,
g.
-- --------------- snip ----------------
create virtual table snp130_rtree
using rtree
(snp130_rowid,
chromMin, chromMax,
strandMin, strandMax,
chromStart, chromEnd);
insert into snp130_rtree
(snp130_rowid,
chromMin, chromMax,
strandMin, strandMax,
chromStart, chromEnd)
values
(1, 1, 1, 1, 1, 1, 2);
insert into snp130_rtree
(snp130_rowid,
chromMin, chromMax,
strandMin, strandMax,
chromStart, chromEnd)
values
(2, 1, 1, 1, 1, 19201046, 19201047);
insert into snp130_rtree
(snp130_rowid,
chromMin, chromMax,
strandMin, strandMax,
chromStart, chromEnd)
values
(3, 1, 1, 1, 1, 19201045, 19201046);
select * from snp130_rtree;
-- --------------- snip ----------------
>>~/src/sqlite-3.6.18/sqlite3 ./bug.db < bug.sql
1|1.0|1.0|1.0|1.0|1.0|2.0
2|1.0|1.0|1.0|1.0|19201046.0|19201048.0
3|1.0|1.0|1.0|1.0|19201044.0|19201046.0
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
