Test 01-22.SQL.bat (id 0e0dff03be95) (out)
01-22.stable.err.FILTERED 2019-01-08 20:52:32.753332800 +010001-22.test.err.FILTERED 2019-01-08 20:52:32.800132900 +0100
1 Statistics about stderr of test '01-22` in directory 'sql/benchmarks/tpch`: 1 1 Statistics about stderr of test '01-22` in directory 'sql/benchmarks/tpch`: 1
2 1 lines, 8 words, 65 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 16 lines, 67 words, 409 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 65 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 16 lines, 67 words, 409 chars in lines not matching '^$|^(\| |)#` 3
4 # 127 lines, 507 words, 3370 chars in all lines 4 ! 4 # 33 lines, 115 words, 835 chars in all lines 4
5 5 5 5
..................
# 127 lines, 507 words,
8 8 8 8
9 # 12:45:23 > 9 ! 9 # 20:52:30 > 9
10 # 12:45:23 > Mtimeout -timeout 1500 Mserver "--config=/var/tmp/_PREFIX_MONET_GNU_32_d__/etc/monet.conf" --debug=10 --set "monet_mod_path=/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB:/var/tmp/_PREFIX_MONET_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=41160 --set sql_port=55567 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" "/var/tmp/_BUILD_SQL_GNU_32_d__/src/backends/monet4/sql_server.mil" ; echo ; echo Over.. 10 ! 10 # 20:52:30 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39920" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\0e0dff03be95-4-1-2\tests\sql\dbfarm\mTests_sql_benchmarks_tpch" "--set" "embedded_c=true" 10
11 # 12:45:23 > 11 ! 11 # 20:52:30 > 11
12 12 ! 12 12
13 13 ! 13 13
14 # 12:45:24 > 14 ! 14 # 20:52:31 > 14
15 # 12:45:24 > Mtimeout -timeout 1380 ./01-22.SQL 01-22 15 ! 15 # 20:52:31 > ".\01-22.SQL.bat" "01-22" 15
16 # 12:45:24 > 16 ! 16 # 20:52:31 > 16
17 17 ! 17 17
18 18 ! 18 #~ MAPI = monetdb@LAB03:39920 18
19 # 12:45:24 > 19 ! 19 QUERY = select 19
20 # 12:45:24 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 20 ! 20 100.00 * sum(case 20
21 # 12:45:24 > 21 ! 21 when p_type like 'PROMO%' 21
22 22 ! 22 then l_extendedprice * (1 - l_discount) 22
23 23 ! 23 else 0 23
24 # 12:45:24 > 24 ! 24 end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue 24
25 # 12:45:24 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 25 ! 25 from 25
26 # 12:45:24 > 26 ! 26 lineitem, 26
27 27 ! 27 part 27
28 28 ! 28 where 28
29 # 12:45:25 > 29 ! 29 l_partkey = p_partkey 29
30 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 30 ! 30 and l_shipdate >= date '1995-09-01' 30
31 # 12:45:25 > 31 ! 31 and l_shipdate < date '1995-09-01' + interval '1' month; 31
32 32 ! 32 ERROR = !Too many digits (19 > 18) 32
33 33 ! 33 CODE = 22003 33
34 # 12:45:25 > 34 ! 34 34
35 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 35 ! 35 # 20:52:32 > 35
36 # 12:45:25 > 36 ! 36 # 20:52:32 > "Done." 36
37 37 ! 37 # 20:52:32 > 37
38 38 -
39 # 12:45:25 > 39 -
40 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 40 -
41 # 12:45:25 > 41 -
42 42 -
43 43 -
44 # 12:45:25 > 44 -
45 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 45 -
46 # 12:45:25 > 46 -
47 47 -
48 48 -
49 # 12:45:25 > 49 -
50 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 50 -
51 # 12:45:25 > 51 -
52 52 -
53 53 -
54 # 12:45:25 > 54 -
55 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 55 -
56 # 12:45:25 > 56 -
57 57 -
58 58 -
59 # 12:45:25 > 59 -
60 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 60 -
61 # 12:45:25 > 61 -
62 62 -
63 63 -
64 # 12:45:25 > 64 -
65 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 65 -
66 # 12:45:25 > 66 -
67 67 -
68 68 -
69 # 12:45:25 > 69 -
70 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 70 -
71 # 12:45:25 > 71 -
72 72 -
73 73 -
74 # 12:45:25 > 74 -
75 # 12:45:25 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 75 -
76 # 12:45:25 > 76 -
77 77 -
78 78 -
79 # 12:45:26 > 79 -
80 # 12:45:26 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 80 -
81 # 12:45:26 > 81 -
82 82 -
83 83 -
84 # 12:45:26 > 84 -
85 # 12:45:26 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 85 -
86 # 12:45:26 > 86 -
87 87 -
88 88 -
89 # 12:45:26 > 89 -
90 # 12:45:26 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 90 -
91 # 12:45:26 > 91 -
92 92 -
93 93 -
94 # 12:45:26 > 94 -
95 # 12:45:26 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 95 -
96 # 12:45:26 > 96 -
97 97 -
98 98 -
99 # 12:45:26 > 99 -
100 # 12:45:26 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 100 -
101 # 12:45:26 > 101 -
102 102 -
103 103 -
104 # 12:45:26 > 104 -
105 # 12:45:26 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 105 -
106 # 12:45:26 > 106 -
107 107 -
108 108 -
109 # 12:45:26 > 109 -
110 # 12:45:26 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 110 -
111 # 12:45:26 > 111 -
112 112 -
113 113 -
114 # 12:45:27 > 114 -
115 # 12:45:27 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 115 -
116 # 12:45:27 > 116 -
117 117 -
118 118 -
119 # 12:45:27 > 119 -
120 # 12:45:27 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 120 -
121 # 12:45:27 > 121 -
122 122 -
123 123 -
124 # 12:45:27 > 124 -
125 # 12:45:27 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=55567 --trace 125 -
126 # 12:45:27 > 126 -
127 127 -
128 128 -
129 # 12:45:27 > 129 -
130 # 12:45:27 > Done. 130 -
131 # 12:45:27 > 131 -
132 132 38 38