Test trigger_action.sql (id fe8055a86502) (out)
trigger_action.stable.err.FILTERED 2019-09-12 11:14:48.002373656 +0200trigger_action.test.err.FILTERED 2019-09-12 11:14:48.002373656 +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 # 23 lines, 100 words, 962 chars in all lines 4
5 5 5 5
..................
# 17 lines, 74 words,
8 8 8 8
9 # 21:20:07 > 9 ! 9 # 11:14:47 > 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 # 11:14:47 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=8" "--set" "mapi_open=true" "--set" "mapi_port=34826" "--set" "mapi_usock=/var/tmp/mtest-115153/.s.monetdb.34826" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/home/monet/testing/fe8055a86502-7-1-2/tests/sql/dbfarm/mTests_sql_test_Triggers" "--set" "embedded_c=true" 10
11 # 21:20:07 > 11 ! 11 # 11:14:47 > 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 #main thread:!ERROR:MALException:client.quit:Server stopped 14
15 # 21:20:08 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=37598 < trigger_action.sql 15 ! 15 15
16 # 21:20:08 > 16 ! 16 # 11:14:47 > 16
17 17 ! 17 # 11:14:47 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-115153" "--port=34826" 17
18 18 ! 18 # 11:14:47 > 18
19 # 21:20:08 > 19 ! 19 19
20 # 21:20:08 > Done. 20 ! 20 #~ MAPI = (monetdb) /var/tmp/mtest-115153/.s.monetdb.34826 20
21 # 21:20:08 > 21 ! 21 QUERY = update t_4_1 set name = 'mo' where id = 10; 21
+ 22 ERROR = !UPDATE: triggers failed for table 't_4_1' 22
+ 23 CODE = 27000 23
+ 24 24
+ 25 # 11:14:47 > 25
+ 26 # 11:14:47 > "Done." 26
+ 27 # 11:14:47 > 27
22 22 28 28