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

Reply via email to