Hi, Has anybody ever seen anomalous behaviour on an R*Tree. Specifically, false negatives? I'm using Spatialite 2.4.0 RC.
What I end up with is a table into which I can insert new geometry, but that geometry does not get retrieved by an appropriate RTree search. Indeed, even a search which spans all of my geometry does not yield these newly inserted records. For example: select count(rowid) from idx_elec_lv_cable_geometry where xmax >= -9e30 AND xmin <= 9e30 AND ymax >= -9e90 AND ymin <= 9e30; 17235 select (count*) from elec_lv_cable; 17241 So I'm missing 6 records there. I can't discern anything strange about the data, or my methods. I'm curious to know whether anybody has seen this kind of thing before? Thanks, Ben ps. This message is cross-posted to the Spatialite mailing list. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users