diff options
Diffstat (limited to 'src/test')
-rw-r--r-- | src/test/regress/expected/rules.out | 12 | ||||
-rw-r--r-- | src/test/regress/sql/rules.sql | 2 |
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 |