[postgis-devel] [PostGIS] #1958: ST_Intersects(geography) returns incorrect result when called multiple times
PostGIS
trac at osgeo.org
Mon Aug 20 09:17:50 PDT 2012
#1958: ST_Intersects(geography) returns incorrect result when called multiple
times
---------------------------+------------------------------------------------
Reporter: realityexists | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.1.0
Component: postgis | Version: 2.0.x
Keywords: |
---------------------------+------------------------------------------------
Comment(by pramsey):
Example that dodges having force the cache:
{{{
WITH objs AS
(
SELECT
'LINESTRING(22.88333 41.96667,21.32667 42.13667)'::geography AS line,
'POLYGON((22.94472 41.34667,22.87528 41.99028,22.87389 41.98472,22.87472
41.98333,22.94472 41.34667))'::geography AS border
)
SELECT ST_Distance(line, border), _ST_DistanceTree(line, border)
FROM objs;
}}}
Basically we have a big disagreement about distance, presumably because
the containment test is failing on the tree side.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1958#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list