Test 63.sql (id 3c6cbe78e1fe) (err)
63.stable.out.int128.FILTERED 2019-09-08 11:29:43.000000000 +020063.test.out.FILTERED 2019-09-08 11:29:43.000000000 +0200
1 Statistics about stdout of test '63` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '63` in directory 'sql/benchmarks/tpcds`: 1
2 105 lines, 532 words, 2788 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 532 words, 2788 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 144 lines, 704 words, 4219 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 34 34
27 # 18:29:58 > 27 -
28 # 18:29:58 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" 28 -
29 # 18:29:58 > 29 -
30 30 -
31 #SELECT * 31 -
32 #FROM 32 -
33 # (SELECT i_manager_id, 33 -
34 # sum(ss_sales_price) sum_sales, 34 -
35 # avg(sum(ss_sales_price)) OVER (PARTITION BY i_manager_id) avg_monthly_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 % sys.tmp1, sys.tmp1, sys.tmp1 # table_name 42 -
43 % i_manager_id, sum_sales, avg_monthly_sales # name 43 -
44 % int, decimal, double # type 44 -
45 % 2, 40, 24 # length 45 -
46 [ 1, 189.04, 531.9191667 ] 46 -
47 [ 1, 203.73, 531.9191667 ] 47 -
48 [ 1, 355.17, 531.9191667 ] 48 -
49 [ 1, 359.53, 531.9191667 ] 49 -
50 [ 1, 365.84, 531.9191667 ] 50 -
51 [ 1, 373.26, 531.9191667 ] 51 -
52 [ 1, 430.03, 531.9191667 ] 52 -
53 [ 1, 698.60, 531.9191667 ] 53 -
54 [ 1, 909.18, 531.9191667 ] 54 -
55 [ 1, 995.02, 531.9191667 ] 55 -
56 [ 1, 998.95, 531.9191667 ] 56 -
57 [ 2, 34.79, 625.0316667 ] 57 -
58 [ 2, 143.64, 625.0316667 ] 58 -
59 [ 2, 253.85, 625.0316667 ] 59 -
60 [ 2, 359.05, 625.0316667 ] 60 -
61 [ 2, 445.59, 625.0316667 ] 61 -
62 [ 2, 499.99, 625.0316667 ] 62 -
63 [ 2, 538.36, 625.0316667 ] 63 -
64 [ 2, 780.07, 625.0316667 ] 64 -
65 [ 2, 1487.82, 625.0316667 ] 65 -
66 [ 2, 1660.48, 625.0316667 ] 66 -
67 [ 3, 270.10, 988.2933333 ] 67 -
68 [ 3, 367.94, 988.2933333 ] 68 -
69 [ 3, 491.20, 988.2933333 ] 69 -
70 [ 3, 529.42, 988.2933333 ] 70 -
71 [ 3, 629.34, 988.2933333 ] 71 -
72 [ 3, 757.70, 988.2933333 ] 72 -
73 [ 3, 1161.47, 988.2933333 ] 73 -
74 [ 3, 1234.30, 988.2933333 ] 74 -
75 [ 3, 1251.01, 988.2933333 ] 75 -
76 [ 3, 1522.49, 988.2933333 ] 76 -
77 [ 3, 2624.04, 988.2933333 ] 77 -
78 [ 5, 353.24, 1169.4825 ] 78 -
79 [ 5, 581.28, 1169.4825 ] 79 -
80 [ 5, 694.79, 1169.4825 ] 80 -
81 [ 5, 696.66, 1169.4825 ] 81 -
82 [ 5, 740.99, 1169.4825 ] 82 -
83 [ 5, 890.86, 1169.4825 ] 83 -
84 [ 5, 955.61, 1169.4825 ] 84 -
85 [ 5, 1359.61, 1169.4825 ] 85 -
86 [ 5, 1712.35, 1169.4825 ] 86 -
87 [ 5, 1794.66, 1169.4825 ] 87 -
88 [ 5, 2080.16, 1169.4825 ] 88 -
89 [ 5, 2173.58, 1169.4825 ] 89 -
90 [ 6, 644.61, 1772.998333 ] 90 -
91 [ 6, 851.23, 1772.998333 ] 91 -
92 [ 6, 868.62, 1772.998333 ] 92 -
93 [ 6, 1056.06, 1772.998333 ] 93 -
94 [ 6, 1150.40, 1772.998333 ] 94 -
95 [ 6, 1196.50, 1772.998333 ] 95 -
96 [ 6, 1551.15, 1772.998333 ] 96 -
97 [ 6, 2576.64, 1772.998333 ] 97 -
98 [ 6, 2875.54, 1772.998333 ] 98 -
99 [ 6, 3299.70, 1772.998333 ] 99 -
100 [ 6, 3309.13, 1772.998333 ] 100 -
101 [ 7, 638.30, 1499.6575 ] 101 -
102 [ 7, 663.54, 1499.6575 ] 102 -
103 [ 7, 779.65, 1499.6575 ] 103 -
104 [ 7, 800.25, 1499.6575 ] 104 -
105 [ 7, 811.54, 1499.6575 ] 105 -
106 [ 7, 987.78, 1499.6575 ] 106 -
107 [ 7, 1046.24, 1499.6575 ] 107 -
108 [ 7, 1667.92, 1499.6575 ] 108 -
109 [ 7, 2750.32, 1499.6575 ] 109 -
110 [ 7, 2970.80, 1499.6575 ] 110 -
111 [ 7, 3524.00, 1499.6575 ] 111 -
112 [ 8, 803.53, 1618.954167 ] 112 -
113 [ 8, 819.18, 1618.954167 ] 113 -
114 [ 8, 933.76, 1618.954167 ] 114 -
115 [ 8, 944.19, 1618.954167 ] 115 -
116 [ 8, 1019.24, 1618.954167 ] 116 -
117 [ 8, 1159.06, 1618.954167 ] 117 -
118 [ 8, 1290.94, 1618.954167 ] 118 -
119 [ 8, 2168.17, 1618.954167 ] 119 -
120 [ 8, 2264.18, 1618.954167 ] 120 -
121 [ 8, 3033.41, 1618.954167 ] 121 -
122 [ 8, 3213.77, 1618.954167 ] 122 -
123 [ 9, 315.31, 1509.9775 ] 123 -
124 [ 9, 559.82, 1509.9775 ] 124 -
125 [ 9, 728.72, 1509.9775 ] 125 -
126 [ 9, 784.15, 1509.9775 ] 126 -
127 [ 9, 923.36, 1509.9775 ] 127 -
128 [ 9, 933.68, 1509.9775 ] 128 -
129 [ 9, 1239.49, 1509.9775 ] 129 -
130 [ 9, 1848.85, 1509.9775 ] 130 -
131 [ 9, 2172.04, 1509.9775 ] 131 -
132 [ 9, 2178.07, 1509.9775 ] 132 -
133 [ 9, 3165.98, 1509.9775 ] 133 -
134 [ 9, 3270.26, 1509.9775 ] 134 -
135 [ 10, 314.30, 1125.259167 ] 135 -
136 [ 10, 365.57, 1125.259167 ] 136 -
137 [ 10, 591.30, 1125.259167 ] 137 -
138 [ 10, 760.81, 1125.259167 ] 138 -
139 [ 10, 776.91, 1125.259167 ] 139 -
140 [ 10, 959.65, 1125.259167 ] 140 -
141 [ 10, 975.25, 1125.259167 ] 141 -
142 [ 10, 1294.20, 1125.259167 ] 142 -
143 [ 10, 1342.05, 1125.259167 ] 143 -
144 [ 10, 1914.64, 1125.259167 ] 144 -
145 [ 10, 3105.53, 1125.259167 ] 145 -
146 146 -
147 # 18:29:58 > 147 -
148 # 18:29:58 > "Done." 148 -
149 # 18:29:58 > 149 -