[postgis-tickets] r16625 - Make test sort order deterministic by using lateral.

[Regina Obe]

Author: robe
Date: 2018-06-30 14:59:42 -0700 (Sat, 30 Jun 2018)
New Revision: 16625

Modified:
   trunk/topology/test/regress/topogeo_addlinestring.sql
   trunk/topology/test/regress/topogeo_addlinestring_expected
Log:
Make test sort order deterministic by using lateral.
Closes #4111
(Note they are going to fix the issue upstream that made this fail on stable 10, but I wanted to change this test anyway)

Modified: trunk/topology/test/regress/topogeo_addlinestring.sql
===================================================================
--- trunk/topology/test/regress/topogeo_addlinestring.sql	2018-06-26 14:55:00 UTC (rev 16624)
+++ trunk/topology/test/regress/topogeo_addlinestring.sql	2018-06-30 21:59:42 UTC (rev 16625)
@@ -272,9 +272,10 @@
 SELECT 't3280', 'L2' || topology.TopoGeo_AddLinestring('bug3280',
  '010200000003000000EC51B89E320F3841333333B3A9C852415649EE1F280F384164E065F493C85241A4703D8A230F38410AD7A37094C85241'
  ::geometry);
-SELECT 't3280', 'L1b' || topology.TopoGeo_AddLinestring('bug3280', geom)
- FROM bug3280.edge where edge_id = 1
- ORDER BY 1;
+SELECT 't3280', 'L1b' || l
+ FROM (SELECT * FROM bug3280.edge where edge_id = 1) AS e
+    CROSS JOIN LATERAL topology.TopoGeo_AddLinestring('bug3280', geom) AS l
+ ORDER BY 2;
 SELECT 't3280.end', topology.DropTopology('bug3280');
 
 -- See http://trac.osgeo.org/postgis/ticket/3380

Modified: trunk/topology/test/regress/topogeo_addlinestring_expected
===================================================================
--- trunk/topology/test/regress/topogeo_addlinestring_expected	2018-06-26 14:55:00 UTC (rev 16624)
+++ trunk/topology/test/regress/topogeo_addlinestring_expected	2018-06-30 21:59:42 UTC (rev 16625)
@@ -185,8 +185,8 @@
 t3280.start|t
 t3280|L11
 t3280|L22
+t3280|L1b2
 t3280|L1b4
-t3280|L1b2
 t3280.end|Topology 'bug3280' dropped
 t3380.start|t
 t3380.L1|1