(age) branch master updated: Order some regression tests for stability on big-endian (#1892)

[jgemignani]

This is an automated email from the ASF dual-hosted git repository.

jgemignani pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/age.git


The following commit(s) were added to refs/heads/master by this push:
     new 3b8aaa6c Order some regression tests for stability on big-endian 
(#1892)
3b8aaa6c is described below

commit 3b8aaa6ce7139f3503ebaff3c990b0d2f27259dc
Author: Christoph Berg <c...@df7cb.de>
AuthorDate: Thu May 23 18:10:45 2024 +0200

    Order some regression tests for stability on big-endian (#1892)
    
    On Debian's s390x architecture, some regression tests were failing
    because the result set was reordered. Fix by attaching ORDER BY in
    problematic cases.
---
 regress/expected/cypher_match.out | 6 +++---
 regress/sql/cypher_match.sql      | 4 ++--
 2 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/regress/expected/cypher_match.out 
b/regress/expected/cypher_match.out
index 461e9243..e2558478 100644
--- a/regress/expected/cypher_match.out
+++ b/regress/expected/cypher_match.out
@@ -1520,13 +1520,13 @@ NOTICE:  graph "for_isEmpty" has been dropped
 SELECT * FROM cypher('cypher_match', $$
        MATCH (u)
        RETURN DISTINCT u.id
-$$) AS (i agtype);
+$$) AS (i agtype) ORDER BY i;
      i     
 -----------
- 
  "end"
  "initial"
  "middle"
+ 
 (4 rows)
 
 SELECT * FROM cypher('cypher_match', $$
@@ -1556,7 +1556,7 @@ $$) AS (i agtype);
 SELECT * FROM cypher('cypher_match', $$
        MATCH p=(:duplicate)-[]-(:other_v)
        RETURN DISTINCT p
-$$) AS (i agtype);
+$$) AS (i agtype) ORDER BY i;
                                                                                
                                                                 i              
                                                                                
                                                   
 
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  [{"id": 3377699720527873, "label": "duplicate", "properties": {}}::vertex, 
{"id": 3659174697238529, "label": "dup_edge", "end_id": 3940649673949185, 
"start_id": 3377699720527873, "properties": {"id": 1}}::edge, {"id": 
3940649673949185, "label": "other_v", "properties": {}}::vertex]::path
diff --git a/regress/sql/cypher_match.sql b/regress/sql/cypher_match.sql
index d1531be3..2817f36f 100644
--- a/regress/sql/cypher_match.sql
+++ b/regress/sql/cypher_match.sql
@@ -725,7 +725,7 @@ SELECT drop_graph('for_isEmpty', true);
 SELECT * FROM cypher('cypher_match', $$
        MATCH (u)
        RETURN DISTINCT u.id
-$$) AS (i agtype);
+$$) AS (i agtype) ORDER BY i;
 
 SELECT * FROM cypher('cypher_match', $$
        CREATE (u:duplicate)-[:dup_edge {id:1 }]->(:other_v)
@@ -744,7 +744,7 @@ $$) AS (i agtype);
 SELECT * FROM cypher('cypher_match', $$
        MATCH p=(:duplicate)-[]-(:other_v)
        RETURN DISTINCT p
-$$) AS (i agtype);
+$$) AS (i agtype) ORDER BY i;
 
 --
 -- Limit