(age) branch master updated: Fix unsorted output of some queries in the cypher_match test (#1507)

[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 c3f8caff Fix unsorted output of some queries in the cypher_match test 
(#1507)
c3f8caff is described below

commit c3f8caffd017e17055eda7cce1676ed1e94e8439
Author: Egor Chindyaskin <e.chindyas...@postgrespro.ru>
AuthorDate: Tue Feb 6 02:35:55 2024 +0700

    Fix unsorted output of some queries in the cypher_match test (#1507)
    
    Fix unsorted output of some queries in the cypher_match test
---
 regress/expected/cypher_match.out | 12 ++++++------
 regress/sql/cypher_match.sql      |  4 ++--
 2 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/regress/expected/cypher_match.out 
b/regress/expected/cypher_match.out
index cef6dad9..f00c47c2 100644
--- a/regress/expected/cypher_match.out
+++ b/regress/expected/cypher_match.out
@@ -1998,13 +1998,13 @@ SELECT * FROM cypher('cypher_match', $$
 (0 rows)
 
 SELECT * FROM cypher('cypher_match', $$
-       MATCH (a)-[r]-(b) RETURN r $$) as (r agtype);
+       MATCH (a)-[r]-(b) RETURN r ORDER BY r DESC $$) as (r agtype);
                                                                                
 r                                                                              
  
 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
- {"id": 4785074604081153, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710661, "properties": {"years": 3, "relationship": 
"friends"}}::edge
- {"id": 4785074604081153, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710661, "properties": {"years": 3, "relationship": 
"friends"}}::edge
  {"id": 4785074604081154, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710659, "properties": {"years": 4, "relationship": 
"enemies"}}::edge
  {"id": 4785074604081154, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710659, "properties": {"years": 4, "relationship": 
"enemies"}}::edge
+ {"id": 4785074604081153, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710661, "properties": {"years": 3, "relationship": 
"friends"}}::edge
+ {"id": 4785074604081153, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710661, "properties": {"years": 3, "relationship": 
"friends"}}::edge
  {"id": 1407374883553283, "label": "e1", "end_id": 281474976710661, 
"start_id": 281474976710660, "properties": {}}::edge
  {"id": 1407374883553283, "label": "e1", "end_id": 281474976710661, 
"start_id": 281474976710660, "properties": {}}::edge
 (6 rows)
@@ -2091,13 +2091,13 @@ SELECT * FROM cypher('cypher_match', $$
 
 -- check reuse of 'r' clause-to-clause - edges
 SELECT * FROM cypher('cypher_match', $$
-       MATCH ()-[r]-() RETURN r $$) as (r agtype);
+       MATCH ()-[r]-() RETURN r ORDER BY r DESC $$) as (r agtype);
                                                                                
 r                                                                              
  
 
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
- {"id": 4785074604081153, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710661, "properties": {"years": 3, "relationship": 
"friends"}}::edge
- {"id": 4785074604081153, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710661, "properties": {"years": 3, "relationship": 
"friends"}}::edge
  {"id": 4785074604081154, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710659, "properties": {"years": 4, "relationship": 
"enemies"}}::edge
  {"id": 4785074604081154, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710659, "properties": {"years": 4, "relationship": 
"enemies"}}::edge
+ {"id": 4785074604081153, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710661, "properties": {"years": 3, "relationship": 
"friends"}}::edge
+ {"id": 4785074604081153, "label": "knows", "end_id": 281474976710666, 
"start_id": 281474976710661, "properties": {"years": 3, "relationship": 
"friends"}}::edge
  {"id": 1407374883553283, "label": "e1", "end_id": 281474976710661, 
"start_id": 281474976710660, "properties": {}}::edge
  {"id": 1407374883553283, "label": "e1", "end_id": 281474976710661, 
"start_id": 281474976710660, "properties": {}}::edge
 (6 rows)
diff --git a/regress/sql/cypher_match.sql b/regress/sql/cypher_match.sql
index b211439e..318764cd 100644
--- a/regress/sql/cypher_match.sql
+++ b/regress/sql/cypher_match.sql
@@ -965,7 +965,7 @@ SELECT * FROM cypher('cypher_match', $$
        MATCH (a),(b) WHERE a.age = 4 AND a.name = "orphan" AND b.age = 6 CREATE
        (a)-[:knows {relationship: "enemies", years: 4}]->(b) $$) as (r agtype);
 SELECT * FROM cypher('cypher_match', $$
-       MATCH (a)-[r]-(b) RETURN r $$) as (r agtype);
+       MATCH (a)-[r]-(b) RETURN r ORDER BY r DESC $$) as (r agtype);
 
 -- check reuse of 'a' clause-to-clause - vertices
 SELECT * FROM cypher('cypher_match', $$
@@ -996,7 +996,7 @@ SELECT * FROM cypher('cypher_match', $$
 
 -- check reuse of 'r' clause-to-clause - edges
 SELECT * FROM cypher('cypher_match', $$
-       MATCH ()-[r]-() RETURN r $$) as (r agtype);
+       MATCH ()-[r]-() RETURN r ORDER BY r DESC $$) as (r agtype);
 SELECT * FROM cypher('cypher_match', $$
        MATCH ()-[r]-() MATCH ()-[r {relationship: "friends"}]-() RETURN r $$) 
as (r agtype);
 SELECT * FROM cypher('cypher_match', $$