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

2 files changed, 12 insertions, 0 deletions

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;