Test 14.sql (id cbeba89afadb) (err)
14.stable.out.FILTERED 2019-01-10 04:38:19.830602300 +010014.test.out.FILTERED 2019-01-10 04:38:19.830602300 +0100
1 Statistics about stdout of test '14` in directory 'sql/benchmarks/tpch`: 1 1 Statistics about stdout of test '14` in directory 'sql/benchmarks/tpch`: 1
2 7 lines, 28 words, 150 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 9 words, 68 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 7 lines, 28 words, 150 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 9 words, 68 chars in lines not matching '^$|^(\| |)#` 3
4 # 43 lines, 181 words, 1552 chars in all lines 4 ! 4 # 29 lines, 124 words, 997 chars in all lines 4
5 5 5 5
..................
# Visit http://monetdb.cwi.nl/ for furth
20 20 25 25
21 # 14:36:23 > 21 ! 26 # 04:38:19 > 26
22 # 14:36:23 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-4866" "--port=32517" 22 ! 27 # 04:38:19 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=34841" 27
23 # 14:36:23 > 23 ! 28 # 04:38:19 > 28
24 24 ! 29 29
25 #select 25 ! 30 30
26 # 100.00 * sum(case 26 ! 31 # 04:38:19 > 31
27 # when p_type like 'PROMO%' 27 ! 32 # 04:38:19 > "Done." 32
28 # then l_extendedprice * (1 - l_discount) 28 ! 33 # 04:38:19 > 33
29 # else 0 29 -
30 # end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue 30 -
31 #from 31 -
32 # lineitem, 32 -
33 # part 33 -
34 #where 34 -
35 # l_partkey = p_partkey 35 -
36 # and l_shipdate >= date '1995-09-01' 36 -
37 # and l_shipdate < date '1995-09-01' + interval '1' month; 37 -
38 % sys. # table_name 38 -
39 # sys.L5 # table_name 39 -
40 % promo_revenue # name 40 -
41 % decimal # type 41 -
42 % 20 # length 42 -
43 [ 15.48654 ] 43 -
44 44 -
45 # 09:17:18 > 45 -
46 # 09:17:18 > Done. 46 -
47 # 09:17:18 > 47 -
48 48 34 34