Ticket #884 (closed defect: fixed)
Unstable results with ST_Within, ST_Intersects
|Reported by:||strk||Owned by:||chodgson|
Description (last modified by robe) (diff)
This is pretty puzzling. Load attached dataset, then: (I suspect it affects all functions that used prepared geometry - does same with ST_Intersects)
-- This query says none of the 3 polygons contain the point =# select gid, ST_Within( ST_GeomFromText('POINT (-115.04252 36.05137)', -1), the_geom ) from foo_reload; -- This query says polygon 3 does contain the point =# select gid, ST_Within( ST_GeomFromText('POINT (-115.04252 36.05137)', -1), the_geom ) from foo_reload where gid = 3;
Storing the point geometry into a table makes no difference. Geometry number 3 really contains the point. The other two don't.
I've tested this with PostgreSQL 8.4.3, PostGIS 2.0.0SVN and GEOS 3.3.0dev