[PostGIS] #5928: ST_Collect creates invalid result with only valid input

PostGIS trac at osgeo.org
Mon Jun 23 22:29:09 PDT 2025


#5928: ST_Collect creates invalid result with only valid input
-------------------------------+---------------------------
 Reporter:  Lars Aksel Opsahl  |      Owner:  pramsey
     Type:  defect             |     Status:  new
 Priority:  medium             |  Milestone:  PostGIS 3.6.0
Component:  postgis            |    Version:  3.5.x
 Keywords:                     |
-------------------------------+---------------------------
 With attached file run this

 {{{
 SELECT ST_IsValid(ST_Collect(org_geo)) from input_geoms where
 ST_IsValid(org_geo);
 NOTICE:  00000: Self-intersection at or near point 5.7186569590547141
 58.939366651665459
 LOCATION:  pg_notice, lwgeom_pg.c:389
  st_isvalid
 ------------
  f
 (1 row)
 }}}

 This was tested on


 {{{
 POSTGIS="3.5.0dev 3.4.0rc1-1310-g8349e1670" [EXTENSION] PGSQL="160"
 GEOS="3.13.0-CAPI-1.19.0" PROJ="9.5.1 NETWORK_ENABLED=OFF
 URL_ENDPOINT=https://cdn.proj.org
 USER_WRITABLE_DIRECTORY=/Users/lop/Library/Application Support/proj
 DATABASE_PATH=/opt/homebrew/Cellar/proj/9.5.1/share/proj/proj.db"
 (compiled against PROJ 9.13.0) LIBXML="2.13.0" LIBJSON="0.18" (core procs
 from "3.6.0dev 3.5.0-191-g09b3419dc" need upgrade) TOPOLOGY (topology
 procs from "3.6.0dev 3.5.0-191-g09b3419dc" need upgrade)

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