Test seq-default.sql (id 9f8602e8c51d) (out)
seq-default.stable.err.FILTERED 2018-10-18 00:35:05.764058800 +0200seq-default.test.err.FILTERED 2018-10-18 00:35:05.770058800 +0200
1 Statistics about stderr of test 'seq-default` in directory 'sql/test`: 1 1 Statistics about stderr of test 'seq-default` in directory 'sql/test`: 1
2 1 lines, 8 words, 60 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 13 lines, 78 words, 489 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 60 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 13 lines, 78 words, 489 chars in lines not matching '^$|^(\| |)#` 3
4 # 17 lines, 78 words, 821 chars in all lines 4 ! 4 # 35 lines, 171 words, 1224 chars in all lines 4
5 5 5 5
..................
# 17 lines, 78 words,
8 8 8 8
9 # 21:56:48 > 9 ! 9 # 00:35:05 > 9
10 # 21:56:48 > Mtimeout -timeout 180 Mserver "--config=/ufs/niels/scratch/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/niels/scratch/Linux-x86_64/lib/MonetDB:/ufs/niels/scratch/Linux-x86_64/lib/bin" --set "gdk_dbfarm=/ufs/niels/scratch/Linux-x86_64/var/MonetDB/dbfarm" --set "sql_logdir=/ufs/niels/scratch/Linux-x86_64/var/MonetDB/log" --set mapi_port=38633 --set sql_port=47630 --set xquery_port=54883 --set monet_prompt= --trace "--dbname=mTests_src_test" --dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over.. 10 ! 10 # 00:35:05 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36262" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\9f8602e8c51d-4-1-2\tests\sql\dbfarm\mTests_sql_test" "--set" "embedded_c=true" 10
11 # 21:56:48 > 11 ! 11 # 00:35:05 > 11
12 12 ! 12 12
13 13 ! 13 13
14 # 21:56:48 > 14 ! 14 # 00:35:05 > 14
15 # 21:56:48 > Mtimeout -timeout 60 MapiClient -lsql -u monetdb -P monetdb --host=localhost --port=47630 < seq-default.sql 15 ! 15 # 00:35:05 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=36262" 15
16 # 21:56:48 > 16 ! 16 # 00:35:05 > 16
17 17 ! 17 17
18 18 ! 18 #~ MAPI = monetdb@LAB03:36262 18
19 # 21:56:48 > 19 ! 19 QUERY = insert into kvk_cp(kvk, bedrijfsnaam) values (5, 'vijfs'); 19
20 # 21:56:48 > Done. 20 ! 20 ERROR = !NEXT VALUE FOR: no such sequence 'sys'.'seq_AUTO' 20
21 # 21:56:48 > 21 ! 21 # the original non-normalized output was: ERROR = !NEXT VALUE FOR: no such sequence 'sys'.'seq_5700' 21
+ 22 CODE = 42000 22
+ 23 #~ MAPI = monetdb@LAB03:36262 23
+ 24 QUERY = select * from kvk_cp; 24
+ 25 ERROR = !Current transaction is aborted (please ROLLBACK) 25
+ 26 CODE = 25005 26
+ 27 #~ MAPI = monetdb@LAB03:36262 27
+ 28 QUERY = drop TABLE kvk_cp; 28
+ 29 ERROR = !Current transaction is aborted (please ROLLBACK) 29
+ 30 CODE = 25005 30
+ 31 #~ MAPI = monetdb@LAB03:36262 31
+ 32 QUERY = drop SEQUENCE seq_AUTO; 32
+ 33 # the original non-normalized output was: QUERY = drop SEQUENCE seq_5700; 33
+ 34 ERROR = !Current transaction is aborted (please ROLLBACK) 34
+ 35 CODE = 25005 35
+ 36 36
+ 37 # 00:35:05 > 37
+ 38 # 00:35:05 > "Done." 38
+ 39 # 00:35:05 > 39
22 22 40 40