summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorPavan Deolasee2015-06-10 10:27:45 +0000
committerPavan Deolasee2015-06-10 10:27:45 +0000
commit006b04a1a27f11704176a74cd4c45aa9b76bac60 (patch)
treee3d29f77b8bdb950b39a379106d3c811e334a409 /src
parent827c1042d8c3e197f918dba0ddd12bb88ba2e61f (diff)
Fix a few expected output diffs in testcase 'matview'
There are more failures which need to be examined and fixed if needed
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/matview.out33
1 files changed, 21 insertions, 12 deletions
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;