aboutsummaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/rules.out12
-rw-r--r--src/test/regress/sql/rules.sql2
2 files changed, 14 insertions, 0 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out
index 14e72143468..abe3a43cd27 100644
--- a/src/test/regress/expected/rules.out
+++ b/src/test/regress/expected/rules.out
@@ -3025,6 +3025,18 @@ create view rule_v1 as values(1,2);
View definition:
VALUES (1,2);
+alter table rule_v1 rename column column2 to q2;
+\d+ rule_v1
+ View "public.rule_v1"
+ Column | Type | Collation | Nullable | Default | Storage | Description
+---------+---------+-----------+----------+---------+---------+-------------
+ column1 | integer | | | | plain |
+ q2 | integer | | | | plain |
+View definition:
+ SELECT "*VALUES*".column1,
+ "*VALUES*".column2 AS q2
+ FROM (VALUES (1,2)) "*VALUES*";
+
drop view rule_v1;
create view rule_v1(x) as values(1,2);
\d+ rule_v1
diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql
index a042e595469..b7d7f434b6a 100644
--- a/src/test/regress/sql/rules.sql
+++ b/src/test/regress/sql/rules.sql
@@ -1047,6 +1047,8 @@ DROP TABLE rule_t1;
--
create view rule_v1 as values(1,2);
\d+ rule_v1
+alter table rule_v1 rename column column2 to q2;
+\d+ rule_v1
drop view rule_v1;
create view rule_v1(x) as values(1,2);
\d+ rule_v1