Test trigger_action.sql (id 3c6cbe78e1fe) (out)
trigger_action.stable.err.FILTERED 2019-09-08 16:20:12.977296000 +0200trigger_action.test.err.FILTERED 2019-09-08 16:20:12.977296000 +0200
1 Statistics about stderr of test 'trigger_action` in directory 'sql/test/Triggers`: 1 1 Statistics about stderr of test 'trigger_action` in directory 'sql/test/Triggers`: 1
2 1 lines, 8 words, 72 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 4 lines, 31 words, 185 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 72 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 4 lines, 31 words, 185 chars in lines not matching '^$|^(\| |)#` 3
4 # 17 lines, 74 words, 914 chars in all lines 4 ! 4 # 22 lines, 90 words, 733 chars in all lines 4
5 5 5 5
..................
# 17 lines, 74 words,
8 8 8 8
9 # 21:20:07 > 9 ! 9 # 16:20:12 > 9
10 # 21:20:07 > Mtimeout -timeout 180 Mserver "--config=/ufs/goncalve/scratch/MonetDB/monetdb4/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB:/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB/lib:/ufs/goncalve/scratch/MonetDB/monetdb4/lib/MonetDB/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/monetdb4/var/MonetDB/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/monetdb4/var/MonetDB/sql_logs" --set "xquery_logdir=something" --set mapi_port=37598 --set monet_prompt= --trace "--dbname=mTests_src_test_Triggers" --dbinit=" module(sql_server);" ; echo ; echo Over.. 10 ! 10 # 16:20:12 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=37594" "--forcemito" "--dbpath=C:\monettesting\3c6cbe78e1fe-3-1-4\tests\sql\dbfarm\mTests_sql_test_Triggers" "--set" "embedded_c=true" 10
11 # 21:20:07 > 11 ! 11 # 16:20:12 > 11
12 12 ! 12 12
13 13 ! 13 #client2:!ERROR:ParseException:SQLparser:27000!UPDATE: triggers failed for table 't_4_1' 13
14 # 21:20:08 > 14 ! 14 14
15 # 21:20:08 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=37598 < trigger_action.sql 15 ! 15 # 16:20:12 > 15
16 # 21:20:08 > 16 ! 16 # 16:20:12 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=37594" 16
17 17 ! 17 # 16:20:12 > 17
18 18 ! 18 18
19 # 21:20:08 > 19 ! 19 #~ MAPI = monetdb@LAB03:37594 19
20 # 21:20:08 > Done. 20 ! 20 QUERY = update t_4_1 set name = 'mo' where id = 10; 20
21 # 21:20:08 > 21 ! 21 ERROR = !UPDATE: triggers failed for table 't_4_1' 21
+ 22 CODE = 27000 22
+ 23 23
+ 24 # 16:20:12 > 24
+ 25 # 16:20:12 > "Done." 25
+ 26 # 16:20:12 > 26
22 22 27 27