diff options
| -rw-r--r-- | src/test/regress/expected/matview.out | 9 | ||||
| -rw-r--r-- | src/test/regress/sql/matview.sql | 3 |
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; |