postgres.git / summary / log / commit / refs

commit    8d7ff13ed5626ecdac2bb0b356445ff4192810aa
Author:   Kevin Grittner <kgrittn@postgresql.org>
Date:     Thu Mar 14 18:34:51 2013 +0000
First released in: 9.3.0

    Add regression test for MV join to view.
    
    This would have caught a bug in the initial patch, and seems like
    a good thing to test going forward.
    
    Per bug report by Erik Rijkers and fix by Tom Lane


 src/test/regress/expected/matview.out | 9 +++++++++
 src/test/regress/sql/matview.sql      | 3 +++
 2 files changed, 12 insertions(+)

diff --git a/src/test/regress/expected/matview.out b/src/test/regress/expected/matview.out
index 1077651b8e1..f03b9196b02 100644
--- a/src/test/regress/expected/matview.out
+++ b/src/test/regress/expected/matview.out
@@ -327,6 +327,15 @@ SELECT * FROM tum;
  x    |      5
 (3 rows)
 
+-- test join of mv and view
+SELECT type, m.totamt AS mtot, v.totamt AS vtot FROM tm m LEFT JOIN tv v USING (type);
+ type | mtot | vtot 
+------+------+------
+ y    |   12 |   12
+ z    |   24 |   24
+ x    |    5 |    5
+(3 rows)
+
 -- test diemv when the mv does exist
 DROP MATERIALIZED VIEW IF EXISTS tum;
 -- make sure that dependencies are reported properly when they block the drop
diff --git a/src/test/regress/sql/matview.sql b/src/test/regress/sql/matview.sql
index e1c0e1583d6..a01d266ee56 100644
--- a/src/test/regress/sql/matview.sql
+++ b/src/test/regress/sql/matview.sql
@@ -103,6 +103,9 @@ REFRESH MATERIALIZED VIEW tum WITH DATA;
 SELECT pg_relation_is_scannable('tum'::regclass);
 SELECT * FROM tum;
 
+-- test join of mv and view
+SELECT type, m.totamt AS mtot, v.totamt AS vtot FROM tm m LEFT JOIN tv v USING (type);
+
 -- test diemv when the mv does exist
 DROP MATERIALIZED VIEW IF EXISTS tum;
 


[parent: f7559c0101af]