[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