Test trigger_action.sql (id ab5e72af45db) (err)
trigger_action.stable.out.FILTERED 2019-08-10 01:19:41.167949700 +0200trigger_action.test.out.FILTERED 2019-08-10 01:19:41.167949700 +0200
1 Statistics about stdout of test 'trigger_action` in directory 'sql/test/Triggers`: 1 1 Statistics about stdout of test 'trigger_action` in directory 'sql/test/Triggers`: 1
2 33 lines, 137 words, 702 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 24 lines, 102 words, 460 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 33 lines, 137 words, 702 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 24 lines, 102 words, 460 chars in lines not matching '^$|^(\| |)#` 3
4 # 123 lines, 584 words, 4170 chars in all lines 4 ! 4 # 117 lines, 544 words, 3593 chars in all lines 4
5 5 5 5
..................
# after update on t_4_1 referencin
62 # for each row 62 60 # for each row 60
63 # when new_row.id >1000 insert into t_4_1 values(7, 'update_when_row_false'); 63 ! 61 # when (new_row.id>1000) insert into t_4_1 values(7, 'update_when_row_false'); 61
64 #update t_4_1 set name = 'mo' where id = 10; 64 ! 62 #select * from t_4_1; 62
65 [ 1 ] 65 -
66 % sys.t_4_1, sys.t_4_1 # table_name 66 63 % sys.t_4_1, sys.t_4_1 # table_name 63
..................
#update t_4_1 set name = 'mo' where id =
68 % int, varchar # type 68 65 % int, varchar # type 65
69 % 2, 27 # length 69 ! 66 % 2, 7 # length 66
70 [ 10, "mo" ] 70 ! 67 [ 10, "monetdb" ] 67
71 [ 20, "monet" ] 71 68 [ 20, "monet" ] 68
72 [ 0, "update_old_row_statement" ] 72 ! 69 #delete from t_4_1 where id >-1; 69
73 [ 1, "update_new_row_statement" ] 73 ! 70 [ 2 ] 70
74 [ 2, "update_statement" ] 74 -
75 [ 3, "update_row" ] 75 -
76 [ 4, "update_when_statement_true" ] 76 -
77 [ 5, "update_when_row_true" ] 77 -
78 [ 6, "update_when_statement_false" ] 78 -
79 [ 7, "update_when_row_false" ] 79 -
80 [ 10 ] 80 -
81 #drop trigger test_4_1; 81 71 #drop trigger test_4_1; 71