From 8d7ff13ed5626ecdac2bb0b356445ff4192810aa Mon Sep 17 00:00:00 2001 From: Kevin Grittner Date: Thu, 14 Mar 2013 13:34:51 -0500 Subject: [PATCH] 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; -- 2.39.5