diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/merge.out | 16 | ||||
| -rw-r--r-- | src/test/regress/sql/merge.sql | 18 |
2 files changed, 0 insertions, 34 deletions
diff --git a/src/test/regress/expected/merge.out b/src/test/regress/expected/merge.out index 787af41dfe5..d2e33377272 100644 --- a/src/test/regress/expected/merge.out +++ b/src/test/regress/expected/merge.out @@ -843,22 +843,6 @@ SELECT * FROM wq_target; 1 | 499 (1 row) --- test preventing WHEN conditions from writing to the database -create or replace function merge_when_and_write() returns boolean -language plpgsql as -$$ -BEGIN - INSERT INTO target VALUES (100, 100); - RETURN TRUE; -END; -$$; -BEGIN; -MERGE INTO wq_target t -USING wq_source s ON t.tid = s.sid -WHEN MATCHED AND (merge_when_and_write()) THEN - UPDATE SET balance = t.balance + s.balance; -ROLLBACK; -drop function merge_when_and_write(); DROP TABLE wq_target, wq_source; -- test triggers create or replace function merge_trigfunc () returns trigger diff --git a/src/test/regress/sql/merge.sql b/src/test/regress/sql/merge.sql index 4d486b4433d..e5754f3cd9c 100644 --- a/src/test/regress/sql/merge.sql +++ b/src/test/regress/sql/merge.sql @@ -564,24 +564,6 @@ WHEN MATCHED AND t.tableoid >= 0 THEN UPDATE SET balance = t.balance + s.balance; SELECT * FROM wq_target; --- test preventing WHEN conditions from writing to the database -create or replace function merge_when_and_write() returns boolean -language plpgsql as -$$ -BEGIN - INSERT INTO target VALUES (100, 100); - RETURN TRUE; -END; -$$; - -BEGIN; -MERGE INTO wq_target t -USING wq_source s ON t.tid = s.sid -WHEN MATCHED AND (merge_when_and_write()) THEN - UPDATE SET balance = t.balance + s.balance; -ROLLBACK; -drop function merge_when_and_write(); - DROP TABLE wq_target, wq_source; -- test triggers |