[postgis-tickets] [PostGIS] #3843: st_RemoveRepeatedPoints misses duplicate in polygon

[PostGIS]

#3843: st_RemoveRepeatedPoints misses duplicate in polygon
-----------------------+-------------------------------------
  Reporter:  crispond  |      Owner:  pramsey
      Type:  defect    |     Status:  reopened
  Priority:  medium    |  Milestone:  PostGIS 2.4.0
 Component:  postgis   |    Version:  2.4.x
Resolution:            |   Keywords:  st_RemoveRepeatedPoints
-----------------------+-------------------------------------
Changes (by zimirrr):

 * status:  closed => reopened
 * version:  2.2.x => 2.4.x
 * resolution:  fixed =>


Comment:

 We've found same problem with ST_RemoveRepeatedPoints.
 This sql fails to drop duplicated node '''90.352327 23.79429''':
 {{{#!sql
 SELECT ST_AsText(ST_RemoveRepeatedPoints('POLYGON((90.352399
 23.794183,90.352332 23.79418,90.352327 23.79429,90.352327
 23.79429,90.352399 23.794183))'))
 }}}

 But on linestring it works:
 {{{#!sql
 SELECT ST_AsText(ST_RemoveRepeatedPoints('LINESTRING(90.352399
 23.794183,90.352332 23.79418,90.352327 23.79429,90.352327
 23.79429,90.352399 23.794183)'))
 }}}

 Was tested it on:
 1. "POSTGIS="2.4.1 r16012" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d"
 PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.2, released 2017/09/15"
 LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" RASTER"

 2. "POSTGIS="2.3.3 r15473" GEOS="3.6.1-CAPI-1.10.1 r4317" PROJ="Rel.
 4.9.1, 04 March 2015" GDAL="GDAL 2.2.1, released 2017/06/23"
 LIBXML="2.7.8" LIBJSON="0.12" RASTER"

 3. "POSTGIS="2.3.2 r15302" GEOS="3.6.1-CAPI-1.10.1 r0" PROJ="Rel. 4.9.3,
 15 August 2016" GDAL="GDAL 2.2.0, released 2017/04/28" LIBXML="2.9.4"
 LIBJSON="0.12.1" RASTER"

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