Fix expected output file for the testcase 'gist'

1 files changed, 53 insertions, 48 deletions

diff --git a/src/test/regress/expected/gist.out b/src/test/regress/expected/gist.out
index c2ab9c92c3..e4abd37446 100644
--- a/src/test/regress/expected/gist.out
+++ b/src/test/regress/expected/gist.out
@@ -35,39 +35,41 @@ create index gist_tbl_point_index on gist_tbl using gist (p);
 -- check that the planner chooses an index-only scan
 explain (costs off)
 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5));
-                       QUERY PLAN                       
---------------------------------------------------------
- Index Only Scan using gist_tbl_point_index on gist_tbl
-   Index Cond: (p <@ '(0.5,0.5),(0,0)'::box)
-(2 rows)
+                          QUERY PLAN                          
+--------------------------------------------------------------
+ Remote Subquery Scan on all (datanode_1,datanode_2)
+   ->  Index Only Scan using gist_tbl_point_index on gist_tbl
+         Index Cond: (p <@ '(0.5,0.5),(0,0)'::box)
+(3 rows)
 
 -- execute the same
 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5));
       p      
 -------------
  (0,0)
- (0.05,0.05)
  (0.1,0.1)
- (0.15,0.15)
  (0.2,0.2)
- (0.25,0.25)
  (0.3,0.3)
- (0.35,0.35)
  (0.4,0.4)
- (0.45,0.45)
  (0.5,0.5)
+ (0.05,0.05)
+ (0.15,0.15)
+ (0.25,0.25)
+ (0.35,0.35)
+ (0.45,0.45)
 (11 rows)
 
 -- Also test an index-only knn-search
 explain (costs off)
 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
 order by p <-> point(0.2, 0.2);
-                       QUERY PLAN                       
---------------------------------------------------------
- Index Only Scan using gist_tbl_point_index on gist_tbl
-   Index Cond: (p <@ '(0.5,0.5),(0,0)'::box)
-   Order By: (p <-> '(0.2,0.2)'::point)
-(3 rows)
+                          QUERY PLAN                          
+--------------------------------------------------------------
+ Remote Subquery Scan on all (datanode_1,datanode_2)
+   ->  Index Only Scan using gist_tbl_point_index on gist_tbl
+         Index Cond: (p <@ '(0.5,0.5),(0,0)'::box)
+         Order By: (p <-> '(0.2,0.2)'::point)
+(4 rows)
 
 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
 order by p <-> point(0.2, 0.2);
@@ -80,8 +82,8 @@ order by p <-> point(0.2, 0.2);
  (0.1,0.1)
  (0.35,0.35)
  (0.05,0.05)
- (0,0)
  (0.4,0.4)
+ (0,0)
  (0.45,0.45)
  (0.5,0.5)
 (11 rows)
@@ -90,12 +92,13 @@ order by p <-> point(0.2, 0.2);
 explain (costs off)
 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
 order by point(0.1, 0.1) <-> p;
-                       QUERY PLAN                       
---------------------------------------------------------
- Index Only Scan using gist_tbl_point_index on gist_tbl
-   Index Cond: (p <@ '(0.5,0.5),(0,0)'::box)
-   Order By: (p <-> '(0.1,0.1)'::point)
-(3 rows)
+                          QUERY PLAN                          
+--------------------------------------------------------------
+ Remote Subquery Scan on all (datanode_1,datanode_2)
+   ->  Index Only Scan using gist_tbl_point_index on gist_tbl
+         Index Cond: (p <@ '(0.5,0.5),(0,0)'::box)
+         Order By: (p <-> '(0.1,0.1)'::point)
+(4 rows)
 
 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
 order by point(0.1, 0.1) <-> p;
@@ -120,37 +123,38 @@ create index gist_tbl_box_index on gist_tbl using gist (b);
 -- check that the planner chooses an index-only scan
 explain (costs off)
 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
-                      QUERY PLAN                      
-------------------------------------------------------
- Index Only Scan using gist_tbl_box_index on gist_tbl
-   Index Cond: (b <@ '(6,6),(5,5)'::box)
-(2 rows)
+                         QUERY PLAN                         
+------------------------------------------------------------
+ Remote Subquery Scan on all (datanode_1,datanode_2)
+   ->  Index Only Scan using gist_tbl_box_index on gist_tbl
+         Index Cond: (b <@ '(6,6),(5,5)'::box)
+(3 rows)
 
 -- execute the same
 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
             b            
 -------------------------
  (5,5),(5,5)
- (5.05,5.05),(5.05,5.05)
  (5.1,5.1),(5.1,5.1)
- (5.15,5.15),(5.15,5.15)
  (5.2,5.2),(5.2,5.2)
- (5.25,5.25),(5.25,5.25)
  (5.3,5.3),(5.3,5.3)
- (5.35,5.35),(5.35,5.35)
  (5.4,5.4),(5.4,5.4)
- (5.45,5.45),(5.45,5.45)
  (5.5,5.5),(5.5,5.5)
- (5.55,5.55),(5.55,5.55)
  (5.6,5.6),(5.6,5.6)
- (5.65,5.65),(5.65,5.65)
  (5.7,5.7),(5.7,5.7)
- (5.75,5.75),(5.75,5.75)
  (5.8,5.8),(5.8,5.8)
- (5.85,5.85),(5.85,5.85)
  (5.9,5.9),(5.9,5.9)
- (5.95,5.95),(5.95,5.95)
  (6,6),(6,6)
+ (5.05,5.05),(5.05,5.05)
+ (5.15,5.15),(5.15,5.15)
+ (5.25,5.25),(5.25,5.25)
+ (5.35,5.35),(5.35,5.35)
+ (5.45,5.45),(5.45,5.45)
+ (5.55,5.55),(5.55,5.55)
+ (5.65,5.65),(5.65,5.65)
+ (5.75,5.75),(5.75,5.75)
+ (5.85,5.85),(5.85,5.85)
+ (5.95,5.95),(5.95,5.95)
 (21 rows)
 
 drop index gist_tbl_box_index;
@@ -160,11 +164,12 @@ create index gist_tbl_multi_index on gist_tbl using gist (p, c);
 explain (costs off)
 select p, c from gist_tbl
 where p <@ box(point(5,5), point(6, 6));
-                    QUERY PLAN                     
----------------------------------------------------
- Index Scan using gist_tbl_multi_index on gist_tbl
-   Index Cond: (p <@ '(6,6),(5,5)'::box)
-(2 rows)
+                       QUERY PLAN                        
+---------------------------------------------------------
+ Remote Subquery Scan on all (datanode_1,datanode_2)
+   ->  Index Scan using gist_tbl_multi_index on gist_tbl
+         Index Cond: (p <@ '(6,6),(5,5)'::box)
+(3 rows)
 
 -- execute the same
 select b, p from gist_tbl
@@ -173,16 +178,16 @@ and p <@ box(point(5,5), point(6, 6));
             b            |      p      
 -------------------------+-------------
  (5,5),(5,5)             | (5,5)
- (5.05,5.05),(5.05,5.05) | (5.05,5.05)
  (5.1,5.1),(5.1,5.1)     | (5.1,5.1)
- (5.15,5.15),(5.15,5.15) | (5.15,5.15)
  (5.2,5.2),(5.2,5.2)     | (5.2,5.2)
- (5.25,5.25),(5.25,5.25) | (5.25,5.25)
  (5.3,5.3),(5.3,5.3)     | (5.3,5.3)
- (5.35,5.35),(5.35,5.35) | (5.35,5.35)
  (5.4,5.4),(5.4,5.4)     | (5.4,5.4)
- (5.45,5.45),(5.45,5.45) | (5.45,5.45)
  (5.5,5.5),(5.5,5.5)     | (5.5,5.5)
+ (5.05,5.05),(5.05,5.05) | (5.05,5.05)
+ (5.15,5.15),(5.15,5.15) | (5.15,5.15)
+ (5.25,5.25),(5.25,5.25) | (5.25,5.25)
+ (5.35,5.35),(5.35,5.35) | (5.35,5.35)
+ (5.45,5.45),(5.45,5.45) | (5.45,5.45)
 (11 rows)
 
 drop index gist_tbl_multi_index;