diff options
author | Pavan Deolasee | 2015-06-10 10:27:45 +0000 |
---|---|---|
committer | Pavan Deolasee | 2015-06-10 10:27:45 +0000 |
commit | 006b04a1a27f11704176a74cd4c45aa9b76bac60 (patch) | |
tree | e3d29f77b8bdb950b39a379106d3c811e334a409 /src | |
parent | 827c1042d8c3e197f918dba0ddd12bb88ba2e61f (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.out | 33 |
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; |