postgres.git / summary / log / commit / refs

commit    f6edd8ed708fe9e37742886916406ce52f2d3a84
Author:   Peter Eisentraut <peter@eisentraut.org>
Date:     Mon May 04 18:59:16 2026 +0000

    Add ORDER BY to test query to stabilize test
    
    for commit dc9e7c9ed93


 src/test/regress/expected/graph_table.out | 7 ++++---
 src/test/regress/sql/graph_table.sql      | 3 ++-
 2 files changed, 6 insertions(+), 4 deletions(-)

diff --git a/src/test/regress/expected/graph_table.out b/src/test/regress/expected/graph_table.out
index a309167ff0a..ea9c0f6112e 100644
--- a/src/test/regress/expected/graph_table.out
+++ b/src/test/regress/expected/graph_table.out
@@ -1035,12 +1035,13 @@ ERROR:  subqueries within GRAPH_TABLE reference are not supported
 -- GRAPH_TABLE subquery in HAVING clause (tests expression mutator)
 SELECT src.vname, count(*) FROM v1 AS src
   GROUP BY src.vname
-  HAVING count(*) >= (SELECT count(*) FROM GRAPH_TABLE (g1 MATCH (a IS vl1 | vl2) COLUMNS (a.vname AS n)) WHERE n = src.vname);
+  HAVING count(*) >= (SELECT count(*) FROM GRAPH_TABLE (g1 MATCH (a IS vl1 | vl2) COLUMNS (a.vname AS n)) WHERE n = src.vname)
+  ORDER BY vname;
  vname | count 
 -------+-------
- v13   |     1
- v12   |     1
  v11   |     1
+ v12   |     1
+ v13   |     1
 (3 rows)
 
 -- leave the objects behind for pg_upgrade/pg_dump tests
diff --git a/src/test/regress/sql/graph_table.sql b/src/test/regress/sql/graph_table.sql
index d6b6effb6b9..dd35aa794e5 100644
--- a/src/test/regress/sql/graph_table.sql
+++ b/src/test/regress/sql/graph_table.sql
@@ -593,6 +593,7 @@ SELECT sname, dname FROM GRAPH_TABLE (g1 MATCH (src)->(dest) WHERE out_degree(sr
 -- GRAPH_TABLE subquery in HAVING clause (tests expression mutator)
 SELECT src.vname, count(*) FROM v1 AS src
   GROUP BY src.vname
-  HAVING count(*) >= (SELECT count(*) FROM GRAPH_TABLE (g1 MATCH (a IS vl1 | vl2) COLUMNS (a.vname AS n)) WHERE n = src.vname);
+  HAVING count(*) >= (SELECT count(*) FROM GRAPH_TABLE (g1 MATCH (a IS vl1 | vl2) COLUMNS (a.vname AS n)) WHERE n = src.vname)
+  ORDER BY vname;
 
 -- leave the objects behind for pg_upgrade/pg_dump tests


[parent: b5f92b8eb439]