[postgis-tickets] [PostGIS] #5401: ST_Difference silently giving us wrong results

PostGIS trac at osgeo.org
Thu Jun 15 07:31:35 PDT 2023


#5401: ST_Difference silently giving us wrong results
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  pramsey
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.3.4
 Component:  postgis            |    Version:  3.3.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by strk):

 Just to complete the picture, the debugging logs continue to the precision
 reduction heuristics which end up with the garbage result. Detailed logs
 are in https://github.com/libgeos/geos/issues/924#issuecomment-1593160531

 It turns out this problem is 2-fold:

  1. GEOMETRYCOLLECTION should not be passed to ST_Difference but GEOS
 fails to report this ---> https://github.com/libgeos/geos/issues/925
  2. GEOS attempts to still support the operation goes too far --->
 https://github.com/libgeos/geos/issues/924
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5401#comment:17>
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