Test 47.sql (id 3c6cbe78e1fe) (err)
47.stable.out.int128.FILTERED 2019-09-08 11:41:11.502820256 +020047.test.out.FILTERED 2019-09-08 11:41:11.503820264 +0200
1 Statistics about stdout of test '47` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '47` in directory 'sql/benchmarks/tpcds`: 1
2 105 lines, 1414 words, 10340 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 1414 words, 10340 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 149 lines, 1592 words, 11784 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:01 > 26
+ 27 # 11:41:01 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-5732" "--port=36551" 27
+ 28 # 11:41:01 > 28
+ 29 29
+ 30 30
+ 31 # 11:41:11 > 31
+ 32 # 11:41:11 > "Done." 32
+ 33 # 11:41:11 > 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 #WITH v1 AS 31 -
32 # (SELECT i_category, 32 -
33 # i_brand, 33 -
34 # s_store_name, 34 -
35 # s_company_name, 35 -
36 # d_year, 36 -
37 # d_moy, 37 -
38 # sum(ss_sales_price) sum_sales, 38 -
39 # avg(sum(ss_sales_price)) OVER (PARTITION BY i_category, 39 -
40 # i_brand, 40 -
41 # s_store_name, 41 -
42 # s_company_name, 42 -
43 % sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, sys.v2, sys.v2 # table_name 43 -
44 % i_category, i_brand, s_store_name, s_company_name, d_year, d_moy, avg_monthly_sales, sum_sales, psum, nsum # name 44 -
45 % char, char, varchar, varchar, int, int, double, decimal, decimal, decimal # type 45 -
46 % 50, 50, 5, 7, 4, 1, 24, 40, 40, 40 # length 46 -
47 [ "Men", "importoimporto #1", "ese", "Unknown", 1999, 3, 5492.8175, 2070.65, 3307.78, 2784.11 ] 47 -
48 [ "Music", "exportischolar #1", "eing", "Unknown", 1999, 2, 5134.238333, 1740.21, 4401.89, 2721.61 ] 48 -
49 [ "Music", "edu packscholar #1", "ese", "Unknown", 1999, 4, 5463.700833, 2091.07, 3391.39, 3095.31 ] 49 -
50 [ "Music", "edu packscholar #1", "ought", "Unknown", 1999, 7, 5552.305, 2226.34, 4081.99, 7573.33 ] 50 -
51 [ "Music", "edu packscholar #1", "ese", "Unknown", 1999, 2, 5463.700833, 2268.27, 4139.47, 3391.39 ] 51 -
52 [ "Men", "edu packimporto #1", "ought", "Unknown", 1999, 7, 5176.2575, 1993.73, 3542.54, 5764.35 ] 52 -
53 [ "Children", "exportiexporti #1", "ese", "Unknown", 1999, 3, 5185.898333, 2019.69, 3479.21, 2982.05 ] 53 -
54 [ "Shoes", "amalgedu pack #1", "ation", "Unknown", 1999, 6, 5152.095833, 2077.67, 3123.43, 2368.73 ] 54 -
55 [ "Men", "edu packimporto #1", "eing", "Unknown", 1999, 3, 5501.180833, 2453.88, 2683.70, 2615.32 ] 55 -
56 [ "Children", "exportiexporti #1", "ation", "Unknown", 1999, 4, 5238.3575, 2232.03, 3221.70, 3649.52 ] 56 -
57 [ "Shoes", "importoedu pack #1", "eing", "Unknown", 1999, 5, 4698.6125, 1703.27, 2687.15, 2757.83 ] 57 -
58 [ "Music", "exportischolar #1", "bar", "Unknown", 1999, 7, 5318.146667, 2346.06, 3483.88, 7658.62 ] 58 -
59 [ "Music", "edu packscholar #1", "ation", "Unknown", 1999, 2, 5622.2275, 2657.68, 4207.03, 3543.82 ] 59 -
60 [ "Children", "exportiexporti #1", "bar", "Unknown", 1999, 7, 5280.6625, 2324.79, 3003.61, 5961.39 ] 60 -
61 [ "Children", "importoexporti #1", "eing", "Unknown", 1999, 2, 4650.438333, 1734.45, 2341.19, 2720.78 ] 61 -
62 [ "Shoes", "importoedu pack #1", "ought", "Unknown", 1999, 4, 4537.635833, 1623.33, 2928.34, 1905.23 ] 62 -
63 [ "Women", "edu packamalg #1", "ation", "Unknown", 1999, 4, 4507.4175, 1596.92, 2865.38, 2665.75 ] 63 -
64 [ "Men", "importoimporto #1", "ought", "Unknown", 1999, 6, 5045.758333, 2152.15, 2834.94, 2667.92 ] 64 -
65 [ "Men", "edu packimporto #1", "eing", "Unknown", 1999, 4, 5501.180833, 2615.32, 2453.88, 2874.96 ] 65 -
66 [ "Shoes", "exportiedu pack #1", "bar", "Unknown", 1999, 3, 5296.089167, 2410.44, 2685.85, 3821.39 ] 66 -
67 [ "Men", "importoimporto #1", "able", "Unknown", 1999, 2, 5194.818333, 2333.43, 2765.75, 2674.91 ] 67 -
68 [ "Music", "amalgscholar #1", "ought", "Unknown", 1999, 2, 4565.6, 1727.16, 3895.09, 2606.58 ] 68 -
69 [ "Music", "edu packscholar #1", "eing", "Unknown", 1999, 5, 5539.308333, 2704.16, 3862.34, 3960.90 ] 69 -
70 [ "Shoes", "importoedu pack #1", "ation", "Unknown", 1999, 4, 4690.5775, 1855.85, 3524.69, 3050.34 ] 70 -
71 [ "Men", "edu packimporto #1", "eing", "Unknown", 1999, 2, 5501.180833, 2683.70, 4304.21, 2453.88 ] 71 -
72 [ "Women", "exportiamalg #1", "able", "Unknown", 1999, 2, 4123.600833, 1306.40, 2876.61, 2238.71 ] 72 -
73 [ "Music", "exportischolar #1", "able", "Unknown", 1999, 5, 5090.105, 2281.80, 2488.24, 3304.75 ] 73 -
74 [ "Shoes", "exportiedu pack #1", "ought", "Unknown", 1999, 2, 4755.535833, 1951.00, 3949.06, 2767.05 ] 74 -
75 [ "Men", "importoimporto #1", "ese", "Unknown", 1999, 6, 5492.8175, 2691.33, 3210.74, 3754.33 ] 75 -
76 [ "Men", "amalgimporto #1", "ation", "Unknown", 1999, 2, 4909.460833, 2116.43, 3187.20, 3356.64 ] 76 -
77 [ "Men", "importoimporto #1", "ought", "Unknown", 1999, 2, 5045.758333, 2253.70, 4158.86, 3467.09 ] 77 -
78 [ "Shoes", "amalgedu pack #1", "ation", "Unknown", 1999, 7, 5152.095833, 2368.73, 2077.67, 7543.60 ] 78 -
79 [ "Men", "edu packimporto #1", "ese", "Unknown", 1999, 3, 4979.361667, 2201.00, 3110.55, 3118.30 ] 79 -
80 [ "Children", "exportiexporti #1", "ation", "Unknown", 1999, 2, 5238.3575, 2462.96, 3808.48, 3221.70 ] 80 -
81 [ "Men", "amalgimporto #1", "ation", "Unknown", 1999, 4, 4909.460833, 2136.23, 3356.64, 3046.51 ] 81 -
82 [ "Children", "importoexporti #1", "able", "Unknown", 1999, 7, 4586.298333, 1814.46, 2643.58, 6423.18 ] 82 -
83 [ "Men", "edu packimporto #1", "ation", "Unknown", 1999, 4, 5170.369167, 2407.58, 3086.77, 2492.73 ] 83 -
84 [ "Shoes", "amalgedu pack #1", "ese", "Unknown", 1999, 7, 4392.186667, 1630.14, 2755.91, 6185.73 ] 84 -
85 [ "Shoes", "amalgedu pack #1", "able", "Unknown", 1999, 5, 4940.2275, 2187.55, 2894.91, 3018.65 ] 85 -
86 [ "Men", "edu packimporto #1", "ought", "Unknown", 1999, 4, 5176.2575, 2424.94, 4285.78, 3286.20 ] 86 -
87 [ "Women", "amalgamalg #1", "able", "Unknown", 1999, 6, 4507.24, 1761.81, 2891.95, 2302.21 ] 87 -
88 [ "Men", "importoimporto #1", "ation", "Unknown", 1999, 3, 5410.916667, 2672.68, 3591.65, 2988.08 ] 88 -
89 [ "Men", "importoimporto #1", "ation", "Unknown", 1999, 5, 5410.916667, 2677.81, 2988.08, 2881.34 ] 89 -
90 [ "Men", "edu packimporto #1", "bar", "Unknown", 1999, 4, 5632.736667, 2901.64, 3202.87, 3447.78 ] 90 -
91 [ "Children", "exportiexporti #1", "able", "Unknown", 1999, 5, 4955.241667, 2230.80, 2395.57, 3003.89 ] 91 -
92 [ "Men", "importoimporto #1", "eing", "Unknown", 1999, 5, 5074.076667, 2356.88, 2833.40, 2854.62 ] 92 -
93 [ "Men", "edu packimporto #1", "bar", "Unknown", 1999, 2, 5632.736667, 2916.43, 3847.05, 3202.87 ] 93 -
94 [ "Shoes", "exportiedu pack #1", "ese", "Unknown", 1999, 3, 4865.288333, 2151.76, 3212.91, 3768.25 ] 94 -
95 [ "Men", "importoimporto #1", "ese", "Unknown", 1999, 4, 5492.8175, 2784.11, 2070.65, 3210.74 ] 95 -
96 [ "Shoes", "exportiedu pack #1", "bar", "Unknown", 1999, 7, 5296.089167, 2591.12, 3012.98, 6254.36 ] 96 -
97 [ "Shoes", "exportiedu pack #1", "ation", "Unknown", 1999, 5, 4873.510833, 2170.98, 2302.76, 3236.50 ] 97 -
98 [ "Shoes", "amalgedu pack #1", "able", "Unknown", 1999, 2, 4940.2275, 2239.16, 3495.29, 2563.93 ] 98 -
99 [ "Children", "exportiexporti #1", "eing", "Unknown", 1999, 7, 5109.654167, 2410.24, 2916.46, 6558.23 ] 99 -
100 [ "Women", "importoamalg #1", "able", "Unknown", 1999, 7, 4574.7425, 1881.03, 2345.66, 6036.28 ] 100 -
101 [ "Women", "amalgamalg #1", "ought", "Unknown", 1999, 7, 4619.7075, 1926.67, 3528.98, 5162.15 ] 101 -
102 [ "Children", "importoexporti #1", "bar", "Unknown", 1999, 7, 4566.775833, 1879.57, 3400.62, 6244.92 ] 102 -
103 [ "Music", "edu packscholar #1", "ation", "Unknown", 1999, 6, 5622.2275, 2943.26, 3643.42, 3847.77 ] 103 -
104 [ "Music", "exportischolar #1", "ation", "Unknown", 1999, 4, 4962.65, 2283.77, 3210.01, 2539.84 ] 104 -
105 [ "Music", "exportischolar #1", "ation", "Unknown", 1999, 2, 4962.65, 2284.23, 3250.69, 3210.01 ] 105 -
106 [ "Men", "edu packimporto #1", "ation", "Unknown", 1999, 5, 5170.369167, 2492.73, 2407.58, 3288.94 ] 106 -
107 [ "Men", "edu packimporto #1", "able", "Unknown", 1999, 3, 4989.301667, 2318.98, 2618.89, 3315.77 ] 107 -
108 [ "Music", "exportischolar #1", "bar", "Unknown", 1999, 4, 5318.146667, 2651.96, 2989.10, 3649.76 ] 108 -
109 [ "Music", "exportischolar #1", "bar", "Unknown", 1999, 2, 5318.146667, 2656.31, 3419.77, 2989.10 ] 109 -
110 [ "Shoes", "amalgedu pack #1", "bar", "Unknown", 1999, 6, 4805.401667, 2149.56, 2686.70, 3098.25 ] 110 -
111 [ "Children", "exportiexporti #1", "bar", "Unknown", 1999, 4, 5280.6625, 2625.99, 3301.62, 4331.44 ] 111 -
112 [ "Music", "amalgscholar #1", "ation", "Unknown", 1999, 4, 4934.504167, 2280.93, 2322.89, 2421.13 ] 112 -
113 [ "Music", "edu packscholar #1", "able", "Unknown", 1999, 7, 5335.908333, 2684.15, 3543.33, 7540.94 ] 113 -
114 [ "Shoes", "importoedu pack #1", "eing", "Unknown", 1999, 2, 4698.6125, 2058.86, 3191.74, 2812.15 ] 114 -
115 [ "Shoes", "edu packedu pack #1", "ought", "Unknown", 1999, 5, 4745.295833, 2109.27, 3203.82, 2737.82 ] 115 -
116 [ "Shoes", "importoedu pack #1", "ought", "Unknown", 1999, 5, 4537.635833, 1905.23, 1623.33, 3170.58 ] 116 -
117 [ "Men", "edu packimporto #1", "able", "Unknown", 1999, 6, 4989.301667, 2357.82, 3363.58, 3142.81 ] 117 -
118 [ "Children", "exportiexporti #1", "able", "Unknown", 1999, 2, 4955.241667, 2326.67, 2746.99, 3097.63 ] 118 -
119 [ "Men", "edu packimporto #1", "eing", "Unknown", 1999, 5, 5501.180833, 2874.96, 2615.32, 3714.00 ] 119 -
120 [ "Shoes", "exportiedu pack #1", "ation", "Unknown", 1999, 7, 4873.510833, 2256.56, 3236.50, 6245.37 ] 120 -
121 [ "Shoes", "importoedu pack #1", "ese", "Unknown", 1999, 3, 4676.749167, 2060.29, 3273.67, 2610.86 ] 121 -
122 [ "Men", "amalgimporto #1", "ese", "Unknown", 1999, 6, 4764.596667, 2150.16, 3284.27, 3475.17 ] 122 -
123 [ "Music", "amalgscholar #1", "ation", "Unknown", 1999, 3, 4934.504167, 2322.89, 3197.76, 2280.93 ] 123 -
124 [ "Shoes", "exportiedu pack #1", "bar", "Unknown", 1999, 2, 5296.089167, 2685.85, 4235.44, 2410.44 ] 124 -
125 [ "Children", "importoexporti #1", "able", "Unknown", 1999, 5, 4586.298333, 1982.77, 2837.74, 2643.58 ] 125 -
126 [ "Music", "exportischolar #1", "able", "Unknown", 1999, 4, 5090.105, 2488.24, 2966.36, 2281.80 ] 126 -
127 [ "Shoes", "importoedu pack #1", "able", "Unknown", 1999, 7, 4700.911667, 2100.12, 2533.01, 5888.57 ] 127 -
128 [ "Music", "edu packscholar #1", "bar", "Unknown", 1999, 2, 5484.789167, 2903.45, 3410.13, 3024.86 ] 128 -
129 [ "Shoes", "exportiedu pack #1", "ation", "Unknown", 1999, 3, 4873.510833, 2300.45, 2797.30, 2302.76 ] 129 -
130 [ "Shoes", "exportiedu pack #1", "ation", "Unknown", 1999, 4, 4873.510833, 2302.76, 2300.45, 2170.98 ] 130 -
131 [ "Shoes", "importoedu pack #1", "bar", "Unknown", 1999, 3, 4794.679167, 2225.70, 2756.97, 2413.76 ] 131 -
132 [ "Music", "edu packscholar #1", "ought", "Unknown", 1999, 5, 5552.305, 2985.49, 3241.69, 4081.99 ] 132 -
133 [ "Music", "edu packscholar #1", "eing", "Unknown", 1999, 3, 5539.308333, 2973.01, 3069.18, 3862.34 ] 133 -
134 [ "Shoes", "amalgedu pack #1", "eing", "Unknown", 1999, 7, 4706.544167, 2143.18, 2458.07, 5967.73 ] 134 -
135 [ "Children", "exportiexporti #1", "ought", "Unknown", 1999, 5, 5018.279167, 2458.03, 3467.53, 2683.61 ] 135 -
136 [ "Children", "exportiexporti #1", "able", "Unknown", 1999, 4, 4955.241667, 2395.57, 3097.63, 2230.80 ] 136 -
137 [ "Children", "exportiexporti #1", "eing", "Unknown", 1999, 2, 5109.654167, 2550.30, 4039.10, 2685.10 ] 137 -
138 [ "Music", "exportischolar #1", "ought", "Unknown", 1999, 4, 5079.1825, 2520.64, 3233.50, 3079.89 ] 138 -
139 [ "Women", "edu packamalg #1", "ation", "Unknown", 1999, 2, 4507.4175, 1951.42, 4166.02, 2865.38 ] 139 -
140 [ "Women", "amalgamalg #1", "ought", "Unknown", 1999, 1, 4619.7075, 2065.94, 9639.59, 2521.70 ] 140 -
141 [ "Music", "importoscholar #1", "ought", "Unknown", 1999, 3, 4004.448333, 1456.84, 2438.63, 2790.03 ] 141 -
142 [ "Shoes", "edu packedu pack #1", "eing", "Unknown", 1999, 5, 4664.861667, 2122.71, 3131.02, 2852.96 ] 142 -
143 [ "Women", "importoamalg #1", "bar", "Unknown", 1999, 3, 4437.210833, 1895.27, 2678.48, 2999.04 ] 143 -
144 [ "Music", "exportischolar #1", "able", "Unknown", 1999, 2, 5090.105, 2550.48, 3702.29, 2966.36 ] 144 -
145 [ "Music", "edu packscholar #1", "able", "Unknown", 1999, 1, 5335.908333, 2796.97, 13360.68, 3413.22 ] 145 -
146 [ "Children", "exportiexporti #1", "eing", "Unknown", 1999, 4, 5109.654167, 2574.12, 2685.10, 2672.73 ] 146 -
147 147 -
148 # 18:32:21 > 148 -
149 # 18:32:21 > "Done." 149 -
150 # 18:32:21 > 150 -
151 151 -
152 # 18:29:57 > 152 -
153 # 18:29:57 > "Done." 153 -
154 # 18:29:57 > 154 -