[postgis-tickets] [PostGIS] #5375: topology tests failing on debbie PG16

[PostGIS]

#5375: topology tests failing on debbie PG16
-----------------------+--------------------------------
  Reporter:  robe      |      Owner:  robe
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 3.4.0
 Component:  topology  |    Version:  3.3.x
Resolution:            |   Keywords:  PostgreSQL 16 pg16
-----------------------+--------------------------------
Comment (by robe):

 I think this may be the same issue as what I am seeing in tickets.

 I think the PG16 answer is wrong.

 Example:


 {{{
 SELECT f.wkt
 FROM (VALUES (
      'LINESTRING(124.983539 1.419224,91.181596 29.647798)'::text ),
  ('LINESTRING(124.983539 1.419224,91.181596 29.647798, 91.28
 29.647)'::text  ) ) As f(wkt)
 ORDER BY f.wkt;
 }}}

 In PG16, the sort is changed a bit.  I suppose this is more right, it's
 ranking space as alphabetically before parenthesis  )

 {{{
                                 wkt
 -------------------------------------------------------------------
  LINESTRING(124.983539 1.419224,91.181596 29.647798, 91.28 29.647)
  LINESTRING(124.983539 1.419224,91.181596 29.647798)
 (2 rows)

 }}}

 For PG15 and below, this sorted as:


 {{{
                                wkt
 -------------------------------------------------------------------
  LINESTRING(124.983539 1.419224,91.181596 29.647798)
  LINESTRING(124.983539 1.419224,91.181596 29.647798, 91.28 29.647)
 (2 rows)
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5375#comment:2>
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.