Test 89.sql (id 3c6cbe78e1fe) (err)
89.stable.out.int128.FILTERED 2019-09-08 14:07:22.918329205 +020089.test.out.FILTERED 2019-09-08 14:07:22.920329222 +0200
1 Statistics about stdout of test '89` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '89` in directory 'sql/benchmarks/tpcds`: 1
2 105 lines, 1152 words, 8605 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 1152 words, 8605 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 145 lines, 1358 words, 10369 chars in all lines 4 ! 4 # 29 lines, 142 words, 1249 chars in all lines 4
5 5 5 5
..................
# MonetDB/SQL module loaded
25 25 25 25
+ 26 # 14:07:22 > 26
+ 27 # 14:07:22 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-5151" "--port=30816" 27
+ 28 # 14:07:22 > 28
26 26 29 29
27 # 18:29:58 > 27 ! 30 30
28 # 18:29:58 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" 28 ! 31 # 14:07:22 > 31
29 # 18:29:58 > 29 ! 32 # 14:07:22 > "Done." 32
30 30 ! 33 # 14:07:22 > 33
31 #SELECT * from 31 -
32 # (SELECT i_category, i_class, i_brand, s_store_name, s_company_name, d_moy, sum(ss_sales_price) sum_sales, avg(sum(ss_sales_price)) OVER (PARTITION BY i_category, i_brand, s_store_name, s_company_name) avg_monthly_sales 32 -
33 # FROM item, store_sales, date_dim, store 33 -
34 # WHERE ss_item_sk = i_item_sk 34 -
35 # AND ss_sold_date_sk = d_date_sk 35 -
36 # AND ss_store_sk = s_store_sk 36 -
37 # AND d_year = 1999 37 -
38 # AND ((i_category IN ('Books','Electronics','Sports') 38 -
39 # AND i_class IN ('computers','stereo','football') ) 39 -
40 # OR (i_category IN ('Men','Jewelry','Women') 40 -
41 # AND i_class IN ('shirts','birdal','dresses'))) 41 -
42 % sys.tmp1, sys.tmp1, sys.tmp1, sys.tmp1, sys.tmp1, sys.tmp1, sys.tmp1, sys.tmp1 # table_name 42 -
43 % i_category, i_class, i_brand, s_store_name, s_company_name, d_moy, sum_sales, avg_monthly_sales # name 43 -
44 % char, char, char, varchar, varchar, int, decimal, double # type 44 -
45 % 50, 50, 50, 5, 7, 1, 40, 24 # length 45 -
46 [ "Men", "shirts", "importoimporto #1", "ese", "Unknown", 3, 2070.65, 5492.8175 ] 46 -
47 [ "Men", "shirts", "importoimporto #1", "ought", "Unknown", 6, 2152.15, 5045.758333 ] 47 -
48 [ "Men", "shirts", "importoimporto #1", "able", "Unknown", 2, 2333.43, 5194.818333 ] 48 -
49 [ "Men", "shirts", "importoimporto #1", "ese", "Unknown", 6, 2691.33, 5492.8175 ] 49 -
50 [ "Men", "shirts", "importoimporto #1", "ought", "Unknown", 2, 2253.70, 5045.758333 ] 50 -
51 [ "Women", "dresses", "amalgamalg #1", "able", "Unknown", 6, 1761.81, 4507.24 ] 51 -
52 [ "Men", "shirts", "importoimporto #1", "ation", "Unknown", 3, 2672.68, 5410.916667 ] 52 -
53 [ "Men", "shirts", "importoimporto #1", "ation", "Unknown", 5, 2677.81, 5410.916667 ] 53 -
54 [ "Men", "shirts", "importoimporto #1", "eing", "Unknown", 5, 2356.88, 5074.076667 ] 54 -
55 [ "Men", "shirts", "importoimporto #1", "ese", "Unknown", 4, 2784.11, 5492.8175 ] 55 -
56 [ "Women", "dresses", "amalgamalg #1", "ought", "Unknown", 7, 1926.67, 4619.7075 ] 56 -
57 [ "Women", "dresses", "amalgamalg #1", "ought", "Unknown", 1, 2065.94, 4619.7075 ] 57 -
58 [ "Men", "shirts", "importoimporto #1", "ation", "Unknown", 6, 2881.34, 5410.916667 ] 58 -
59 [ "Men", "shirts", "importoimporto #1", "able", "Unknown", 3, 2674.91, 5194.818333 ] 59 -
60 [ "Women", "dresses", "amalgamalg #1", "ation", "Unknown", 2, 2192.31, 4690.89 ] 60 -
61 [ "Men", "shirts", "importoimporto #1", "bar", "Unknown", 5, 2475.90, 4973.509167 ] 61 -
62 [ "Women", "dresses", "amalgamalg #1", "ese", "Unknown", 2, 2146.52, 4642.990833 ] 62 -
63 [ "Men", "shirts", "importoimporto #1", "eing", "Unknown", 2, 2588.02, 5074.076667 ] 63 -
64 [ "Women", "dresses", "amalgamalg #1", "bar", "Unknown", 7, 2428.75, 4914.118333 ] 64 -
65 [ "Women", "dresses", "amalgamalg #1", "bar", "Unknown", 3, 2451.51, 4914.118333 ] 65 -
66 [ "Men", "shirts", "importoimporto #1", "ation", "Unknown", 7, 2951.67, 5410.916667 ] 66 -
67 [ "Men", "shirts", "importoimporto #1", "able", "Unknown", 1, 2765.75, 5194.818333 ] 67 -
68 [ "Women", "dresses", "amalgamalg #1", "able", "Unknown", 2, 2082.54, 4507.24 ] 68 -
69 [ "Men", "shirts", "importoimporto #1", "ation", "Unknown", 4, 2988.08, 5410.916667 ] 69 -
70 [ "Men", "shirts", "importoimporto #1", "ought", "Unknown", 7, 2667.92, 5045.758333 ] 70 -
71 [ "Women", "dresses", "amalgamalg #1", "bar", "Unknown", 4, 2549.27, 4914.118333 ] 71 -
72 [ "Women", "dresses", "amalgamalg #1", "ese", "Unknown", 7, 2307.00, 4642.990833 ] 72 -
73 [ "Women", "dresses", "amalgamalg #1", "eing", "Unknown", 4, 2204.15, 4528.8225 ] 73 -
74 [ "Men", "shirts", "importoimporto #1", "able", "Unknown", 7, 2880.34, 5194.818333 ] 74 -
75 [ "Men", "shirts", "importoimporto #1", "ese", "Unknown", 5, 3210.74, 5492.8175 ] 75 -
76 [ "Women", "dresses", "amalgamalg #1", "ation", "Unknown", 4, 2418.39, 4690.89 ] 76 -
77 [ "Men", "shirts", "importoimporto #1", "eing", "Unknown", 4, 2833.40, 5074.076667 ] 77 -
78 [ "Women", "dresses", "amalgamalg #1", "bar", "Unknown", 2, 2692.79, 4914.118333 ] 78 -
79 [ "Men", "shirts", "importoimporto #1", "eing", "Unknown", 6, 2854.62, 5074.076667 ] 79 -
80 [ "Women", "dresses", "amalgamalg #1", "eing", "Unknown", 6, 2314.71, 4528.8225 ] 80 -
81 [ "Men", "shirts", "importoimporto #1", "ought", "Unknown", 5, 2834.94, 5045.758333 ] 81 -
82 [ "Women", "dresses", "amalgamalg #1", "ation", "Unknown", 5, 2480.25, 4690.89 ] 82 -
83 [ "Women", "dresses", "amalgamalg #1", "able", "Unknown", 7, 2302.21, 4507.24 ] 83 -
84 [ "Women", "dresses", "amalgamalg #1", "ation", "Unknown", 6, 2501.15, 4690.89 ] 84 -
85 [ "Men", "shirts", "importoimporto #1", "ese", "Unknown", 2, 3307.78, 5492.8175 ] 85 -
86 [ "Men", "shirts", "importoimporto #1", "able", "Unknown", 5, 3016.43, 5194.818333 ] 86 -
87 [ "Men", "shirts", "importoimporto #1", "able", "Unknown", 4, 3040.23, 5194.818333 ] 87 -
88 [ "Women", "dresses", "amalgamalg #1", "eing", "Unknown", 5, 2420.31, 4528.8225 ] 88 -
89 [ "Women", "dresses", "amalgamalg #1", "ese", "Unknown", 5, 2535.80, 4642.990833 ] 89 -
90 [ "Women", "dresses", "amalgamalg #1", "ought", "Unknown", 2, 2521.70, 4619.7075 ] 90 -
91 [ "Men", "shirts", "importoimporto #1", "bar", "Unknown", 3, 2877.96, 4973.509167 ] 91 -
92 [ "Women", "dresses", "amalgamalg #1", "ese", "Unknown", 3, 2577.15, 4642.990833 ] 92 -
93 [ "Women", "dresses", "amalgamalg #1", "ation", "Unknown", 7, 2637.27, 4690.89 ] 93 -
94 [ "Men", "shirts", "importoimporto #1", "ation", "Unknown", 1, 3380.16, 5410.916667 ] 94 -
95 [ "Women", "dresses", "amalgamalg #1", "eing", "Unknown", 7, 2524.32, 4528.8225 ] 95 -
96 [ "Men", "shirts", "importoimporto #1", "bar", "Unknown", 4, 2986.70, 4973.509167 ] 96 -
97 [ "Women", "dresses", "amalgamalg #1", "ought", "Unknown", 4, 2648.80, 4619.7075 ] 97 -
98 [ "Men", "shirts", "importoimporto #1", "bar", "Unknown", 7, 3026.41, 4973.509167 ] 98 -
99 [ "Women", "dresses", "amalgamalg #1", "ation", "Unknown", 3, 2751.11, 4690.89 ] 99 -
100 [ "Men", "shirts", "importoimporto #1", "bar", "Unknown", 2, 3073.45, 4973.509167 ] 100 -
101 [ "Men", "shirts", "importoimporto #1", "eing", "Unknown", 3, 3179.96, 5074.076667 ] 101 -
102 [ "Women", "dresses", "amalgamalg #1", "ation", "Unknown", 1, 2797.07, 4690.89 ] 102 -
103 [ "Women", "dresses", "amalgamalg #1", "able", "Unknown", 1, 2621.05, 4507.24 ] 103 -
104 [ "Women", "dresses", "amalgamalg #1", "ese", "Unknown", 4, 2808.36, 4642.990833 ] 104 -
105 [ "Women", "dresses", "amalgamalg #2", "bar", "Unknown", 6, 680.47, 2506.963333 ] 105 -
106 [ "Men", "shirts", "importoimporto #1", "ation", "Unknown", 2, 3591.65, 5410.916667 ] 106 -
107 [ "Women", "dresses", "amalgamalg #1", "able", "Unknown", 3, 2706.15, 4507.24 ] 107 -
108 [ "Women", "dresses", "amalgamalg #2", "eing", "Unknown", 2, 773.08, 2569.346667 ] 108 -
109 [ "Men", "shirts", "importoimporto #1", "bar", "Unknown", 6, 3199.08, 4973.509167 ] 109 -
110 [ "Men", "shirts", "importoimporto #1", "ese", "Unknown", 7, 3754.33, 5492.8175 ] 110 -
111 [ "Women", "dresses", "amalgamalg #1", "bar", "Unknown", 5, 3190.77, 4914.118333 ] 111 -
112 [ "Women", "dresses", "amalgamalg #1", "eing", "Unknown", 2, 2841.88, 4528.8225 ] 112 -
113 [ "Men", "shirts", "importoimporto #1", "able", "Unknown", 6, 3538.25, 5194.818333 ] 113 -
114 [ "Women", "dresses", "amalgamalg #1", "ese", "Unknown", 6, 3006.94, 4642.990833 ] 114 -
115 [ "Women", "dresses", "amalgamalg #1", "bar", "Unknown", 1, 3284.93, 4914.118333 ] 115 -
116 [ "Women", "dresses", "amalgamalg #2", "bar", "Unknown", 5, 878.42, 2506.963333 ] 116 -
117 [ "Women", "dresses", "amalgamalg #1", "able", "Unknown", 5, 2891.95, 4507.24 ] 117 -
118 [ "Men", "shirts", "importoimporto #1", "eing", "Unknown", 7, 3465.77, 5074.076667 ] 118 -
119 [ "Women", "dresses", "amalgamalg #2", "eing", "Unknown", 3, 964.29, 2569.346667 ] 119 -
120 [ "Women", "dresses", "amalgamalg #1", "bar", "Unknown", 6, 3324.49, 4914.118333 ] 120 -
121 [ "Men", "shirts", "importoimporto #1", "ought", "Unknown", 3, 3467.09, 5045.758333 ] 121 -
122 [ "Women", "dresses", "amalgamalg #1", "ought", "Unknown", 5, 3049.25, 4619.7075 ] 122 -
123 [ "Women", "dresses", "amalgamalg #1", "eing", "Unknown", 3, 2978.07, 4528.8225 ] 123 -
124 [ "Men", "shirts", "importoimporto #1", "ought", "Unknown", 4, 3544.97, 5045.758333 ] 124 -
125 [ "Men", "shirts", "importoimporto #1", "bar", "Unknown", 1, 3490.62, 4973.509167 ] 125 -
126 [ "Men", "shirts", "importoimporto #2", "able", "Unknown", 2, 628.63, 2095.470833 ] 126 -
127 [ "Men", "shirts", "importoimporto #1", "eing", "Unknown", 1, 3628.21, 5074.076667 ] 127 -
128 [ "Women", "dresses", "amalgamalg #1", "able", "Unknown", 4, 3082.17, 4507.24 ] 128 -
129 [ "Men", "shirts", "importoimporto #2", "eing", "Unknown", 5, 765.86, 2137.656667 ] 129 -
130 [ "Women", "dresses", "amalgamalg #2", "ation", "Unknown", 4, 1064.70, 2431.226667 ] 130 -
131 [ "Women", "dresses", "amalgamalg #2", "ought", "Unknown", 3, 991.89, 2355.441667 ] 131 -
132 [ "Women", "dresses", "amalgamalg #2", "eing", "Unknown", 5, 1211.13, 2569.346667 ] 132 -
133 [ "Women", "dresses", "amalgamalg #2", "ation", "Unknown", 7, 1078.41, 2431.226667 ] 133 -
134 [ "Men", "shirts", "importoimporto #2", "ation", "Unknown", 4, 807.67, 2141.06 ] 134 -
135 [ "Women", "dresses", "amalgamalg #2", "ation", "Unknown", 2, 1102.89, 2431.226667 ] 135 -
136 [ "Women", "dresses", "amalgamalg #2", "eing", "Unknown", 6, 1247.86, 2569.346667 ] 136 -
137 [ "Women", "dresses", "amalgamalg #2", "able", "Unknown", 4, 1020.39, 2337.278333 ] 137 -
138 [ "Men", "shirts", "importoimporto #2", "able", "Unknown", 7, 780.91, 2095.470833 ] 138 -
139 [ "Women", "dresses", "amalgamalg #2", "ese", "Unknown", 2, 904.34, 2200.820833 ] 139 -
140 [ "Women", "dresses", "amalgamalg #2", "ought", "Unknown", 7, 1061.87, 2355.441667 ] 140 -
141 [ "Women", "dresses", "amalgamalg #2", "able", "Unknown", 3, 1054.94, 2337.278333 ] 141 -
142 [ "Men", "shirts", "importoimporto #2", "ought", "Unknown", 6, 633.96, 1908.056667 ] 142 -
143 [ "Men", "shirts", "importoimporto #2", "ese", "Unknown", 6, 853.37, 2113.573333 ] 143 -
144 [ "Women", "dresses", "amalgamalg #2", "able", "Unknown", 5, 1084.94, 2337.278333 ] 144 -
145 [ "Women", "dresses", "amalgamalg #2", "eing", "Unknown", 4, 1317.08, 2569.346667 ] 145 -
146 146 -
147 # 18:32:55 > 147 -
148 # 18:32:55 > "Done." 148 -
149 # 18:32:55 > 149 -
150 150 34 34