[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