Test trigger_action.sql (id 001aedfec00f) (err)
trigger_action.stable.out.FILTERED 2018-12-06 00:58:33.056401983 +0100trigger_action.test.out.FILTERED 2018-12-06 00:58:33.066402453 +0100
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 34 lines, 138 words, 708 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 25 lines, 103 words, 466 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 34 lines, 138 words, 708 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 25 lines, 103 words, 466 chars in lines not matching '^$|^(\| |)#` 3
4 # 124 lines, 585 words, 4176 chars in all lines 4 ! 4 # 120 lines, 563 words, 3870 chars in all lines 4
5 5 5 5
..................
# after update on t_4_1 referencin
63 # for each row 63 63 # for each row 63
64 # when new_row.id >1000 insert into t_4_1 values(7, 'update_when_row_false'); 64 ! 64 # when (new_row.id>1000) insert into t_4_1 values(7, 'update_when_row_false'); 64
65 #update t_4_1 set name = 'mo' where id = 10; 65 ! 65 #select * from t_4_1; 65
66 [ 1 ] 66 -
67 % sys.t_4_1, sys.t_4_1 # table_name 67 66 % sys.t_4_1, sys.t_4_1 # table_name 66
..................
#update t_4_1 set name = 'mo' where id =
69 % int, varchar # type 69 68 % int, varchar # type 68
70 % 2, 27 # length 70 ! 69 % 2, 7 # length 69
71 [ 10, "mo" ] 71 ! 70 [ 10, "monetdb" ] 70
72 [ 20, "monet" ] 72 71 [ 20, "monet" ] 71
73 [ 0, "update_old_row_statement" ] 73 ! 72 #delete from t_4_1 where id >-1; 72
74 [ 1, "update_new_row_statement" ] 74 ! 73 [ 2 ] 73
75 [ 2, "update_statement" ] 75 -
76 [ 3, "update_row" ] 76 -
77 [ 4, "update_when_statement_true" ] 77 -
78 [ 5, "update_when_row_true" ] 78 -
79 [ 6, "update_when_statement_false" ] 79 -
80 [ 7, "update_when_row_false" ] 80 -
81 [ 10 ] 81 -
82 #drop trigger test_4_1; 82 74 #drop trigger test_4_1; 74