Changeset: 679729082453 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=679729082453 Added Files: sql/test/Triggers/Tests/cascaded_triggers.test sql/test/Triggers/Tests/recursive_triggers.test sql/test/Triggers/Tests/referencing_clause_new.test sql/test/Triggers/Tests/referencing_clause_old.test sql/test/Triggers/Tests/trigger_activation.test sql/test/Triggers/Tests/trigger_insert.test sql/test/Triggers/Tests/triggers_schema_operations.test Modified Files: sql/test/Triggers/Tests/trigger_owner.SQL.py sql/test/Triggers/Tests/trigger_owner.stable.err sql/test/Triggers/Tests/trigger_owner.stable.out Branch: mtest Log Message:
Converted sql/test/Triggers directory diffs (truncated from 1318 to 300 lines): diff --git a/sql/test/Triggers/Tests/cascaded_triggers.test b/sql/test/Triggers/Tests/cascaded_triggers.test new file mode 100644 --- /dev/null +++ b/sql/test/Triggers/Tests/cascaded_triggers.test @@ -0,0 +1,96 @@ +statement ok +create table t_0_1(id int, name varchar(1024), age int) + +statement ok +create table t_0_2(id int, age int) + +statement ok +create trigger test_0 after insert on t_0_1 + insert into t_0_2 select t_0_1.id,t_0_1.age from t_0_1 + +statement ok +insert into t_0_1 values(1, 'mo', 25) + +query ITI rowsort +select * from t_0_1 +---- +1 +mo +25 + +query II rowsort +select * from t_0_2 +---- +1 +25 + +statement ok +create trigger test_1 after delete on t_0_1 + insert into t_0_1 values(3, 'mo', 27) + +statement ok +delete from t_0_1 where id = 1 + +query ITI rowsort +select * from t_0_1 +---- +3 +mo +27 + +query II rowsort +select * from t_0_2 +---- +1 +25 +3 +27 + +statement ok +create trigger test_2 after update on t_0_1 + delete from t_0_2 + +statement ok +create trigger test_3 after delete on t_0_2 + insert into t_0_1 values(1, 'mo', 25) + +statement ok +update t_0_1 set name = 'monet' where id = 2 + +query ITI rowsort +select * from t_0_1 +---- +1 +mo +25 +3 +mo +27 + +query II rowsort +select * from t_0_2 +---- +1 +25 +3 +27 + +statement ok +drop trigger test_0 + +statement ok +drop trigger test_1 + +statement ok +drop trigger test_2 + +statement ok +drop trigger test_3 + +statement ok +drop table t_0_1 + +statement ok +drop table t_0_2 + + diff --git a/sql/test/Triggers/Tests/recursive_triggers.test b/sql/test/Triggers/Tests/recursive_triggers.test new file mode 100644 --- /dev/null +++ b/sql/test/Triggers/Tests/recursive_triggers.test @@ -0,0 +1,83 @@ +statement ok +create table t_1_1(id int, name varchar(1024), age int) + +statement ok +create table t_1_2(id int, age int) + +statement ok +create trigger test_0 after insert on t_1_1 + insert into t_1_1 values(3, 'mo', 27) + +statement ok +drop trigger test_0 + +statement ok +create trigger test_0 after insert on t_1_1 + insert into t_1_2 select id,age from t_1_1 + +statement ok +create trigger test_1 after insert on t_1_2 + insert into t_1_1 values(3, 'mo', 27) + +statement ok +drop trigger test_0 + +statement ok +drop trigger test_1 + +statement ok +create trigger test_0 after insert on t_1_1 + insert into t_1_2 select id,age from t_1_1 + +statement ok +create trigger test_1 after insert on t_1_2 + delete from t_1_2 + +statement ok +create trigger test_2 after delete on t_1_2 + insert into t_1_1 values(3, 'mo', 27) + +statement ok +drop trigger test_0 + +statement ok +drop trigger test_1 + +statement ok +drop trigger test_2 + +statement ok +create PROCEDURE p1(id int, age int) +BEGIN + insert into t_1_2 values(id, age); +END + +statement ok +create PROCEDURE p1() +BEGIN + declare id int, age int; + set id = 1; + set age = 23; + call p1(id, age); +END + +statement ok +create trigger test_0 after insert on t_1_2 +BEGIN ATOMIC + insert into t_1_1 values(1, 'monetdb', 24); + call p1(); +END + +statement ok +drop trigger test_0 + +statement ok +drop ALL procedure p1 + +statement ok +drop table t_1_1 + +statement ok +drop table t_1_2 + + diff --git a/sql/test/Triggers/Tests/referencing_clause_new.test b/sql/test/Triggers/Tests/referencing_clause_new.test new file mode 100644 --- /dev/null +++ b/sql/test/Triggers/Tests/referencing_clause_new.test @@ -0,0 +1,391 @@ +statement ok +create table t_2_1 (id int, name varchar(1024)) + +statement ok +create table t_2_2 (id int, name varchar(1024)) + +statement ok +insert into t_2_1 values(10, 'monetdb') + +statement ok +insert into t_2_1 values(20, 'monet') + +statement ok +create trigger test_2_1 + after update on t_2_1 referencing new row as new_row + for each row insert into t_2_2 values(0, 'update_new_row') + +statement ok +create trigger test_2_2 + after update on t_2_1 referencing new row new_row + for each row insert into t_2_2 values(1, 'update_new_row') + +statement ok +create trigger test_2_3 + after update on t_2_1 referencing new as new_row + for each row insert into t_2_2 values(2, 'update_new_row') + +statement ok +create trigger test_2_4 + after update on t_2_1 referencing new new_row + for each row insert into t_2_2 values(3, 'update_new_row') + +statement ok +update t_2_1 set name = 'mo' where id = 10 + +query IT rowsort +select * from t_2_1 +---- +10 +mo +20 +monet + +query IT rowsort +select * from t_2_2 +---- +0 +update_new_row +1 +update_new_row +2 +update_new_row +3 +update_new_row + +statement ok +delete from t_2_1 where id > -1 + +statement ok +delete from t_2_2 where id > -1 + +statement ok +drop trigger test_2_1 + +statement ok +drop trigger test_2_2 + +statement ok +drop trigger test_2_3 + +statement ok +drop trigger test_2_4 + +statement ok +insert into t_2_1 values(10, 'monetdb') + +statement ok +insert into t_2_1 values(20, 'monet') + +statement ok +create trigger test_2_1 + after delete on t_2_1 + for each row insert into t_2_2 values(0, 'delete_new_row') + +statement ok +create trigger test_2_2 + after delete on t_2_1 + for each row insert into t_2_2 values(1, 'delete_new_row') + +statement ok +create trigger test_2_3 + after delete on t_2_1 + for each row insert into t_2_2 values(2, 'delete_new_row') + +statement ok +create trigger test_2_4 + after delete on t_2_1 + for each row insert into t_2_2 values(3, 'delete_new_row') + +statement ok +delete from t_2_1 where id >-1 + +query IT rowsort +select * from t_2_1 +---- + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
