Changeset: 64fa4070adc0 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=64fa4070adc0
Modified Files:
sql/test/Triggers/Tests/trigger_activation.stable.out
sql/test/Triggers/trigger_activation.sql
Branch: nostmt
Log Message:
approved output
diffs (45 lines):
diff --git a/sql/test/Triggers/Tests/trigger_activation.stable.out
b/sql/test/Triggers/Tests/trigger_activation.stable.out
--- a/sql/test/Triggers/Tests/trigger_activation.stable.out
+++ b/sql/test/Triggers/Tests/trigger_activation.stable.out
@@ -26,13 +26,27 @@ Ready.
[ 1 ]
[ 1 ]
-[ 1 ]
+#create trigger test_5_1
+# after update on t_5_1
+# delete from t_5_1 where name = 'monetdb' and id = 10;
+#create trigger test_5_2
+# before update on t_5_1
+# insert into t_5_1 values(11,'amsterdam');
+#create trigger test_5_3
+# after update on t_5_1
+# insert into t_5_1 values(10, 'update_from_test_5_3');
+#create trigger test_5_4
+# after update on t_5_1
+# insert into t_5_1 values(30, 'update_from_test_5_4');
+#update t_5_1 set name = 'mo' where id = 11;
+[ 0 ]
+#select * from t_5_1;
% sys.t_5_1, sys.t_5_1 # table_name
% id, name # name
% int, varchar # type
% 2, 20 # length
[ 20, "monet" ]
-[ 11, "mo" ]
+[ 11, "amsterdam" ]
[ 10, "update_from_test_5_3" ]
[ 30, "update_from_test_5_4" ]
[ 4 ]
diff --git a/sql/test/Triggers/trigger_activation.sql
b/sql/test/Triggers/trigger_activation.sql
--- a/sql/test/Triggers/trigger_activation.sql
+++ b/sql/test/Triggers/trigger_activation.sql
@@ -12,6 +12,8 @@ create trigger test_5_1
after update on t_5_1
delete from t_5_1 where name = 'monetdb' and id = 10;
+-- first we need to know what to update (no id=11 jet)
+-- ie this trigger will no fire.
create trigger test_5_2
before update on t_5_1
insert into t_5_1 values(11,'amsterdam');
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
