Test 53.sql (id 3c6cbe78e1fe) (err)
53.stable.out.int128.FILTERED 2019-09-08 11:41:38.126044026 +020053.test.out.FILTERED 2019-09-08 11:41:38.128044043 +0200
1 Statistics about stdout of test '53` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '53` in directory 'sql/benchmarks/tpcds`: 1
2 105 lines, 532 words, 2616 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 532 words, 2616 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 145 lines, 709 words, 4081 chars in all lines 4 ! 4 # 29 lines, 142 words, 1243 chars in all lines 4
5 5 5 5
..................
# MonetDB/SQL module loaded
25 25 25 25
+ 26 # 11:41:27 > 26
+ 27 # 11:41:27 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-5732" "--port=36551" 27
+ 28 # 11:41:27 > 28
+ 29 29
+ 30 30
+ 31 # 11:41:38 > 31
+ 32 # 11:41:38 > "Done." 32
+ 33 # 11:41:38 > 33
26 26 34 34
27 # 18:29:57 > 27 -
28 # 18:29:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" 28 -
29 # 18:29:57 > 29 -
30 30 -
31 #SELECT * 31 -
32 #FROM 32 -
33 # (SELECT i_manufact_id, 33 -
34 # sum(ss_sales_price) sum_sales, 34 -
35 # avg(sum(ss_sales_price)) OVER (PARTITION BY i_manufact_id) avg_quarterly_sales 35 -
36 # FROM item, 36 -
37 # store_sales, 37 -
38 # date_dim, 38 -
39 # store 39 -
40 # WHERE ss_item_sk = i_item_sk 40 -
41 # AND ss_sold_date_sk = d_date_sk 41 -
42 # AND ss_store_sk = s_store_sk 42 -
43 % sys.tmp1, sys.tmp1, sys.tmp1 # table_name 43 -
44 % i_manufact_id, sum_sales, avg_quarterly_sales # name 44 -
45 % int, decimal, double # type 45 -
46 % 3, 40, 24 # length 46 -
47 [ 30, 165.67, 340.635 ] 47 -
48 [ 30, 247.07, 340.635 ] 48 -
49 [ 30, 627.63, 340.635 ] 49 -
50 [ 619, 158.76, 348.64 ] 50 -
51 [ 619, 210.81, 348.64 ] 51 -
52 [ 619, 464.26, 348.64 ] 52 -
53 [ 619, 560.73, 348.64 ] 53 -
54 [ 271, 79.26, 354.33 ] 54 -
55 [ 271, 86.87, 354.33 ] 55 -
56 [ 271, 179.61, 354.33 ] 56 -
57 [ 271, 1071.58, 354.33 ] 57 -
58 [ 827, 82.44, 356.59 ] 58 -
59 [ 827, 320.05, 356.59 ] 59 -
60 [ 827, 666.52, 356.59 ] 60 -
61 [ 296, 188.61, 369.125 ] 61 -
62 [ 296, 265.76, 369.125 ] 62 -
63 [ 296, 655.24, 369.125 ] 63 -
64 [ 308, 200.28, 385.9825 ] 64 -
65 [ 308, 214.07, 385.9825 ] 65 -
66 [ 308, 489.17, 385.9825 ] 66 -
67 [ 308, 640.41, 385.9825 ] 67 -
68 [ 486, 178.80, 400.53 ] 68 -
69 [ 486, 455.08, 400.53 ] 69 -
70 [ 486, 468.01, 400.53 ] 70 -
71 [ 486, 500.23, 400.53 ] 71 -
72 [ 554, 191.48, 407.975 ] 72 -
73 [ 554, 346.80, 407.975 ] 73 -
74 [ 554, 660.97, 407.975 ] 74 -
75 [ 208, 151.84, 410.385 ] 75 -
76 [ 208, 207.02, 410.385 ] 76 -
77 [ 208, 533.75, 410.385 ] 77 -
78 [ 208, 748.93, 410.385 ] 78 -
79 [ 662, 199.83, 412.135 ] 79 -
80 [ 662, 300.61, 412.135 ] 80 -
81 [ 662, 460.94, 412.135 ] 81 -
82 [ 662, 687.16, 412.135 ] 82 -
83 [ 394, 264.65, 413.405 ] 83 -
84 [ 394, 272.02, 413.405 ] 84 -
85 [ 394, 674.12, 413.405 ] 85 -
86 [ 221, 183.63, 416.0825 ] 86 -
87 [ 221, 534.62, 416.0825 ] 87 -
88 [ 221, 552.44, 416.0825 ] 88 -
89 [ 621, 232.20, 418.115 ] 89 -
90 [ 621, 624.80, 418.115 ] 90 -
91 [ 507, 76.98, 419.465 ] 91 -
92 [ 507, 505.36, 419.465 ] 92 -
93 [ 507, 644.24, 419.465 ] 93 -
94 [ 316, 36.25, 423.035 ] 94 -
95 [ 316, 158.85, 423.035 ] 95 -
96 [ 316, 697.32, 423.035 ] 96 -
97 [ 316, 799.72, 423.035 ] 97 -
98 [ 56, 110.81, 423.0975 ] 98 -
99 [ 56, 371.77, 423.0975 ] 99 -
100 [ 56, 500.77, 423.0975 ] 100 -
101 [ 56, 709.04, 423.0975 ] 101 -
102 [ 517, 194.87, 426.2875 ] 102 -
103 [ 517, 313.41, 426.2875 ] 103 -
104 [ 517, 482.41, 426.2875 ] 104 -
105 [ 517, 714.46, 426.2875 ] 105 -
106 [ 411, 364.09, 426.8925 ] 106 -
107 [ 411, 519.60, 426.8925 ] 107 -
108 [ 247, 313.42, 427.6825 ] 108 -
109 [ 247, 353.08, 427.6825 ] 109 -
110 [ 247, 628.37, 427.6825 ] 110 -
111 [ 652, 228.75, 434.7525 ] 111 -
112 [ 652, 314.98, 434.7525 ] 112 -
113 [ 652, 365.90, 434.7525 ] 113 -
114 [ 652, 829.38, 434.7525 ] 114 -
115 [ 129, 301.69, 436.4525 ] 115 -
116 [ 129, 325.26, 436.4525 ] 116 -
117 [ 129, 550.47, 436.4525 ] 117 -
118 [ 129, 568.39, 436.4525 ] 118 -
119 [ 99, 164.24, 438.6675 ] 119 -
120 [ 99, 183.75, 438.6675 ] 120 -
121 [ 99, 393.58, 438.6675 ] 121 -
122 [ 99, 1013.10, 438.6675 ] 122 -
123 [ 235, 111.64, 441.03 ] 123 -
124 [ 235, 179.51, 441.03 ] 124 -
125 [ 235, 493.83, 441.03 ] 125 -
126 [ 235, 979.14, 441.03 ] 126 -
127 [ 360, 143.83, 445.415 ] 127 -
128 [ 360, 293.99, 445.415 ] 128 -
129 [ 360, 928.51, 445.415 ] 129 -
130 [ 732, 106.56, 447.065 ] 130 -
131 [ 732, 300.77, 447.065 ] 131 -
132 [ 732, 498.49, 447.065 ] 132 -
133 [ 732, 882.44, 447.065 ] 133 -
134 [ 190, 202.77, 451.9825 ] 134 -
135 [ 190, 233.10, 451.9825 ] 135 -
136 [ 190, 358.97, 451.9825 ] 136 -
137 [ 190, 1013.09, 451.9825 ] 137 -
138 [ 147, 212.53, 455.8925 ] 138 -
139 [ 147, 366.10, 455.8925 ] 139 -
140 [ 147, 553.92, 455.8925 ] 140 -
141 [ 147, 691.02, 455.8925 ] 141 -
142 [ 665, 283.25, 456.0875 ] 142 -
143 [ 665, 357.22, 456.0875 ] 143 -
144 [ 665, 691.20, 456.0875 ] 144 -
145 [ 85, 325.28, 456.28 ] 145 -
146 [ 85, 350.10, 456.28 ] 146 -
147 147 -
148 # 18:29:57 > 148 -
149 # 18:29:57 > "Done." 149 -
150 # 18:29:57 > 150 -