From 006b04a1a27f11704176a74cd4c45aa9b76bac60 Mon Sep 17 00:00:00 2001
From: Pavan Deolasee
Date: Wed, 10 Jun 2015 15:57:45 +0530
Subject: Fix a few expected output diffs in testcase 'matview'

There are more failures which need to be examined and fixed if needed
---
 src/test/regress/expected/matview.out | 33 +++++++++++++++++++++------------
 1 file changed, 21 insertions(+), 12 deletions(-)

(limited to 'src')

diff --git a/src/test/regress/expected/matview.out b/src/test/regress/expected/matview.out
index eb13ea75fb..9ad19a6c92 100644
--- a/src/test/regress/expected/matview.out
+++ b/src/test/regress/expected/matview.out
@@ -19,12 +19,15 @@ SELECT * FROM tv ORDER BY type;
 -- create a materialized view with no data, and confirm correct behavior
 EXPLAIN (costs off)
   CREATE MATERIALIZED VIEW tm AS SELECT type, sum(amt) AS totamt FROM t GROUP BY type WITH NO DATA;
-     QUERY PLAN      
----------------------
+                        QUERY PLAN                         
+-----------------------------------------------------------
  HashAggregate
    Group Key: type
-   ->  Seq Scan on t
-(3 rows)
+   ->  Remote Subquery Scan on all (datanode_1,datanode_2)
+         ->  HashAggregate
+               Group Key: type
+               ->  Seq Scan on t
+(6 rows)
 
 CREATE MATERIALIZED VIEW tm AS SELECT type, sum(amt) AS totamt FROM t GROUP BY type WITH NO DATA;
 SELECT relispopulated FROM pg_class WHERE oid = 'tm'::regclass;
@@ -55,14 +58,17 @@ SELECT * FROM tm;
 -- create various views
 EXPLAIN (costs off)
   CREATE MATERIALIZED VIEW tvm AS SELECT * FROM tv ORDER BY type;
-        QUERY PLAN         
----------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Sort
    Sort Key: t.type
    ->  HashAggregate
          Group Key: t.type
-         ->  Seq Scan on t
-(5 rows)
+         ->  Remote Subquery Scan on all (datanode_1,datanode_2)
+               ->  HashAggregate
+                     Group Key: t.type
+                     ->  Seq Scan on t
+(8 rows)
 
 CREATE MATERIALIZED VIEW tvm AS SELECT * FROM tv ORDER BY type;
 SELECT * FROM tvm;
@@ -80,13 +86,16 @@ CREATE UNIQUE INDEX tvmm_pred ON tvmm (grandtot) WHERE grandtot < 0;
 CREATE VIEW tvv AS SELECT sum(totamt) AS grandtot FROM tv;
 EXPLAIN (costs off)
   CREATE MATERIALIZED VIEW tvvm AS SELECT * FROM tvv;
-        QUERY PLAN         
----------------------------
+                           QUERY PLAN                            
+-----------------------------------------------------------------
  Aggregate
    ->  HashAggregate
          Group Key: t.type
-         ->  Seq Scan on t
-(4 rows)
+         ->  Remote Subquery Scan on all (datanode_1,datanode_2)
+               ->  HashAggregate
+                     Group Key: t.type
+                     ->  Seq Scan on t
+(7 rows)
 
 CREATE MATERIALIZED VIEW tvvm AS SELECT * FROM tvv;
 CREATE VIEW tvvmv AS SELECT * FROM tvvm;
-- 
cgit v1.2.3