Fix expected output for rangetypes test case

1 files changed, 19 insertions, 18 deletions

diff --git a/src/test/regress/expected/rangetypes.out b/src/test/regress/expected/rangetypes.out
index ed13513e9a..10c6e57e19 100644
--- a/src/test/regress/expected/rangetypes.out
+++ b/src/test/regress/expected/rangetypes.out
@@ -260,12 +260,12 @@ select * from numrange_test where nr = '[1.1, 2.2)' ORDER BY nr;
  [1.1,2.2)
 (1 row)
 
-select * from numrange_test where nr < 'empty';
+select * from numrange_test where nr < 'empty' ORDER BY nr;
  nr 
 ----
 (0 rows)
 
-select * from numrange_test where nr < numrange(-1000.0, -1000.0,'[]');
+select * from numrange_test where nr < numrange(-1000.0, -1000.0,'[]') ORDER BY nr;
   nr   
 -------
  empty
@@ -292,34 +292,34 @@ select * from numrange_test where nr < numrange(1000.0, 1001.0,'[]') ORDER BY nr
  [3,)
 (6 rows)
 
-select * from numrange_test where nr <= 'empty';
+select * from numrange_test where nr <= 'empty' ORDER BY nr;
   nr   
 -------
  empty
 (1 row)
 
-select * from numrange_test where nr >= 'empty';
+select * from numrange_test where nr >= 'empty' ORDER BY nr;
     nr     
 -----------
- (,)
- [3,)
+ empty
  (,5)
+ (,)
  [1.1,2.2)
- empty
  [1.7,1.7]
+ [3,)
 (6 rows)
 
-select * from numrange_test where nr > 'empty';
+select * from numrange_test where nr > 'empty' ORDER BY nr;
     nr     
 -----------
- (,)
- [3,)
  (,5)
+ (,)
  [1.1,2.2)
  [1.7,1.7]
+ [3,)
 (5 rows)
 
-select * from numrange_test where nr > numrange(-1001.0, -1000.0,'[]');
+select * from numrange_test where nr > numrange(-1001.0, -1000.0,'[]') ORDER BY nr;
     nr     
 -----------
  [1.1,2.2)
@@ -1093,13 +1093,14 @@ select count(*) from test_range_spgist where ir -|- int4range(100,500);
 -- test index-only scans
 explain (costs off)
 select ir from test_range_spgist where ir -|- int4range(10,20) order by ir;
-                               QUERY PLAN                               
-------------------------------------------------------------------------
- Sort
-   Sort Key: ir
-   ->  Index Only Scan using test_range_spgist_idx on test_range_spgist
-         Index Cond: (ir -|- '[10,20)'::int4range)
-(4 rows)
+                                  QUERY PLAN                                  
+------------------------------------------------------------------------------
+ Remote Subquery Scan on all (datanode_1,datanode_2)
+   ->  Sort
+         Sort Key: ir
+         ->  Index Only Scan using test_range_spgist_idx on test_range_spgist
+               Index Cond: (ir -|- '[10,20)'::int4range)
+(5 rows)
 
 select ir from test_range_spgist where ir -|- int4range(10,20) order by ir;
      ir