[PostGIS] #5654: Missing line segment with self-intersection and MVT

[PostGIS]

#5654: Missing line segment with self-intersection and MVT
-----------------------+------------------------------------
  Reporter:  mhkeller  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.4.3
 Component:  postgis   |    Version:  3.4.x
Resolution:            |   Keywords:  mvt, self-intersection
-----------------------+------------------------------------
Comment (by robe):

 when I do


 {{{
 select st_astext(
     st_simplify(
     'LINESTRING (2 2,3 2,4 1,3 2, 4 4)'
     ,0)
     );
 }}}


 I get back:

 ```
 LINESTRING(2 2,3 2,4 4)

 ```

 Using:

 ```
 SELECT postgis_full_version();

 POSTGIS="3.5.0dev 3.4.0rc1-972-ga832b8598" [EXTENSION] PGSQL="160"
 GEOS="3.13.0dev-CAPI-1.18.0" PROJ="9.3.1 NETWORK_ENABLED=OFF
 URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/tmp/proj
 DATABASE_PATH=/usr/share/proj/proj.db" GDAL="GDAL 3.8.1, released
 2023/11/28" LIBXML="2.9.14" LIBJSON="0.17" LIBPROTOBUF="1.4.1"
 WAGYU="0.5.0 (Internal)" (core procs from "3.5.0dev
 3.4.0rc1-1013-g1284f168d" need upgrade) RASTER (raster lib from "3.5.0dev
 3.4.0rc1-1039-g88c3893c7" need upgrade) (raster procs from "3.5.0dev
 3.4.0rc1-1013-g1284f168d" need upgrade)
 ```

 This is different from the answer stated in the stack exchange you
 reference of:


 {{{
 select st_astext(
     st_simplify(
     'LINESTRING (2 2,3 2,4 1,3 2)'
     ,0)
     );

 "LINESTRING(2 2,3 2,3 2)"
 }}}


 What exactly are you getting?  and please state the versions of postgis
 and related libs you are using.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5654#comment:5>
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.