Test 51.sql (id 3c6cbe78e1fe) (err)
51.stable.out.int128.FILTERED 2019-09-08 11:29:37.000000000 +020051.test.out.FILTERED 2019-09-08 11:29:37.000000000 +0200
1 Statistics about stdout of test '51` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '51` in directory 'sql/benchmarks/tpcds`: 1
2 105 lines, 844 words, 4966 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 844 words, 4966 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 146 lines, 1035 words, 6493 chars in all lines 4 ! 4 # 29 lines, 142 words, 1246 chars in all lines 4
5 5 5 5
..................
# MonetDB/SQL module loaded
26 26 29 29
27 # 18:29:57 > 27 ! 30 30
28 # 18:29:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" 28 ! 31 # 11:29:37 > 31
29 # 18:29:57 > 29 ! 32 # 11:29:37 > "Done." 32
30 30 ! 33 # 11:29:37 > 33
31 #WITH web_v1 AS 31 -
32 # (SELECT ws_item_sk item_sk, 32 -
33 # d_date, 33 -
34 # sum(sum(ws_sales_price)) OVER (PARTITION BY ws_item_sk 34 -
35 # ORDER BY d_date ROWS BETWEEN unbounded preceding AND CURRENT ROW) cume_sales 35 -
36 # FROM web_sales, 36 -
37 # date_dim 37 -
38 # WHERE ws_sold_date_sk=d_date_sk 38 -
39 # AND d_month_seq BETWEEN 1200 AND 1200+11 39 -
40 # AND ws_item_sk IS NOT NULL 40 -
41 # GROUP BY ws_item_sk, 41 -
42 # d_date), 42 -
43 % .y, .y, .y, .y, .y, .y # table_name 43 -
44 % item_sk, d_date, web_sales, store_sales, web_cumulative, store_cumulative # name 44 -
45 % int, date, decimal, decimal, decimal, decimal # type 45 -
46 % 2, 10, 40, 40, 40, 40 # length 46 -
47 [ 14, 2000-01-10, 176.83, NULL, 176.83, 73.60 ] 47 -
48 [ 14, 2000-01-21, NULL, 75.29, 176.83, 75.29 ] 48 -
49 [ 14, 2000-01-29, 222.33, NULL, 222.33, 75.29 ] 49 -
50 [ 14, 2000-02-02, 224.01, NULL, 224.01, 75.29 ] 50 -
51 [ 14, 2000-02-08, NULL, 85.07, 224.01, 85.07 ] 51 -
52 [ 14, 2000-02-19, NULL, 98.60, 224.01, 98.60 ] 52 -
53 [ 14, 2000-02-21, 241.64, NULL, 241.64, 98.60 ] 53 -
54 [ 14, 2000-02-22, NULL, 99.83, 241.64, 99.83 ] 54 -
55 [ 14, 2000-03-18, NULL, 112.82, 241.64, 112.82 ] 55 -
56 [ 14, 2000-03-23, 251.15, NULL, 251.15, 112.82 ] 56 -
57 [ 14, 2000-03-28, 260.17, NULL, 260.17, 112.82 ] 57 -
58 [ 14, 2000-03-31, 370.74, NULL, 370.74, 112.82 ] 58 -
59 [ 14, 2000-04-05, NULL, 115.94, 370.74, 115.94 ] 59 -
60 [ 14, 2000-04-15, 445.30, NULL, 445.30, 115.94 ] 60 -
61 [ 14, 2000-04-27, NULL, 151.48, 445.30, 151.48 ] 61 -
62 [ 14, 2000-05-03, NULL, 176.89, 445.30, 176.89 ] 62 -
63 [ 14, 2000-05-10, 451.40, NULL, 451.40, 176.89 ] 63 -
64 [ 14, 2000-05-21, NULL, 238.39, 451.40, 238.39 ] 64 -
65 [ 14, 2000-05-26, 596.81, NULL, 596.81, 238.39 ] 65 -
66 [ 14, 2000-05-29, NULL, 242.51, 596.81, 242.51 ] 66 -
67 [ 14, 2000-06-05, NULL, 304.64, 596.81, 304.64 ] 67 -
68 [ 14, 2000-07-03, 623.77, NULL, 623.77, 304.64 ] 68 -
69 [ 14, 2000-07-07, NULL, 307.77, 623.77, 307.77 ] 69 -
70 [ 14, 2000-07-18, NULL, 320.04, 623.77, 320.04 ] 70 -
71 [ 14, 2000-07-25, 673.08, NULL, 673.08, 320.04 ] 71 -
72 [ 14, 2000-08-10, NULL, 411.48, 673.08, 411.48 ] 72 -
73 [ 14, 2000-08-14, NULL, 465.85, 673.08, 465.85 ] 73 -
74 [ 14, 2000-08-21, NULL, 541.45, 673.08, 541.45 ] 74 -
75 [ 14, 2000-08-26, NULL, 574.56, 673.08, 574.56 ] 75 -
76 [ 19, 2000-01-02, 56.96, 49.68, 56.96, 49.68 ] 76 -
77 [ 25, 2000-01-21, 97.29, NULL, 97.29, 4.49 ] 77 -
78 [ 25, 2000-01-28, 192.46, NULL, 192.46, 4.49 ] 78 -
79 [ 25, 2000-02-09, NULL, 24.23, 192.46, 24.23 ] 79 -
80 [ 25, 2000-02-11, NULL, 98.99, 192.46, 98.99 ] 80 -
81 [ 25, 2000-02-21, NULL, 170.60, 192.46, 170.60 ] 81 -
82 [ 25, 2000-02-22, NULL, 185.05, 192.46, 185.05 ] 82 -
83 [ 35, 2000-01-14, NULL, 55.24, 177.88, 55.24 ] 83 -
84 [ 35, 2000-01-16, NULL, 95.92, 177.88, 95.92 ] 84 -
85 [ 35, 2000-01-18, NULL, 126.45, 177.88, 126.45 ] 85 -
86 [ 35, 2000-01-19, NULL, 167.07, 177.88, 167.07 ] 86 -
87 [ 35, 2000-02-17, NULL, 173.97, 177.88, 173.97 ] 87 -
88 [ 35, 2000-02-22, 270.43, NULL, 270.43, 173.97 ] 88 -
89 [ 35, 2000-02-23, NULL, 180.61, 270.43, 180.61 ] 89 -
90 [ 35, 2000-03-03, NULL, 181.99, 270.43, 181.99 ] 90 -
91 [ 35, 2000-03-05, NULL, 221.24, 270.43, 221.24 ] 91 -
92 [ 35, 2000-03-06, NULL, 266.41, 270.43, 266.41 ] 92 -
93 [ 37, 2000-01-02, 31.75, 11.89, 31.75, 11.89 ] 93 -
94 [ 37, 2000-01-04, NULL, 17.15, 31.75, 17.15 ] 94 -
95 [ 37, 2000-01-05, 34.34, NULL, 34.34, 17.15 ] 95 -
96 [ 37, 2000-01-06, NULL, 29.67, 34.34, 29.67 ] 96 -
97 [ 41, 2000-01-21, NULL, 15.54, 123.34, 15.54 ] 97 -
98 [ 41, 2000-02-03, NULL, 21.04, 123.34, 21.04 ] 98 -
99 [ 41, 2000-02-16, NULL, 33.46, 123.34, 33.46 ] 99 -
100 [ 41, 2000-02-20, NULL, 37.46, 123.34, 37.46 ] 100 -
101 [ 41, 2000-02-22, NULL, 58.57, 123.34, 58.57 ] 101 -
102 [ 41, 2000-03-05, NULL, 70.06, 123.34, 70.06 ] 102 -
103 [ 41, 2000-03-17, 178.84, 150.76, 178.84, 150.76 ] 103 -
104 [ 41, 2000-04-26, 263.14, NULL, 263.14, 254.88 ] 104 -
105 [ 41, 2000-07-12, 474.83, NULL, 474.83, 393.87 ] 105 -
106 [ 41, 2000-07-18, NULL, 421.23, 474.83, 421.23 ] 106 -
107 [ 41, 2000-08-15, NULL, 430.77, 474.83, 430.77 ] 107 -
108 [ 49, 2000-01-18, NULL, 2.51, 4.58, 2.51 ] 108 -
109 [ 49, 2000-01-31, 72.47, NULL, 72.47, 13.05 ] 109 -
110 [ 49, 2000-02-13, NULL, 70.68, 72.47, 70.68 ] 110 -
111 [ 49, 2000-02-29, NULL, 71.86, 72.47, 71.86 ] 111 -
112 [ 49, 2000-04-17, 225.29, NULL, 225.29, 219.03 ] 112 -
113 [ 53, 2000-01-02, 12.85, 1.13, 12.85, 1.13 ] 113 -
114 [ 53, 2000-01-08, 119.24, NULL, 119.24, 1.13 ] 114 -
115 [ 53, 2000-01-09, 126.98, NULL, 126.98, 1.13 ] 115 -
116 [ 53, 2000-01-15, NULL, 3.20, 126.98, 3.20 ] 116 -
117 [ 53, 2000-02-04, NULL, 22.89, 126.98, 22.89 ] 117 -
118 [ 53, 2000-02-05, NULL, 64.45, 126.98, 64.45 ] 118 -
119 [ 53, 2000-02-12, NULL, 66.06, 126.98, 66.06 ] 119 -
120 [ 56, 2000-01-02, 41.57, 17.31, 41.57, 17.31 ] 120 -
121 [ 61, 2000-02-17, 421.60, NULL, 421.60, 344.03 ] 121 -
122 [ 61, 2000-03-01, NULL, 411.33, 421.60, 411.33 ] 122 -
123 [ 61, 2000-04-22, 600.20, NULL, 600.20, 573.28 ] 123 -
124 [ 71, 2000-01-02, 13.92, 2.88, 13.92, 2.88 ] 124 -
125 [ 85, 2000-02-03, NULL, 42.30, 65.50, 42.30 ] 125 -
126 [ 85, 2000-02-16, NULL, 42.95, 65.50, 42.95 ] 126 -
127 [ 85, 2000-04-19, 335.16, NULL, 335.16, 247.67 ] 127 -
128 [ 85, 2000-04-23, NULL, 252.83, 335.16, 252.83 ] 128 -
129 [ 85, 2000-05-02, NULL, 289.65, 335.16, 289.65 ] 129 -
130 [ 85, 2000-05-11, NULL, 312.62, 335.16, 312.62 ] 130 -
131 [ 86, 2000-01-19, 31.70, NULL, 31.70, 25.97 ] 131 -
132 [ 86, 2000-02-03, 151.26, NULL, 151.26, 91.16 ] 132 -
133 [ 86, 2000-02-04, NULL, 112.15, 151.26, 112.15 ] 133 -
134 [ 89, 2000-01-12, NULL, 28.84, 181.56, 28.84 ] 134 -
135 [ 89, 2000-01-23, NULL, 67.19, 181.56, 67.19 ] 135 -
136 [ 89, 2000-01-30, NULL, 104.65, 181.56, 104.65 ] 136 -
137 [ 89, 2000-02-22, NULL, 146.96, 181.56, 146.96 ] 137 -
138 [ 89, 2000-02-25, NULL, 147.02, 181.56, 147.02 ] 138 -
139 [ 89, 2000-03-19, NULL, 172.85, 181.56, 172.85 ] 139 -
140 [ 89, 2000-03-20, 191.66, NULL, 191.66, 172.85 ] 140 -
141 [ 89, 2000-04-11, 295.81, NULL, 295.81, 172.85 ] 141 -
142 [ 89, 2000-04-13, NULL, 203.86, 295.81, 203.86 ] 142 -
143 [ 89, 2000-04-20, 373.30, NULL, 373.30, 203.86 ] 143 -
144 [ 89, 2000-04-23, NULL, 219.74, 373.30, 219.74 ] 144 -
145 [ 89, 2000-04-26, NULL, 235.97, 373.30, 235.97 ] 145 -
146 [ 89, 2000-05-04, NULL, 248.05, 373.30, 248.05 ] 146 -
147 147 -
148 # 13:10:59 > 148 -
149 # 13:10:59 > "Done." 149 -
150 # 13:10:59 > 150 -
151 151 34 34