From ab87bf147d60a3ca25bc67b760608558a1dce178 Mon Sep 17 00:00:00 2001
From: Pavan Deolasee
Date: Wed, 28 Jun 2017 15:02:18 +0530
Subject: Accept expected out changes for 'create_index' test case

It simply adds a new Remote Subquery Scan or Remote FQS node on top of the plan
obtained on PG
---
 src/test/regress/expected/create_index.out | 54 +++++++++++++++++-------------
 1 file changed, 31 insertions(+), 23 deletions(-)

diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out
index bccb6920dd..acf85f14c6 100644
--- a/src/test/regress/expected/create_index.out
+++ b/src/test/regress/expected/create_index.out
@@ -3057,41 +3057,49 @@ explain (costs off)
 create temp table boolindex (b bool, i int, unique(b, i), junk float);
 explain (costs off)
   select * from boolindex order by b, i limit 10;
-                      QUERY PLAN                       
--------------------------------------------------------
+                            QUERY PLAN                             
+-------------------------------------------------------------------
  Limit
-   ->  Index Scan using boolindex_b_i_key on boolindex
-(2 rows)
+   ->  Remote Subquery Scan on all (datanode_1,datanode_2)
+         ->  Limit
+               ->  Index Scan using boolindex_b_i_key on boolindex
+(4 rows)
 
 explain (costs off)
   select * from boolindex where b order by i limit 10;
-                      QUERY PLAN                       
--------------------------------------------------------
+                            QUERY PLAN                             
+-------------------------------------------------------------------
  Limit
-   ->  Index Scan using boolindex_b_i_key on boolindex
-         Index Cond: (b = true)
-         Filter: b
-(4 rows)
+   ->  Remote Subquery Scan on all (datanode_1,datanode_2)
+         ->  Limit
+               ->  Index Scan using boolindex_b_i_key on boolindex
+                     Index Cond: (b = true)
+                     Filter: b
+(6 rows)
 
 explain (costs off)
   select * from boolindex where b = true order by i desc limit 10;
-                           QUERY PLAN                           
-----------------------------------------------------------------
- Limit
-   ->  Index Scan Backward using boolindex_b_i_key on boolindex
-         Index Cond: (b = true)
-         Filter: b
-(4 rows)
+                              QUERY PLAN                              
+----------------------------------------------------------------------
+ Remote Fast Query Execution
+   Node/s: datanode_1
+   ->  Limit
+         ->  Index Scan Backward using boolindex_b_i_key on boolindex
+               Index Cond: (b = true)
+               Filter: b
+(6 rows)
 
 explain (costs off)
   select * from boolindex where not b order by i limit 10;
-                      QUERY PLAN                       
--------------------------------------------------------
+                            QUERY PLAN                             
+-------------------------------------------------------------------
  Limit
-   ->  Index Scan using boolindex_b_i_key on boolindex
-         Index Cond: (b = false)
-         Filter: (NOT b)
-(4 rows)
+   ->  Remote Subquery Scan on all (datanode_1,datanode_2)
+         ->  Limit
+               ->  Index Scan using boolindex_b_i_key on boolindex
+                     Index Cond: (b = false)
+                     Filter: (NOT b)
+(6 rows)
 
 --
 -- REINDEX (VERBOSE)
-- 
cgit v1.2.3