Test trigger_action.sql (id ab5e72af45db) (err)
trigger_action.stable.out.FILTERED 2019-08-10 01:20:42.817902292 +0200trigger_action.test.out.FILTERED 2019-08-10 01:20:42.822902334 +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 # 118 lines, 561 words, 3978 chars in all lines 4
5 5 5 5
..................
# after update on t_4_1 referencin
62 # for each row 62 61 # for each row 61
63 # when new_row.id >1000 insert into t_4_1 values(7, 'update_when_row_false'); 63 ! 62 # when (new_row.id>1000) insert into t_4_1 values(7, 'update_when_row_false'); 62
64 #update t_4_1 set name = 'mo' where id = 10; 64 ! 63 #select * from t_4_1; 63
65 [ 1 ] 65 -
66 % sys.t_4_1, sys.t_4_1 # table_name 66 64 % sys.t_4_1, sys.t_4_1 # table_name 64
..................
#update t_4_1 set name = 'mo' where id =
68 % int, varchar # type 68 66 % int, varchar # type 66
69 % 2, 27 # length 69 ! 67 % 2, 7 # length 67
70 [ 10, "mo" ] 70 ! 68 [ 10, "monetdb" ] 68
71 [ 20, "monet" ] 71 69 [ 20, "monet" ] 69
72 [ 0, "update_old_row_statement" ] 72 ! 70 #delete from t_4_1 where id >-1; 70
73 [ 1, "update_new_row_statement" ] 73 ! 71 [ 2 ] 71
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 72 #drop trigger test_4_1; 72