George Hartzell writes: > 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? > [...]
While browsing the rtree code in the fossil source archive I noticed a comment about an rtree_i32 virtual table type, which seems to suit my needs. I don't see any mention of it on www.sqlite.org/rtree.html. Is it a mainstream feature or an undocumented/deprecated/... thing? Thanks! g. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users