Test 17.sql (id f56b8f83e70a) (out)
17.stable.err.FILTERED 2019-09-11 19:29:48.906517300 +020017.test.err.FILTERED 2019-09-11 19:29:48.906517300 +0200
1 Statistics about stderr of test '17` in directory 'sql/benchmarks/tpch`: 1 1 Statistics about stderr of test '17` in directory 'sql/benchmarks/tpch`: 1
2 1 lines, 8 words, 62 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 20 lines, 56 words, 359 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 62 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 20 lines, 56 words, 359 chars in lines not matching '^$|^(\| |)#` 3
4 # 17 lines, 75 words, 812 chars in all lines 4 ! 4 # 37 lines, 109 words, 830 chars in all lines 4
5 5 5 5
..................
# 17 lines, 75 words,
8 8 8 8
9 # 19:10:06 > 9 ! 9 # 19:29:48 > 9
10 # 19:10:06 > Mtimeout -timeout 180 Mserver "--config=/var/tmp/_PREFIX_MONET_GNU_32_d__/etc/monet.conf" --debug=10 --set "monet_mod_path=/var/tmp/_PREFIX_MONET_GNU_32_d__/lib/MonetDB:/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB" --set "gdk_dbfarm=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/dbfarm" --set "sql_logdir=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/log" --set mapi_port=56086 --set sql_port=51688 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" "/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB/sqlserver.mil" ; echo ; echo Over.. 10 ! 10 # 19:29:48 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34813" "--forcemito" "--dbpath=C:\monettesting\f56b8f83e70a-8-1-2\tests\sql\dbfarm\mTests_sql_benchmarks_tpch" "--set" "embedded_c=true" 10
11 # 19:10:06 > 11 ! 11 # 19:29:48 > 11
12 12 ! 12 12
13 13 ! 13 13
14 # 19:10:07 > 14 ! 14 # 19:29:48 > 14
15 # 19:10:07 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=51688 --trace < 17.sql 15 ! 15 # 19:29:48 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2K12R2" "--port=34813" 15
16 # 19:10:07 > 16 ! 16 # 19:29:48 > 16
17 17 ! 17 17
18 18 ! 18 #~ MAPI = monetdb@WIN2K12R2:34813 18
19 # 19:10:07 > 19 ! 19 ACTION= read_line 19
20 # 19:10:07 > Done. 20 ! 20 QUERY = select 20
21 # 19:10:07 > 21 ! 21 sum(l_extendedprice) / 7.0 as avg_yearly 21
+ 22 from 22
+ 23 lineitem, 23
+ 24 part 24
+ 25 where 25
+ 26 p_partkey = l_partkey 26
+ 27 and p_brand = 'Brand#23' 27
+ 28 and p_container = 'MED BOX' 28
+ 29 and l_quantity < ( 29
+ 30 select 30
+ 31 0.2 * avg(l_quantity) 31
+ 32 from 32
+ 33 lineitem 33
+ 34 where 34
+ 35 l_partkey = p_partkey 35
+ 36 ); 36
+ 37 ERROR = !Connection terminated during read line 37
+ 38 38
+ 39 # 19:29:48 > 39
+ 40 # 19:29:48 > "Done." 40
+ 41 # 19:29:48 > 41
22 22 42 42