Test insert_into_done_by_procedure.SF-2607293.sql (id fe8055a86502) (err)
insert_into_done_by_procedure.SF-2607293.stable.out.FILTERED 2019-09-12 10:08:22.548891580 +0200insert_into_done_by_procedure.SF-2607293.test.out.FILTERED 2019-09-12 10:08:22.553891623 +0200
1 Statistics about stdout of test 'insert_into_done_by_procedure.SF-2607293` in directory 'sql/test/BugTracker-2009`: 1 1 Statistics about stdout of test 'insert_into_done_by_procedure.SF-2607293` in directory 'sql/test/BugTracker-2009`: 1
2 7 lines, 38 words, 278 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 9 words, 111 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 7 lines, 38 words, 278 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 9 words, 111 chars in lines not matching '^$|^(\| |)#` 3
4 # 36 lines, 171 words, 1778 chars in all lines 4 ! 4 # 40 lines, 182 words, 1695 chars in all lines 4
5 5 5 5
..................
# 36 lines, 171 words,
8 8 8 8
9 # 00:34:20 > 9 ! 9 # 10:08:11 > 9
10 # 00:34:20 > mserver5 "--config=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=0 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=37101 --set xrpc_port=43632 --set xrpc_docroot=/ufs/goncalve/MonetDB/stable/sql --set monet_prompt= --trace "--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. 10 ! 10 # 10:08:11 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36385" "--set" "mapi_usock=/var/tmp/mtest-21996/.s.monetdb.36385" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/fe8055a86502-1-1-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2009" "--dbextra=/export/scratch1/home/monet/testing/fe8055a86502-1-1-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2009_transient" "--set" "embedded_c=true" 10
11 # 00:34:20 > 11 ! 11 # 10:08:11 > 11
12 12 ! 12 12
13 # MonetDB server v5.10.0, based on kernel v1.28.0 13 ! 13 # MonetDB 5 server v11.33.12 13
14 # Serving database 'mTests_src_test_BugTracker-2009', using 4 threads 14 ! 14 # This is an unreleased version 14
15 # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked 15 ! 15 # Serving database 'mTests_sql_test_BugTracker-2009', using 4 threads 15
16 # Copyright (c) 1993-July 2008 CWI. 16 ! 16 # Compiled for x86_64-redhat-linux-gnu/64bit with 128bit integers 16
17 # Copyright (c) August 2008- MonetDB B.V., all rights reserved 17 ! 17 # Found 7.778 GiB available main-memory. 17
18 # Visit http://monetdb.cwi.nl/ for further information 18 ! 18 # Copyright (c) 1993 - July 2008 CWI. 18
19 # Listening for connection requests on mapi:monetdb://alviss.ins.cwi.nl:37101/ 19 ! 19 # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved 19
20 # MonetDB/SQL module v2.28.0 loaded 20 ! 20 # Visit https://www.monetdb.org/ for further information 20
+ 21 # Listening for connection requests on mapi:monetdb://lab01.da.cwi.nl:36385/ 21
+ 22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-21996/.s.monetdb.36385 22
+ 23 # MonetDB/GIS module loaded 23
+ 24 # MonetDB/SQL module loaded 24
21 21 25 25
22 Ready. 22 26 Ready. 26
23 #function user.main():void; 23 ! 27 27
24 # clients.quit(); 24 ! 28 # 10:08:12 > 28
25 #end main; 25 ! 29 # 10:08:12 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-21996" "--port=36385" 29
26 26 ! 30 # 10:08:12 > 30
27 27 ! 31 31
28 # 00:34:20 > 28 ! 32 #create table get_results (schem string, clust string, real_time bigint); 32
29 # 00:34:20 > mclient -lsql -umonetdb -Pmonetdb --host=alviss --port=37101 29 ! 33 #create procedure save_times (schem string, clust string) 33
30 # 00:34:20 > 30 ! 34 #BEGIN 34
31 31 ! 35 #insert into get_results select 35
32 % sys.get_results, sys.get_results, sys.get_results # table_name 32 ! 36 #schem , 36
33 % schem, clust, real_time # name 33 ! 37 #clust , 37
34 % clob, clob, bigint # type 34 ! 38 #id as real_time 38
35 % 7, 3, 4 # length 35 ! 39 #from columns order by id limit 1; 39
36 [ "triples", "pso", 2002 ] 36 ! 40 #END; 40
37 37 ! 41 41
38 # 00:34:20 > 38 ! 42 # 10:08:22 > 42
39 # 00:34:20 > Done. 39 ! 43 # 10:08:22 > "Done." 43
40 # 00:34:20 > 40 ! 44 # 10:08:22 > 44
41 41 45 45