Test 14.sql (id cbeba89afadb) (out)
14.stable.err.FILTERED 2019-01-10 01:19:48.772157832 +010014.test.err.FILTERED 2019-01-10 01:19:48.773157822 +0100
1 Statistics about stderr of test '14` in directory 'sql/benchmarks/tpch`: 1 1 Statistics about stderr of test '14` in directory 'sql/benchmarks/tpch`: 1
2 1 lines, 8 words, 62 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 16 lines, 67 words, 406 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 62 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 16 lines, 67 words, 406 chars in lines not matching '^$|^(\| |)#` 3
4 # 17 lines, 75 words, 812 chars in all lines 4 ! 4 # 33 lines, 127 words, 1050 chars in all lines 4
5 5 5 5
..................
# 17 lines, 75 words,
8 8 8 8
9 # 19:10:03 > 9 ! 9 # 01:19:48 > 9
10 # 19:10:03 > 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 # 01:19:48 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33572" "--set" "mapi_usock=/var/tmp/mtest-17101/.s.monetdb.33572" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/cbeba89afadb-6-1-3/tests/sql/dbfarm/mTests_sql_benchmarks_tpch" "--set" "embedded_c=true" 10
11 # 19:10:03 > 11 ! 11 # 01:19:48 > 11
12 12 ! 12 12
13 13 ! 13 13
14 # 19:10:04 > 14 ! 14 # 01:19:48 > 14
15 # 19:10:04 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=51688 --trace < 14.sql 15 ! 15 # 01:19:48 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-17101" "--port=33572" 15
16 # 19:10:04 > 16 ! 16 # 01:19:48 > 16
17 17 ! 17 17
18 18 ! 18 #~ MAPI = (monetdb) /var/tmp/mtest-17101/.s.monetdb.33572 18
19 # 19:10:04 > 19 ! 19 QUERY = select 19
20 # 19:10:04 > Done. 20 ! 20 100.00 * sum(case 20
21 # 19:10:04 > 21 ! 21 when p_type like 'PROMO%' 21
+ 22 then l_extendedprice * (1 - l_discount) 22
+ 23 else 0 23
+ 24 end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue 24
+ 25 from 25
+ 26 lineitem, 26
+ 27 part 27
+ 28 where 28
+ 29 l_partkey = p_partkey 29
+ 30 and l_shipdate >= date '1995-09-01' 30
+ 31 and l_shipdate < date '1995-09-01' + interval '1' month; 31
+ 32 ERROR = !Too many digits (19 > 18) 32
+ 33 CODE = 22003 33
+ 34 34
+ 35 # 01:19:48 > 35
+ 36 # 01:19:48 > "Done." 36
+ 37 # 01:19:48 > 37
22 22 38 38