Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#4925 closed defect (fixed)

ST_DumpPoints overlooks points

Reported by: kalenik Owned by: pramsey
Priority: medium Milestone: PostGIS 3.2.0
Component: postgis Version: master
Keywords: Cc:

Description

=> SELECT path, ST_AsText(geom)
FROM (
         SELECT (ST_DumpPoints(g.geom)).*
         FROM (SELECT 'GEOMETRYCOLLECTION(
          POINT(11 11),
          GEOMETRYCOLLECTION EMPTY,
          POINT(22 22),
          GEOMETRYCOLLECTION EMPTY,
          POINT(33 33),
          POINT(44 44)
        )'::geometry AS geom
              ) AS g
     ) j;
 path  │  st_astext
───────┼──────────────
 {1,1} │ POINT(11 11)
 {6,1} │ POINT(44 44)
(2 rows)

Doesn't seem like correct behaviour since points before GeometryCollection are not included in resulting set.

https://github.com/postgis/postgis/pull/616 -- patch

Change History (2)

comment:1 by kalenikaliaksandr <kalenik.aliaksandr@…>, 3 years ago

Resolution: fixed
Status: newclosed

In 6c7a131/git:

fix ST_DumpPoints to not overlook points (Closes #4925)

Closes: #4925

comment:2 by robe, 3 years ago

You think this is worthwhile backporting to at least 3.1?

Note: See TracTickets for help on using tickets.