Test trigger_action.sql (id 3c6cbe78e1fe) (out)
trigger_action.stable.err.FILTERED 2019-09-08 12:13:46.704168882 +0200trigger_action.test.err.FILTERED 2019-09-08 12:13:46.708168916 +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, 95 words, 889 chars in all lines 4
5 5 5 5
..................
# 17 lines, 74 words,
8 8 8 8
9 # 21:20:07 > 9 ! 9 # 12:13:45 > 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 # 12:13:45 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36551" "--set" "mapi_usock=/var/tmp/mtest-5732/.s.monetdb.36551" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/3c6cbe78e1fe-1-1-1/tests/sql/dbfarm/mTests_sql_test_Triggers" "--set" "embedded_c=true" 10
11 # 21:20:07 > 11 ! 11 # 12:13:45 > 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 # 12:13:46 > 15
16 # 21:20:08 > 16 ! 16 # 12:13:46 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-5732" "--port=36551" 16
17 17 ! 17 # 12:13:46 > 17
18 18 ! 18 18
19 # 21:20:08 > 19 ! 19 #~ MAPI = (monetdb) /var/tmp/mtest-5732/.s.monetdb.36551 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 # 12:13:46 > 24
+ 25 # 12:13:46 > "Done." 25
+ 26 # 12:13:46 > 26
22 22 27 27