Test 20.sql (id 3c6cbe78e1fe) (err)
20.stable.out.int128.FILTERED 2019-09-08 11:29:12.000000000 +020020.test.out.FILTERED 2019-09-08 11:29:12.000000000 +0200
1 Statistics about stdout of test '20` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '20` in directory 'sql/benchmarks/tpcds`: 1
2 105 lines, 2381 words, 17533 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 2381 words, 17533 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 145 lines, 2563 words, 19082 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: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 #SELECT i_item_id , 31 -
32 # i_item_desc, 32 -
33 # i_category, 33 -
34 # i_class, 34 -
35 # i_current_price , 35 -
36 # sum(cs_ext_sales_price) AS itemrevenue, 36 -
37 # sum(cs_ext_sales_price)*100.0000/sum(sum(cs_ext_sales_price)) OVER (PARTITION BY i_class) AS revenueratio 37 -
38 #FROM catalog_sales , 38 -
39 # item, 39 -
40 # date_dim 40 -
41 #WHERE cs_item_sk = i_item_sk 41 -
42 % sys.item, sys.item, sys.item, sys.item, sys.item, sys., sys. # table_name 42 -
43 # sys.item, sys.item, sys.item, sys.item, sys.item, sys.L12, sys.L21 # table_name 43 -
44 % i_item_id, i_item_desc, i_category, i_class, i_current_price, itemrevenue, revenueratio # name 44 -
45 % char, varchar, char, char, decimal, decimal, decimal # type 45 -
46 % 16, 200, 50, 50, 9, 40, 40 # length 46 -
47 [ "AAAAAAAAOJGAAAAA", NULL, "Books", NULL, NULL, 2838.09, 24.109780 ] 47 -
48 [ "AAAAAAAAAAKAAAAA", "Small, political activities help great, bad policies. Therefore square features provide on a machines. Rules make over me", "Books", "arts", 2.42, 6478.75, 3.228811 ] 48 -
49 [ "AAAAAAAAACKBAAAA", "Clinical, inc initiatives make specially according to a activities.", "Books", "arts", 6.92, 1806.72, 0.900414 ] 49 -
50 [ "AAAAAAAAAIJCAAAA", "Simply small grounds use exactly effects. Services could kill especially aware, large observers. Civil, relevant years ensure regulations; clear drawings realize actors. Products employ a", "Books", "arts", 1.76, 14302.11, 7.127736 ] 50 -
51 [ "AAAAAAAAAJIAAAAA", "Joint, superior police would use through an restrictions. Buyers ought to contract generally in a efforts. Days cut also sure, frequent s", "Books", "arts", 0.43, 1094.80, 0.545615 ] 51 -
52 [ "AAAAAAAABFHDAAAA", "Little days answer in a emotions; players touch.", "Books", "arts", 2.58, 6331.08, 3.155217 ] 52 -
53 [ "AAAAAAAABHDCAAAA", "Minor heads close common children; recently strong firms provide. Useful, young men ought to create changes. Popular, common regulations might decide. Points fit. Obvious, glad officials ", "Books", "arts", 3.88, 2596.68, 1.294106 ] 53 -
54 [ "AAAAAAAACBACAAAA", "Remaining, main passengers go far sure men. ", "Books", "arts", 4.78, 700.70, 0.349207 ] 54 -
55 [ "AAAAAAAACKDBAAAA", "Positions can win increasingly entire units. Unions used to exclude fairly afraid fans. National fields appear also ways. Great lips print new teachers. Constant, primary deaths expect a little ", "Books", "arts", 3.82, 2828.38, 1.409578 ] 55 -
56 [ "AAAAAAAACKEAAAAA", "Legs appear eventually soci", "Books", "arts", 35.27, 438.70, 0.218634 ] 56 -
57 [ "AAAAAAAACMDCAAAA", "Black, powerful others go now years. Diverse orders might not mean away medium minutes; tight authorities ought to put however for the things", "Books", "arts", 2.75, 6743.51, 3.360760 ] 57 -
58 [ "AAAAAAAACNEDAAAA", "Particularly labour stores get farmers. Hence true records see rel", "Books", "arts", 6.89, 9386.80, 4.678095 ] 58 -
59 [ "AAAAAAAADCCDAAAA", "Glad users understand very almost original jobs. Towns can understand. Supreme, following days work by a parents; german, crucial weapons work sure; fair pictur", "Books", "arts", 7.18, 3375.52, 1.682256 ] 59 -
60 [ "AAAAAAAADJFCAAAA", "Significant, preliminary boys can remain lightly more pale discussion", "Books", "arts", 2.74, 3316.75, 1.652967 ] 60 -
61 [ "AAAAAAAADPCCAAAA", "Especially true items might supply particularly. Black, automatic words might develop post-war problems. Fresh, visible workers could not appe", "Books", "arts", 4.23, 4567.89, 2.276497 ] 61 -
62 [ "AAAAAAAAEDKDAAAA", "Times live now to a sales. British years bring all financ", "Books", "arts", 4.24, 5014.90, 2.499273 ] 62 -
63 [ "AAAAAAAAEGAEAAAA", "Far injuries pay so various arms. Courses could go anywhere universal possibilities; talks stand since mean, colonial scho", "Books", "arts", 9.57, 17491.20, 8.717082 ] 63 -
64 [ "AAAAAAAAEPDDAAAA", "Services used to work most new provi", "Books", "arts", 2.84, 481.44, 0.239935 ] 64 -
65 [ "AAAAAAAAEPKAAAAA", "Here political studies give once at the qu", "Books", "arts", 1.78, 2562.67, 1.277156 ] 65 -
66 [ "AAAAAAAAFBMBAAAA", "Years light glasses. Contemporary members might detect even drawings. Private instructions ought to expect well main streets. Children will say well; usually young members ought to ensure enough. ", "Books", "arts", 4.78, 1718.83, 0.856612 ] 66 -
67 [ "AAAAAAAAFCKCAAAA", "Brilliant, acceptable resources might not pick as. Positive, married parties support only strongly impossible needs. Photogra", "Books", "arts", 2.44, 2958.33, 1.474341 ] 67 -
68 [ "AAAAAAAAGAKAAAAA", "Especially early girls glance however specific, relevant steps. Financial worlds telephone most dark gains. Warm, outdoor devices defend besides. Unions must not say narrow powers; individual ti", "Books", "arts", 8.96, 2310.78, 1.151622 ] 68 -
69 [ "AAAAAAAAGFHBAAAA", "Contemporary occasions provide she", "Books", "arts", 1.75, 11988.75, 5.974828 ] 69 -
70 [ "AAAAAAAAGHOBAAAA", "Fully existing proceedings could not tak", "Books", "arts", 8.66, 2402.76, 1.197462 ] 70 -
71 [ "AAAAAAAAGOKBAAAA", "Othe", "Books", "arts", 60.94, 2242.14, 1.117414 ] 71 -
72 [ "AAAAAAAAHPNCAAAA", "Correct, certain humans cut", "Books", "arts", 37.98, 6152.65, 3.066293 ] 72 -
73 [ "AAAAAAAAIAOAAAAA", "Professional circumstances could live else others. Symptoms can see very leaves. Just personal institutions used to go. Capable workers used to play then able police.", "Books", "arts", 2.40, 2219.11, 1.105936 ] 73 -
74 [ "AAAAAAAAIEPCAAAA", "New, popular years should think. Shareholders speak also friends; special members could not identify social eyes; indoors full ", "Books", "arts", 0.91, 5462.06, 2.722124 ] 74 -
75 [ "AAAAAAAAIHKBAAAA", "Very historic arms may happen even able exis", "Books", "arts", 9.19, 8280.09, 4.126545 ] 75 -
76 [ "AAAAAAAAIIPDAAAA", "Af", "Books", "arts", 6.04, 4695.48, 2.340084 ] 76 -
77 [ "AAAAAAAAIJGAAAAA", "Then western animals could teach somewhere. Today waiting servants confuse", "Books", "arts", 4.10, 1589.42, 0.792118 ] 77 -
78 [ "AAAAAAAAJJDBAAAA", "Problems compete with a sets. Interesting, automatic pounds tell complete hills. ", "Books", "arts", 1.20, 18501.43, 9.220549 ] 78 -
79 [ "AAAAAAAAKGBAAAAA", "Light moments cannot date following sy", "Books", "arts", 5.60, 9688.12, 4.828264 ] 79 -
80 [ "AAAAAAAAKICDAAAA", "Wet, concerned representatives get up to a owners. Necessary, like", "Books", "arts", 1.89, 10823.82, 5.394262 ] 80 -
81 [ "AAAAAAAAMFFAAAAA", "Communities used to relocate clearly strange, new walls; european, rich championships make current depths. Sure studies may reflect only instinctively old forces. Foreign, diverse", "Books", "arts", 8.22, 3557.07, 1.772735 ] 81 -
82 [ "AAAAAAAANIBAAAAA", "Beneath decent wives write t", "Books", "arts", 2.72, 2235.93, 1.114319 ] 82 -
83 [ "AAAAAAAAOJJCAAAA", "Troops take only, right dogs. Briefly genuine eyes used to provide mutually coming, just parents. Too social services shall feel only rec", "Books", "arts", 6.40, 2193.52, 1.093183 ] 83 -
84 [ "AAAAAAAAOKPBAAAA", "Just good settings must not make; payments assure to a bishops. Principal, sorry amounts would safeguard very so other leaders; tory, substantial stairs m", "Books", "arts", 2.60, 5632.64, 2.807136 ] 84 -
85 [ "AAAAAAAAOPKCAAAA", "Less imp", "Books", "arts", 9.12, 1511.60, 0.753335 ] 85 -
86 [ "AAAAAAAAPIEBAAAA", "Main cheeks must put ", "Books", "arts", 0.45, 13.44, 0.006698 ] 86 -
87 [ "AAAAAAAAPLLDAAAA", "Old eyes could not give later issues. Claims might", "Books", "arts", 9.00, 4957.73, 2.470781 ] 87 -
88 [ "AAAAAAAAABMBAAAA", "Situations retain; units might sit operations; girls shall make. Ca", "Books", "business", 3.16, 905.62, 0.577071 ] 88 -
89 [ "AAAAAAAAACEBAAAA", "Prese", "Books", "business", 15.17, 5628.92, 3.586811 ] 89 -
90 [ "AAAAAAAAADFAAAAA", "Satisfactory, technical shadows get. Lexical structures would not blame. Only hard ", "Books", "business", 78.25, 9249.55, 5.893917 ] 90 -
91 [ "AAAAAAAAAKBDAAAA", "Essential students change even despite a powers. General connections will not maximi", "Books", "business", 3.10, 1162.52, 0.740770 ] 91 -
92 [ "AAAAAAAAANHCAAAA", "High ministers should not remove for a stations. Certain, linear weeks might not ask so from a improvements. Lakes must not implement f", "Books", "business", 4.80, 504.32, 0.321358 ] 92 -
93 [ "AAAAAAAABIPBAAAA", "Ultimate, other objects might not install good ", "Books", "business", 2.57, 2399.32, 1.528873 ] 93 -
94 [ "AAAAAAAABKACAAAA", "Total pp. accept with a questions; able, generous a", "Books", "business", 5.25, 6380.42, 4.065675 ] 94 -
95 [ "AAAAAAAACDBCAAAA", "Tiny years could run too above tough volumes. New germans must not leave as possible sales; inj", "Books", "business", 1.22, 5339.66, 3.402491 ] 95 -
96 [ "AAAAAAAACDIBAAAA", "Small results would go colours; sexual agencies ought to assure moreover unique premises; then complex provisions use often normal windows. Better educational girls should not believe however struct", "Books", "business", 9.78, 566.04, 0.360687 ] 96 -
97 [ "AAAAAAAACEACAAAA", "Other, direct letters ought to make from a ways. British, large men could not work a", "Books", "business", 0.48, 9562.96, 6.093626 ] 97 -
98 [ "AAAAAAAACPODAAAA", "Cells stay economic, thin members. Soon special conservatives solve to the figu", "Books", "business", 2.93, 13212.32, 8.419039 ] 98 -
99 [ "AAAAAAAADHNCAAAA", "Originally major industries matter mediterranean bodies. Cases should not ", "Books", "business", 45.06, 303.70, 0.193521 ] 99 -
100 [ "AAAAAAAADNDDAAAA", "Clear, harsh police used to include large, appropriate plans. Prices could produce more. There white weapons expect directly free conclusions. Responsibl", "Books", "business", 4.57, 3220.52, 2.052151 ] 100 -
101 [ "AAAAAAAAEICAAAAA", "Cases include proudly without a columns. Solid, pre", "Books", "business", 2.42, 7199.25, 4.587443 ] 101 -
102 [ "AAAAAAAAEILDAAAA", "Bad, able systems shall fall else. Nuclear, economic ways put in an paths. Serious, labour women must not muster however. Wide new readers ought to help ", "Books", "business", 1.36, 1349.33, 0.859808 ] 102 -
103 [ "AAAAAAAAFGJCAAAA", "Secondary, red structures may seek eyes. High true titles should make now junior fat thoughts. Partly excellent authorities receive direct, net parties. Parents look most also other issues. Empty, con", "Books", "business", 8.59, 3655.68, 2.329440 ] 103 -
104 [ "AAAAAAAAFLMDAAAA", "Significantly relevant colleges extract knowingly broad investors. Entire members stay. Mediterranean legs would cut on the knees. Forthcoming, particular students u", "Books", "business", 4.81, 1809.71, 1.153167 ] 104 -
105 [ "AAAAAAAAGFDCAAAA", "Particularly medieval blocks would not find slightly with a carers. Years respond about at a sec", "Books", "business", 6.00, 318.24, 0.202786 ] 105 -
106 [ "AAAAAAAAGONBAAAA", "Ever top offers might struggle far, automatic men. Long-term, long goods dare however; new, other gr", "Books", "business", 2.30, 1639.26, 1.044555 ] 106 -
107 [ "AAAAAAAAIBKDAAAA", "Hundreds drop nearly unacceptable accidents. Then strong methods tell large unions. Short companies should help so. Moves shall not set later chief problems. R", "Books", "business", 0.78, 1490.85, 0.949986 ] 107 -
108 [ "AAAAAAAAIINDAAAA", "Frames can park highly parents. White ma", "Books", "business", 6.97, 4313.52, 2.748623 ] 108 -
109 [ "AAAAAAAAIJECAAAA", "Difficult, royal units put particularly significant, other plans. Essential, contemporary journals will need players. Alternatively parental", "Books", "business", 4.34, 2268.00, 1.445195 ] 109 -
110 [ "AAAAAAAAIJJCAAAA", "Euro", "Books", "business", 3.01, 4889.34, 3.115542 ] 110 -
111 [ "AAAAAAAAIKEAAAAA", "All ", "Books", "business", 9.44, 182.52, 0.116303 ] 111 -
112 [ "AAAAAAAAIPADAAAA", "Orders go into the documents. Social, existing specialists will seem twice associated wishes. Finally nation", "Books", "business", 5.15, 242.88, 0.154765 ] 112 -
113 [ "AAAAAAAAJMEDAAAA", "Personal, significant activities agree only by a couples. Elaborate aut", "Books", "business", 3.06, 85.26, 0.054328 ] 113 -
114 [ "AAAAAAAAKAJDAAAA", "Short neighbours implement innocently tiny titles. Briefly simple years should not tell potentially successful, whole years. Orange workers carry; home hot feet l", "Books", "business", 4.43, 4949.49, 3.153871 ] 114 -
115 [ "AAAAAAAAKAKAAAAA", "Still urban stages shall not take for a legs. Other, holy demands pay further young, positive numbers. A little criminal i", "Books", "business", 7.68, 9959.06, 6.346025 ] 115 -
116 [ "AAAAAAAAKMAAAAAA", "Plans consult interested, light boys. Selective, other problems create scientific, young parties. Sufficient speakers might not kiss too social, basic interests. Dual, other times s", "Books", "business", 0.19, 910.16, 0.579964 ] 116 -
117 [ "AAAAAAAALDFAAAAA", "Hands may not allow only in a lands; linear, other pubs say; social, precise women identify for a patients. Preferences develop alone now rich motives. Ever good tas", "Books", "business", 3.68, 1816.45, 1.157462 ] 117 -
118 [ "AAAAAAAALGBBAAAA", "Modern records retain about there civil plans. Social bodies survive. Great, living losses bother late, coherent others. About british sports ought to use cautiously from ", "Books", "business", 1.94, 1252.09, 0.797845 ] 118 -
119 [ "AAAAAAAAMALDAAAA", "Here final difficulties would not comply just legal good motives. Enough sensitive things could not spend obviously with a systems. In pu", "Books", "business", 91.76, 356.85, 0.227388 ] 119 -
120 [ "AAAAAAAAMIGCAAAA", "Carefully physical hotels must put together; similar details cannot appreciate by a standards. Rates can break m", "Books", "business", 6.63, 562.96, 0.358724 ] 120 -
121 [ "AAAAAAAAMIMCAAAA", "About likely houses like international members. Final, relevant birds answer after the paintings. Hungry, personal days borrow tiny, primary resources. As social relations could choose quite also ", "Books", "business", 0.77, 2889.22, 1.841043 ] 121 -
122 [ "AAAAAAAAMKHAAAAA", "Unions shall see enough over true attitudes; of course full variable", "Books", "business", 8.90, 15263.90, 9.726329 ] 122 -
123 [ "AAAAAAAAMKNDAAAA", "Special, clear elements would buy at a games. Things should spot today strange, only devices. Armies should like at a patients. Hands could perform simply narrow values. N", "Books", "business", 1.28, 1069.76, 0.681663 ] 123 -
124 [ "AAAAAAAANACBAAAA", "New teachers might demand never assets. Deeply bright ministers make generally never prime imports. Odd writings step common readers; talks take young, r", "Books", "business", 2.95, 3975.16, 2.533016 ] 124 -
125 [ "AAAAAAAAPDNAAAAA", "Local, unlikely bits sign completely. Areas feel only manufacturing legs. Amounts must go personal, very things; areas could take clo", "Books", "business", 5.20, 3545.37, 2.259149 ] 125 -
126 [ "AAAAAAAAPEKCAAAA", "Alone countries must use so old, international functions. Only public cases see in a words. Normal methods forget even communist changes; technical numbers convert either natu", "Books", "business", 4.67, 3899.62, 2.484882 ] 126 -
127 [ "AAAAAAAAPGDBAAAA", "Certainly remaining flowers can wonder then just significant papers; places secure below as a bombs. Other, domestic members must allow very polite thi", "Books", "business", 0.60, 12462.77, 7.941418 ] 127 -
128 [ "AAAAAAAAPHJAAAAA", "Possibly great customs suit close looks. Capable, frequent processes shall pass possible dangers; hard, private words act measures. Mysterious, acceptable fac", "Books", "business", 6.64, 6141.24, 3.913267 ] 128 -
129 [ "AAAAAAAAAALDAAAA", "Forward liable funds may not end from time to time local, domestic chiefs. Major, well-known newspapers can regain together new, white conclusions. Very vital employees can draw", "Books", "computers", 17.54, 588.01, 0.311079 ] 129 -
130 [ "AAAAAAAAAHKDAAAA", "Decisions play actually exclusive activities. Well assistant e", "Books", "computers", 8.77, 1619.66, 0.856861 ] 130 -
131 [ "AAAAAAAAAKGDAAAA", "Tonnes could use slowly off a servants. Initial letters must walk now companies; rapid, previous towns put here large, prime needs. Historical, negative grou", "Books", "computers", 0.19, 3319.10, 1.755930 ] 131 -
132 [ "AAAAAAAAAOBCAAAA", "Years should try in line with a conditions. Pp. spend well evenings. Other, afraid sides speculate at a years. Options ought to know leading, app", "Books", "computers", 5.23, 8468.08, 4.479937 ] 132 -
133 [ "AAAAAAAABHEEAAAA", "Subjects may remain officials. Forward, straight objects used to see wh", "Books", "computers", 6.97, 13658.40, 7.225814 ] 133 -
134 [ "AAAAAAAABLMBAAAA", "External improvements effect so tough words. Great roads cause quickly popular, black stories. Clearly white members might ask enough details. Min", "Books", "computers", 31.74, 4154.04, 2.197645 ] 134 -
135 [ "AAAAAAAACHOCAAAA", "Final governm", "Books", "computers", 6.22, 5102.98, 2.699671 ] 135 -
136 [ "AAAAAAAACOHDAAAA", "Left, important sports shall get on an specialists. Overall, e", "Books", "computers", 3.56, 14321.37, 7.576550 ] 136 -
137 [ "AAAAAAAAEANCAAAA", "Ye", "Books", "computers", 9.75, 1367.76, 0.723597 ] 137 -
138 [ "AAAAAAAAEAPAAAAA", "Just distinct children think individuals; popular arguments develop here cautious methods; appropriate children might beat. Proper, empirical hundreds fall oth", "Books", "computers", 4.01, 328.50, 0.173789 ] 138 -
139 [ "AAAAAAAAEDMAAAAA", "Books understand. Principles produce just at a premises. Years ", "Books", "computers", 44.48, 188.86, 0.099914 ] 139 -
140 [ "AAAAAAAAFEEAAAAA", "Capital, united feelings paint only things. Greatly financial economies should not pay somewhere soviet necessary armies; educational concepts mus", "Books", "computers", 3.83, 812.19, 0.429679 ] 140 -
141 [ "AAAAAAAAFLFEAAAA", "Social weeks may hope. However parental objects shall get just potential logical stations. Agreements attend on a arms; circa real reforms may interpret dogs. T", "Books", "computers", 2.06, 449.61, 0.237860 ] 141 -
142 [ "AAAAAAAAGENAAAAA", "Genera", "Books", "computers", 2.84, 950.58, 0.502893 ] 142 -
143 [ "AAAAAAAAGHCBAAAA", "Hundreds would meet regardless german, foreign scien", "Books", "computers", 9.77, 1969.60, 1.041993 ] 143 -
144 [ "AAAAAAAAGNGBAAAA", "Brilliant, massive prisons take still national others. Only northern guidelines go right by the lips. General, spiritual walls shall reach in a languages. British nations eat substantial polici", "Books", "computers", 3.42, 377.26, 0.199584 ] 144 -
145 [ "AAAAAAAAHPADAAAA", "Used, young sizes take requirements. Electoral, standard stones worry still private scenes. Major, still bedrooms say all once effective years. Long new moments will own after the", "Books", "computers", 9.19, 690.90, 0.365512 ] 145 -
146 [ "AAAAAAAAIAMAAAAA", "Alone walls mus", "Books", "computers", 2.00, 4530.16, 2.396627 ] 146 -
147 147 -
148 # 18:29:57 > 148 -
149 # 18:29:57 > "Done." 149 -
150 # 18:29:57 > 150 -