test-case-for-bug-17633.patch
text/x-patch
Filename: test-case-for-bug-17633.patch
Type: text/x-patch
Part: 0
Patch
Format: unified
| File | + | − |
|---|---|---|
| src/test/regress/expected/rules.out | 12 | 0 |
| src/test/regress/sql/rules.sql | 16 | 0 |
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index 9dd137415e..2fbc30aaad 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -3585,3 +3585,15 @@ DROP VIEW ruletest_v1; DROP TABLE ruletest_t2; DROP TABLE ruletest_t1; DROP USER regress_rule_user1; +-- +-- Test case for BUG 17633 +-- +CREATE TABLE ruletest_t1 (x int); +CREATE TABLE ruletest_t2 (a int, b int); +CREATE VIEW ruletest_v1 AS SELECT * FROM ruletest_t1; +CREATE RULE rule1 AS ON INSERT TO ruletest_v1 + DO ALSO INSERT INTO ruletest_t2(b) VALUES (NEW.*); +INSERT INTO ruletest_v1 VALUES (default), (default); +DROP VIEW ruletest_v1; +DROP TABLE ruletest_t1; +DROP TABLE ruletest_t2; diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql index bfb5f3b0bb..290ea2bd8a 100644 --- a/src/test/regress/sql/rules.sql +++ b/src/test/regress/sql/rules.sql @@ -1318,3 +1318,19 @@ DROP TABLE ruletest_t2; DROP TABLE ruletest_t1; DROP USER regress_rule_user1; + +-- +-- Test case for BUG 17633 +-- +CREATE TABLE ruletest_t1 (x int); +CREATE TABLE ruletest_t2 (a int, b int); +CREATE VIEW ruletest_v1 AS SELECT * FROM ruletest_t1; + +CREATE RULE rule1 AS ON INSERT TO ruletest_v1 + DO ALSO INSERT INTO ruletest_t2(b) VALUES (NEW.*); + +INSERT INTO ruletest_v1 VALUES (default), (default); + +DROP VIEW ruletest_v1; +DROP TABLE ruletest_t1; +DROP TABLE ruletest_t2;