Test 57.sql (id 3c6cbe78e1fe) (err)
57.stable.out.int128.FILTERED 2019-09-08 14:06:26.579847326 +020057.test.out.FILTERED 2019-09-08 14:06:26.581847343 +0200
1 Statistics about stdout of test '57` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '57` in directory 'sql/benchmarks/tpcds`: 1
2 105 lines, 1399 words, 9881 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 1399 words, 9881 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 146 lines, 1572 words, 11304 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:06:26 > 26
+ 27 # 14:06:26 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-5151" "--port=30816" 27
+ 28 # 14:06:26 > 28
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 # 14:06:26 > 31
29 # 18:29:57 > 29 ! 32 # 14:06:26 > "Done." 32
30 30 ! 33 # 14:06:26 > 33
31 #WITH v1 AS 31 -
32 # (SELECT i_category, 32 -
33 # i_brand, 33 -
34 # cc_name, 34 -
35 # d_year, 35 -
36 # d_moy, 36 -
37 # sum(cs_sales_price) sum_sales, 37 -
38 # avg(sum(cs_sales_price)) OVER (PARTITION BY i_category, 38 -
39 # i_brand, 39 -
40 # cc_name, 40 -
41 # d_year) avg_monthly_sales, 41 -
42 # rank() OVER (PARTITION BY i_category, 42 -
43 % 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, cc_name, d_year, d_moy, avg_monthly_sales, sum_sales, psum, nsum # name 44 -
45 % char, char, varchar, int, int, double, decimal, decimal, decimal # type 45 -
46 % 50, 50, 13, 4, 1, 24, 40, 40, 40 # length 46 -
47 [ "Shoes", "importoedu pack #1", "North Midwest", 1999, 3, 7101.78, 2518.33, 5264.86, 3066.29 ] 47 -
48 [ "Men", "edu packimporto #1", "NY Metro", 1999, 4, 7659.241667, 3227.88, 4759.01, 4664.83 ] 48 -
49 [ "Music", "amalgscholar #1", "Mid Atlantic", 1999, 1, 6659.493333, 2291.60, 14178.45, 4267.08 ] 49 -
50 [ "Men", "edu packimporto #1", "NY Metro", 1999, 7, 7659.241667, 3327.90, 4566.86, 11656.06 ] 50 -
51 [ "Men", "importoimporto #1", "North Midwest", 1999, 5, 7640.491667, 3327.30, 3534.12, 5530.63 ] 51 -
52 [ "Music", "edu packscholar #1", "Mid Atlantic", 1999, 1, 8223.719167, 3965.88, 14493.32, 4943.68 ] 52 -
53 [ "Women", "amalgamalg #1", "Mid Atlantic", 1999, 2, 7116.328333, 2872.43, 4945.20, 2974.14 ] 53 -
54 [ "Music", "exportischolar #1", "NY Metro", 1999, 3, 7047.803333, 2832.46, 4308.87, 3265.21 ] 54 -
55 [ "Children", "importoexporti #1", "NY Metro", 1999, 4, 6809.595833, 2648.85, 5318.02, 4111.73 ] 55 -
56 [ "Children", "importoexporti #1", "Mid Atlantic", 1999, 5, 6832.821667, 2687.17, 3971.76, 4235.84 ] 56 -
57 [ "Music", "edu packscholar #1", "North Midwest", 1999, 1, 8078.69, 3934.06, 17002.72, 4244.46 ] 57 -
58 [ "Women", "amalgamalg #1", "Mid Atlantic", 1999, 3, 7116.328333, 2974.14, 2872.43, 4329.06 ] 58 -
59 [ "Music", "edu packscholar #1", "Mid Atlantic", 1999, 4, 8223.719167, 4091.54, 5753.94, 4797.32 ] 59 -
60 [ "Men", "importoimporto #1", "NY Metro", 1999, 2, 7530.9975, 3406.53, 5839.59, 6125.77 ] 60 -
61 [ "Men", "edu packimporto #1", "North Midwest", 1999, 3, 7852.6275, 3737.23, 4465.92, 3831.92 ] 61 -
62 [ "Shoes", "edu packedu pack #1", "North Midwest", 1999, 5, 6583.305, 2474.01, 3684.23, 4335.58 ] 62 -
63 [ "Men", "importoimporto #1", "North Midwest", 1999, 4, 7640.491667, 3534.12, 4291.30, 3327.30 ] 63 -
64 [ "Children", "amalgexporti #1", "NY Metro", 1999, 7, 6518.750833, 2430.77, 3203.23, 7867.12 ] 64 -
65 [ "Music", "amalgscholar #1", "North Midwest", 1999, 5, 6876.880833, 2816.26, 4637.07, 3528.80 ] 65 -
66 [ "Shoes", "importoedu pack #1", "North Midwest", 1999, 4, 7101.78, 3066.29, 2518.33, 5005.85 ] 66 -
67 [ "Shoes", "edu packedu pack #1", "NY Metro", 1999, 2, 6421.7925, 2394.57, 3149.35, 4472.43 ] 67 -
68 [ "Music", "edu packscholar #1", "NY Metro", 1999, 7, 7966.579167, 3944.74, 5030.35, 10791.61 ] 68 -
69 [ "Men", "edu packimporto #1", "North Midwest", 1999, 4, 7852.6275, 3831.92, 3737.23, 4353.90 ] 69 -
70 [ "Shoes", "importoedu pack #1", "Mid Atlantic", 1999, 3, 6959.934167, 2951.09, 4142.26, 3271.07 ] 70 -
71 [ "Men", "amalgimporto #1", "NY Metro", 1999, 7, 7082.129167, 3075.18, 5231.88, 8953.66 ] 71 -
72 [ "Shoes", "amalgedu pack #1", "NY Metro", 1999, 7, 6904.689167, 2902.26, 4942.02, 8793.71 ] 72 -
73 [ "Men", "importoimporto #1", "Mid Atlantic", 1999, 1, 7357.060833, 3356.15, 11222.19, 3770.17 ] 73 -
74 [ "Children", "exportiexporti #1", "NY Metro", 1999, 7, 7698.340833, 3714.25, 4686.40, 9752.38 ] 74 -
75 [ "Children", "exportiexporti #1", "North Midwest", 1999, 3, 7530.375, 3586.50, 3960.74, 3916.86 ] 75 -
76 [ "Children", "amalgexporti #1", "NY Metro", 1999, 4, 6518.750833, 2587.68, 4177.93, 3342.60 ] 76 -
77 [ "Music", "edu packscholar #1", "North Midwest", 1999, 5, 8078.69, 4148.83, 5184.39, 5483.81 ] 77 -
78 [ "Children", "exportiexporti #1", "Mid Atlantic", 1999, 3, 7245.285, 3350.65, 3876.83, 5869.66 ] 78 -
79 [ "Children", "exportiexporti #1", "North Midwest", 1999, 1, 7530.375, 3645.95, 13367.51, 3960.74 ] 79 -
80 [ "Shoes", "exportiedu pack #1", "Mid Atlantic", 1999, 2, 6885.320833, 3013.95, 4139.82, 4328.03 ] 80 -
81 [ "Children", "importoexporti #1", "North Midwest", 1999, 7, 6690.091667, 2827.63, 3965.68, 7733.16 ] 81 -
82 [ "Music", "edu packscholar #1", "North Midwest", 1999, 2, 8078.69, 4244.46, 3934.06, 4448.50 ] 82 -
83 [ "Men", "edu packimporto #1", "Mid Atlantic", 1999, 1, 7912.5375, 4082.68, 14333.30, 4383.51 ] 83 -
84 [ "Children", "exportiexporti #1", "NY Metro", 1999, 3, 7698.340833, 3883.01, 4723.97, 4590.03 ] 84 -
85 [ "Music", "exportischolar #1", "Mid Atlantic", 1999, 2, 7243.994167, 3430.04, 3662.97, 3617.09 ] 85 -
86 [ "Music", "exportischolar #1", "NY Metro", 1999, 1, 7047.803333, 3237.56, 15805.49, 4308.87 ] 86 -
87 [ "Music", "exportischolar #1", "NY Metro", 1999, 4, 7047.803333, 3265.21, 2832.46, 3885.17 ] 87 -
88 [ "Music", "exportischolar #1", "North Midwest", 1999, 2, 7593.929167, 3821.24, 4748.20, 4271.45 ] 88 -
89 [ "Men", "edu packimporto #1", "Mid Atlantic", 1999, 4, 7912.5375, 4144.67, 4954.05, 5070.06 ] 89 -
90 [ "Music", "amalgscholar #1", "NY Metro", 1999, 4, 6926.060833, 3165.20, 4688.23, 4286.05 ] 90 -
91 [ "Shoes", "amalgedu pack #1", "Mid Atlantic", 1999, 3, 6642.085833, 2928.82, 3648.57, 3892.32 ] 91 -
92 [ "Music", "edu packscholar #1", "NY Metro", 1999, 3, 7966.579167, 4269.89, 4384.51, 4452.73 ] 92 -
93 [ "Men", "amalgimporto #1", "NY Metro", 1999, 2, 7082.129167, 3392.25, 4549.47, 3653.84 ] 93 -
94 [ "Shoes", "importoedu pack #1", "Mid Atlantic", 1999, 4, 6959.934167, 3271.07, 2951.09, 4231.88 ] 94 -
95 [ "Music", "amalgscholar #1", "North Midwest", 1999, 3, 6876.880833, 3190.36, 3536.29, 4637.07 ] 95 -
96 [ "Women", "importoamalg #1", "Mid Atlantic", 1999, 1, 6479.298333, 2804.94, 13543.31, 3515.21 ] 96 -
97 [ "Shoes", "amalgedu pack #1", "North Midwest", 1999, 6, 6829.956667, 3178.20, 4120.60, 5910.98 ] 97 -
98 [ "Men", "amalgimporto #1", "NY Metro", 1999, 4, 7082.129167, 3450.11, 3653.84, 5965.16 ] 98 -
99 [ "Women", "edu packamalg #1", "NY Metro", 1999, 4, 6608.485833, 2976.95, 3489.35, 3812.22 ] 99 -
100 [ "Music", "edu packscholar #1", "North Midwest", 1999, 3, 8078.69, 4448.50, 4244.46, 5184.39 ] 100 -
101 [ "Music", "amalgscholar #1", "Mid Atlantic", 1999, 7, 6659.493333, 3031.62, 4214.81, 9493.69 ] 101 -
102 [ "Music", "exportischolar #1", "Mid Atlantic", 1999, 3, 7243.994167, 3617.09, 3430.04, 3871.67 ] 102 -
103 [ "Men", "importoimporto #1", "NY Metro", 1999, 7, 7530.9975, 3913.80, 4405.46, 7859.96 ] 103 -
104 [ "Children", "exportiexporti #1", "North Midwest", 1999, 4, 7530.375, 3916.86, 3586.50, 4747.06 ] 104 -
105 [ "Children", "importoexporti #1", "NY Metro", 1999, 2, 6809.595833, 3200.10, 4421.85, 5318.02 ] 105 -
106 [ "Men", "importoimporto #1", "Mid Atlantic", 1999, 2, 7357.060833, 3770.17, 3356.15, 5114.32 ] 106 -
107 [ "Children", "amalgexporti #1", "North Midwest", 1999, 2, 6557.5775, 2975.00, 3418.40, 5079.56 ] 107 -
108 [ "Music", "edu packscholar #1", "NY Metro", 1999, 2, 7966.579167, 4384.51, 5279.09, 4269.89 ] 108 -
109 [ "Music", "exportischolar #1", "Mid Atlantic", 1999, 1, 7243.994167, 3662.97, 14285.88, 3430.04 ] 109 -
110 [ "Children", "exportiexporti #1", "North Midwest", 1999, 2, 7530.375, 3960.74, 3645.95, 3586.50 ] 110 -
111 [ "Men", "amalgimporto #1", "Mid Atlantic", 1999, 1, 6611.335833, 3066.19, 11053.20, 3203.24 ] 111 -
112 [ "Women", "edu packamalg #1", "Mid Atlantic", 1999, 4, 6061.210833, 2522.22, 2674.89, 3975.90 ] 112 -
113 [ "Shoes", "exportiedu pack #1", "North Midwest", 1999, 4, 7045.164167, 3509.17, 5252.01, 3987.99 ] 113 -
114 [ "Men", "edu packimporto #1", "North Midwest", 1999, 1, 7852.6275, 4318.23, 16397.10, 4465.92 ] 114 -
115 [ "Men", "edu packimporto #1", "Mid Atlantic", 1999, 2, 7912.5375, 4383.51, 4082.68, 4954.05 ] 115 -
116 [ "Music", "edu packscholar #1", "NY Metro", 1999, 4, 7966.579167, 4452.73, 4269.89, 5476.13 ] 116 -
117 [ "Children", "importoexporti #1", "Mid Atlantic", 1999, 1, 6832.821667, 3330.21, 13097.88, 3496.46 ] 117 -
118 [ "Men", "edu packimporto #1", "North Midwest", 1999, 5, 7852.6275, 4353.90, 3831.92, 5689.03 ] 118 -
119 [ "Women", "exportiamalg #1", "Mid Atlantic", 1999, 2, 6013.088333, 2536.08, 3406.41, 3718.65 ] 119 -
120 [ "Music", "exportischolar #1", "North Midwest", 1999, 4, 7593.929167, 4121.47, 4271.45, 5234.85 ] 120 -
121 [ "Music", "amalgscholar #1", "North Midwest", 1999, 1, 6876.880833, 3406.89, 13714.11, 3536.29 ] 121 -
122 [ "Men", "importoimporto #1", "NY Metro", 1999, 4, 7530.9975, 4062.17, 6125.77, 4715.58 ] 122 -
123 [ "Men", "exportiimporto #1", "North Midwest", 1999, 5, 5797.3825, 2330.52, 2965.11, 2842.02 ] 123 -
124 [ "Children", "edu packexporti #1", "Mid Atlantic", 1999, 3, 6100.643333, 2633.95, 3676.43, 3130.51 ] 124 -
125 [ "Men", "amalgimporto #1", "North Midwest", 1999, 1, 6713.82, 3268.58, 13596.45, 4098.03 ] 125 -
126 [ "Women", "exportiamalg #1", "NY Metro", 1999, 4, 6031.0425, 2588.60, 3554.29, 3915.46 ] 126 -
127 [ "Men", "amalgimporto #1", "NY Metro", 1999, 3, 7082.129167, 3653.84, 3392.25, 3450.11 ] 127 -
128 [ "Music", "edu packscholar #1", "Mid Atlantic", 1999, 5, 8223.719167, 4797.32, 4091.54, 5028.71 ] 128 -
129 [ "Children", "exportiexporti #1", "North Midwest", 1999, 6, 7530.375, 4104.53, 4747.06, 4586.73 ] 129 -
130 [ "Women", "importoamalg #1", "NY Metro", 1999, 4, 6352.6825, 2928.62, 3718.55, 3387.14 ] 130 -
131 [ "Men", "edu packimporto #1", "NY Metro", 1999, 2, 7659.241667, 4246.37, 4489.63, 4759.01 ] 131 -
132 [ "Shoes", "edu packedu pack #1", "Mid Atlantic", 1999, 3, 6578.785833, 3166.49, 4213.93, 4376.74 ] 132 -
133 [ "Shoes", "amalgedu pack #1", "North Midwest", 1999, 4, 6829.956667, 3417.69, 3722.75, 4120.60 ] 133 -
134 [ "Women", "exportiamalg #1", "North Midwest", 1999, 3, 6171.544167, 2760.78, 3853.84, 3125.47 ] 134 -
135 [ "Men", "amalgimporto #1", "Mid Atlantic", 1999, 2, 6611.335833, 3203.24, 3066.19, 4613.61 ] 135 -
136 [ "Men", "edu packimporto #1", "North Midwest", 1999, 2, 7852.6275, 4465.92, 4318.23, 3737.23 ] 136 -
137 [ "Women", "edu packamalg #1", "Mid Atlantic", 1999, 3, 6061.210833, 2674.89, 3376.95, 2522.22 ] 137 -
138 [ "Music", "exportischolar #1", "NY Metro", 1999, 6, 7047.803333, 3667.60, 3885.17, 5088.70 ] 138 -
139 [ "Children", "importoexporti #1", "North Midwest", 1999, 3, 6690.091667, 3310.89, 3486.35, 5014.28 ] 139 -
140 [ "Music", "exportischolar #1", "Mid Atlantic", 1999, 4, 7243.994167, 3871.67, 3617.09, 4628.08 ] 140 -
141 [ "Men", "importoimporto #1", "North Midwest", 1999, 2, 7640.491667, 4270.44, 4931.98, 4291.30 ] 141 -
142 [ "Children", "exportiexporti #1", "Mid Atlantic", 1999, 2, 7245.285, 3876.83, 4799.92, 3350.65 ] 142 -
143 [ "Shoes", "exportiedu pack #1", "North Midwest", 1999, 7, 7045.164167, 3684.37, 4372.20, 8403.23 ] 143 -
144 [ "Men", "importoimporto #1", "North Midwest", 1999, 3, 7640.491667, 4291.30, 4270.44, 3534.12 ] 144 -
145 [ "Men", "amalgimporto #1", "Mid Atlantic", 1999, 4, 6611.335833, 3262.24, 4613.61, 4531.38 ] 145 -
146 [ "Music", "amalgscholar #1", "North Midwest", 1999, 6, 6876.880833, 3528.80, 2816.26, 4750.85 ] 146 -
147 147 -
148 # 18:32:29 > 148 -
149 # 18:32:29 > "Done." 149 -
150 # 18:32:29 > 150 -
151 151 34 34