Remove useless query in test xc_misc

The same kind of query was used twice, for the same results.
Moreover, this query was not always giving consistent results
depending on cluster configuration used.

2 files changed, 0 insertions, 15 deletions

diff --git a/src/test/regress/expected/xc_misc.out b/src/test/regress/expected/xc_misc.out
index b6af82aa2f..2cf4af4ba2 100644
--- a/src/test/regress/expected/xc_misc.out
+++ b/src/test/regress/expected/xc_misc.out
@@ -83,19 +83,6 @@ select get_unified_node_name(xc_node_id),* from t1 where xc_node_id > 0 order by
  NODE_2                | 7 | 44
 (4 rows)
 
-select get_unified_node_name(xc_node_id),* from t1 order by xc_node_id;
- get_unified_node_name | a | b  
------------------------+---+----
- NODE_1                | 2 | 11
- NODE_1                | 4 | 22
- NODE_1                | 6 | 33
- NODE_1                | 8 | 44
- NODE_2                | 1 | 11
- NODE_2                | 3 | 11
- NODE_2                | 5 | 22
- NODE_2                | 7 | 44
-(8 rows)
-
 create table t2(a int , xc_node_id int) distribute by modulo(a);
 ERROR:  column name "xc_node_id" conflicts with a system column name
 create table t2(a int , b int) distribute by modulo(xc_node_id);
diff --git a/src/test/regress/sql/xc_misc.sql b/src/test/regress/sql/xc_misc.sql
index 9e739c6f1c..ed85a369f1 100644
--- a/src/test/regress/sql/xc_misc.sql
+++ b/src/test/regress/sql/xc_misc.sql
@@ -64,8 +64,6 @@ select get_unified_node_name(xc_node_id),* from t1 order by a;
 
 select get_unified_node_name(xc_node_id),* from t1 where xc_node_id > 0 order by a;
 
-select get_unified_node_name(xc_node_id),* from t1 order by xc_node_id;
-
 create table t2(a int , xc_node_id int) distribute by modulo(a);
 
 create table t2(a int , b int) distribute by modulo(xc_node_id);