diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/with.out | 4 | ||||
| -rw-r--r-- | src/test/regress/sql/with.sql | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/with.out b/src/test/regress/expected/with.out index 30dd900e114..7f2e32d8b04 100644 --- a/src/test/regress/expected/with.out +++ b/src/test/regress/expected/with.out @@ -2515,14 +2515,14 @@ SELECT * FROM bug6051_2; 3 (3 rows) --- check INSERT...SELECT rule actions are disallowed on commands +-- check INSERT ... SELECT rule actions are disallowed on commands -- that have modifyingCTEs CREATE OR REPLACE RULE bug6051_ins AS ON INSERT TO bug6051 DO INSTEAD INSERT INTO bug6051_2 SELECT NEW.i; WITH t1 AS ( DELETE FROM bug6051 RETURNING * ) INSERT INTO bug6051 SELECT * FROM t1; -ERROR: INSERT...SELECT rule actions are not supported for queries having data-modifying statements in WITH +ERROR: INSERT ... SELECT rule actions are not supported for queries having data-modifying statements in WITH -- silly example to verify that hasModifyingCTE flag is propagated CREATE TEMP TABLE bug6051_3 AS SELECT a FROM generate_series(11,13) AS a; diff --git a/src/test/regress/sql/with.sql b/src/test/regress/sql/with.sql index 5c52561a8aa..0f5730797fa 100644 --- a/src/test/regress/sql/with.sql +++ b/src/test/regress/sql/with.sql @@ -1169,7 +1169,7 @@ INSERT INTO bug6051 SELECT * FROM t1; SELECT * FROM bug6051; SELECT * FROM bug6051_2; --- check INSERT...SELECT rule actions are disallowed on commands +-- check INSERT ... SELECT rule actions are disallowed on commands -- that have modifyingCTEs CREATE OR REPLACE RULE bug6051_ins AS ON INSERT TO bug6051 DO INSTEAD INSERT INTO bug6051_2 |