[postgis-tickets] [PostGIS] #4269: Inconsistent result for ST_Intersects depending on the plan
PostGIS
trac at osgeo.org
Wed Dec 5 10:17:40 PST 2018
#4269: Inconsistent result for ST_Intersects depending on the plan
-------------------------+---------------------------
Reporter: Algunenano | Owner: pramsey
Type: defect | Status: new
Priority: critical | Milestone: PostGIS 2.4.7
Component: postgis | Version: 2.5.x
Resolution: | Keywords:
-------------------------+---------------------------
Comment (by pramsey):
Yes, order dependent issues are almost always rooted in the cache code
line returning different results from the uncached code line. See if using
_ST_Intersects() instead (uncached) results in predictable results
(probable does). Confirm by using just the && operator as another test
case (probably predictable, but worth trying... if there's an issue in the
backend it's more likely to manifest with just the pure operator test).
Finally, is one or more of the inputs invalid, as komzpa is alluding?
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4269#comment:3>
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-tickets
mailing list