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

[PostGIS]

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

 In the script we check the input data are valid before ST_Difference is
 dobe


 {{{
 CREATE TABLE difference_test_01 AS
 SELECT (ST_Dump((ST_Difference(pt.geo,u.geo)))).geom AS geom FROM
 ( SELECT ST_Collect(distinct pt.geo) AS geo FROM all_area pt WHERE
 ST_IsValid(pt.geo)) AS pt,
 ( SELECT ST_Union(geo) AS geo FROM used_area u WHERE ST_IsValid(geo) ) AS
 u;

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5401#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.