Test 12.sql (id 3c6cbe78e1fe) (err)
12.stable.out.int128.FILTERED 2019-09-08 12:55:59.004272248 +020012.test.out.FILTERED 2019-09-08 12:55:59.005272239 +0200
1 Statistics about stdout of test '12` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '12` in directory 'sql/benchmarks/tpcds`: 1
2 105 lines, 2366 words, 17699 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 105 lines, 2366 words, 17699 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 147 lines, 2550 words, 19271 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 # 12:55:48 > 26
+ 27 # 12:55:48 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-19955" "--port=34400" 27
+ 28 # 12:55:48 > 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 # 12:55:59 > 31
29 # 18:29:57 > 29 ! 32 # 12:55:59 > "Done." 32
30 30 ! 33 # 12:55:59 > 33
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(ws_ext_sales_price) AS itemrevenue, 36 -
37 # sum(ws_ext_sales_price)*100.0000/sum(sum(ws_ext_sales_price)) OVER (PARTITION BY i_class) AS revenueratio 37 -
38 #FROM web_sales, 38 -
39 # item, 39 -
40 # date_dim 40 -
41 #WHERE ws_item_sk = i_item_sk 41 -
42 # AND i_category IN ('Sports', 42 -
43 % sys.item, sys.item, sys.item, sys.item, sys.item, sys., sys. # table_name 43 -
44 # sys.item, sys.item, sys.item, sys.item, sys.item, sys.L12, sys.L21 # table_name 44 -
45 % i_item_id, i_item_desc, i_category, i_class, i_current_price, itemrevenue, revenueratio # name 45 -
46 % char, varchar, char, char, decimal, decimal, decimal # type 46 -
47 % 16, 200, 50, 50, 9, 40, 40 # length 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, 2742.60, 3.717520 ] 48 -
49 [ "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, 4258.84, 5.772743 ] 49 -
50 [ "AAAAAAAACKEAAAAA", "Legs appear eventually soci", "Books", "arts", 35.27, 4010.65, 5.436328 ] 50 -
51 [ "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, 1156.40, 1.567469 ] 51 -
52 [ "AAAAAAAACNEDAAAA", "Particularly labour stores get farmers. Hence true records see rel", "Books", "arts", 6.89, 6606.82, 8.955366 ] 52 -
53 [ "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, 10391.81, 14.085818 ] 53 -
54 [ "AAAAAAAADJFCAAAA", "Significant, preliminary boys can remain lightly more pale discussion", "Books", "arts", 2.74, 8279.54, 11.222693 ] 54 -
55 [ "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, 351.78, 0.476828 ] 55 -
56 [ "AAAAAAAAEDKDAAAA", "Times live now to a sales. British years bring all financ", "Books", "arts", 4.24, 11699.92, 15.858926 ] 56 -
57 [ "AAAAAAAAEGAEAAAA", "Far injuries pay so various arms. Courses could go anywhere universal possibilities; talks stand since mean, colonial scho", "Books", "arts", 9.57, 51.84, 0.070267 ] 57 -
58 [ "AAAAAAAAFCFBAAAA", "Golden estates meet as yet hands. About solid proteins used to tell. Once causal boots imagine frequently new elections; flexible, other ways find re", "Books", "arts", 9.76, 59.01, 0.079986 ] 58 -
59 [ "AAAAAAAAGHOBAAAA", "Fully existing proceedings could not tak", "Books", "arts", 8.66, 625.65, 0.848051 ] 59 -
60 [ "AAAAAAAAIEPCAAAA", "New, popular years should think. Shareholders speak also friends; special members could not identify social eyes; indoors full ", "Books", "arts", 0.91, 1390.83, 1.885232 ] 60 -
61 [ "AAAAAAAAIHKBAAAA", "Very historic arms may happen even able exis", "Books", "arts", 9.19, 13439.76, 18.217232 ] 61 -
62 [ "AAAAAAAAIIPDAAAA", "Af", "Books", "arts", 6.04, 109.23, 0.148058 ] 62 -
63 [ "AAAAAAAAIJGAAAAA", "Then western animals could teach somewhere. Today waiting servants confuse", "Books", "arts", 4.10, 868.50, 1.177228 ] 63 -
64 [ "AAAAAAAAKKIAAAAA", "Naked, popular schemes campaign then offices. Underlying shares may join", "Books", "arts", 79.28, 1841.04, 2.495480 ] 64 -
65 [ "AAAAAAAAKNBCAAAA", "Early, powerful towns add mainly english savings. Years assist then new, public colleagues. Things might encounter then right new features", "Books", "arts", 6.89, 365.60, 0.495560 ] 65 -
66 [ "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, 5525.16, 7.489205 ] 66 -
67 [ "AAAAAAAAABMBAAAA", "Situations retain; units might sit operations; girls shall make. Ca", "Books", "business", 3.16, 1204.56, 0.968965 ] 67 -
68 [ "AAAAAAAAACEBAAAA", "Prese", "Books", "business", 15.17, 17499.32, 14.076710 ] 68 -
69 [ "AAAAAAAAAKBDAAAA", "Essential students change even despite a powers. General connections will not maximi", "Books", "business", 3.10, 84.80, 0.068214 ] 69 -
70 [ "AAAAAAAABIPBAAAA", "Ultimate, other objects might not install good ", "Books", "business", 2.57, 7199.93, 5.791729 ] 70 -
71 [ "AAAAAAAABKACAAAA", "Total pp. accept with a questions; able, generous a", "Books", "business", 5.25, 3702.38, 2.978248 ] 71 -
72 [ "AAAAAAAABMDDAAAA", "Head facts resolve even. Characteristics put. Toxic, genuine officials shall not meet. Difficult chil", "Books", "business", 3.85, 333.90, 0.268594 ] 72 -
73 [ "AAAAAAAACDBCAAAA", "Tiny years could run too above tough volumes. New germans must not leave as possible sales; inj", "Books", "business", 1.22, 799.89, 0.643443 ] 73 -
74 [ "AAAAAAAACEPBAAAA", "Long, married artists would see negative feelings. Emot", "Books", "business", 1.73, 2686.56, 2.161108 ] 74 -
75 [ "AAAAAAAACPODAAAA", "Cells stay economic, thin members. Soon special conservatives solve to the figu", "Books", "business", 2.93, 2431.81, 1.956183 ] 75 -
76 [ "AAAAAAAADHNCAAAA", "Originally major industries matter mediterranean bodies. Cases should not ", "Books", "business", 45.06, 2186.10, 1.758530 ] 76 -
77 [ "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, 293.23, 0.235878 ] 77 -
78 [ "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, 3319.89, 2.670568 ] 78 -
79 [ "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, 347.70, 0.279694 ] 79 -
80 [ "AAAAAAAAFNOCAAAA", "Wonderful systems ask also very parliamentary orders; british companies", "Books", "business", 87.12, 105.98, 0.085251 ] 80 -
81 [ "AAAAAAAAGFDCAAAA", "Particularly medieval blocks would not find slightly with a carers. Years respond about at a sec", "Books", "business", 6.00, 51.40, 0.041346 ] 81 -
82 [ "AAAAAAAAGONBAAAA", "Ever top offers might struggle far, automatic men. Long-term, long goods dare however; new, other gr", "Books", "business", 2.30, 1233.76, 0.992454 ] 82 -
83 [ "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, 1158.21, 0.931681 ] 83 -
84 [ "AAAAAAAAIJECAAAA", "Difficult, royal units put particularly significant, other plans. Essential, contemporary journals will need players. Alternatively parental", "Books", "business", 4.34, 10631.67, 8.552271 ] 84 -
85 [ "AAAAAAAAIKEAAAAA", "All ", "Books", "business", 9.44, 2.07, 0.001665 ] 85 -
86 [ "AAAAAAAAIPADAAAA", "Orders go into the documents. Social, existing specialists will seem twice associated wishes. Finally nation", "Books", "business", 5.15, 1755.92, 1.412487 ] 86 -
87 [ "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, 17638.20, 14.188427 ] 87 -
88 [ "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, 3867.73, 3.111258 ] 88 -
89 [ "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, 470.96, 0.378847 ] 89 -
90 [ "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, 229.35, 0.184492 ] 90 -
91 [ "AAAAAAAALPDCAAAA", "So small edges will understand currently in a things. New trains point usually systems. Years look growing questions. Different cases could sell just alive, late rules; big, large results will make ", "Books", "business", 4.12, 6151.95, 4.948718 ] 91 -
92 [ "AAAAAAAAMIGCAAAA", "Carefully physical hotels must put together; similar details cannot appreciate by a standards. Rates can break m", "Books", "business", 6.63, 25528.76, 20.535709 ] 92 -
93 [ "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, 417.22, 0.335617 ] 93 -
94 [ "AAAAAAAAMKHAAAAA", "Unions shall see enough over true attitudes; of course full variable", "Books", "business", 8.90, 633.16, 0.509323 ] 94 -
95 [ "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, 11196.30, 9.006468 ] 95 -
96 [ "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, 1151.28, 0.926106 ] 96 -
97 [ "AAAAAAAAAHKDAAAA", "Decisions play actually exclusive activities. Well assistant e", "Books", "computers", 8.77, 822.69, 0.984914 ] 97 -
98 [ "AAAAAAAABHEEAAAA", "Subjects may remain officials. Forward, straight objects used to see wh", "Books", "computers", 6.97, 5663.04, 6.779725 ] 98 -
99 [ "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, 9320.46, 11.158345 ] 99 -
100 [ "AAAAAAAAEDMAAAAA", "Books understand. Principles produce just at a premises. Years ", "Books", "computers", 44.48, 787.29, 0.942534 ] 100 -
101 [ "AAAAAAAAEMHAAAAA", "Boots recommend usually just local centres; c", "Books", "computers", 7.56, 765.23, 0.916124 ] 101 -
102 [ "AAAAAAAAFEEAAAAA", "Capital, united feelings paint only things. Greatly financial economies should not pay somewhere soviet necessary armies; educational concepts mus", "Books", "computers", 3.83, 78.76, 0.094290 ] 102 -
103 [ "AAAAAAAAGENAAAAA", "Genera", "Books", "computers", 2.84, 4719.74, 5.650417 ] 103 -
104 [ "AAAAAAAAGHCBAAAA", "Hundreds would meet regardless german, foreign scien", "Books", "computers", 9.77, 2451.75, 2.935206 ] 104 -
105 [ "AAAAAAAAGMBDAAAA", "Vulnerable b", "Books", "computers", 0.58, 31.86, 0.038142 ] 105 -
106 [ "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, 2248.01, 2.691291 ] 106 -
107 [ "AAAAAAAAIGCEAAAA", "Concerned numbers can attempt now particular, white friends; un", "Books", "computers", 3.38, 1297.25, 1.553052 ] 107 -
108 [ "AAAAAAAAIGJAAAAA", "Probably terrible students may go. There whole issues get academic, soviet charts. ", "Books", "computers", 4.11, 84.42, 0.101066 ] 108 -
109 [ "AAAAAAAAIILCAAAA", "At least low personnel might a", "Books", "computers", 9.13, 529.20, 0.633552 ] 109 -
110 [ "AAAAAAAAJBADAAAA", "Mean, good relations wake however strictly white possibilities. About aw", "Books", "computers", 6.42, 5473.02, 6.552235 ] 110 -
111 [ "AAAAAAAAJJGBAAAA", "Strangers gain officially enough labour problems. Overall systems may not help below lives. Heroes find just apparently generous couple", "Books", "computers", 7.15, 7846.40, 9.393618 ] 111 -
112 [ "AAAAAAAALCDAAAAA", "Clearly actual places would supply apparently only rats.", "Books", "computers", 4.34, 4611.20, 5.520474 ] 112 -
113 [ "AAAAAAAALDBBAAAA", "Mines should talk outside trees. Regular eyes encourage with an victims. Civil functions try actions. Movies fit secretly for a regions. Whole, imperial customs forget", "Books", "computers", 7.44, 5240.16, 6.273458 ] 113 -
114 [ "AAAAAAAAMJEAAAAA", "Local pro", "Books", "computers", 1.04, 843.52, 1.009852 ] 114 -
115 [ "AAAAAAAAMMDEAAAA", "Women support almost", "Books", "computers", 4.68, 1401.06, 1.677332 ] 115 -
116 [ "AAAAAAAAMNOBAAAA", "Scientific, young creditors might see for the alternativ", "Books", "computers", 6.98, 100.95, 0.120856 ] 116 -
117 [ "AAAAAAAAMOHBAAAA", "Fortunately past rules mind respectively appropriate losses. Men must develop above the sources. Mere values lis", "Books", "computers", 2.02, 5603.38, 6.708300 ] 117 -
118 [ "AAAAAAAANAJDAAAA", "Religious, delicious ways must a", "Books", "computers", 7.07, 14.55, 0.017419 ] 118 -
119 [ "AAAAAAAANFJBAAAA", "Only old doors shall wear again. Earlier high minerals might not tell better persona", "Books", "computers", 16.62, 0.00, 0.000000 ] 119 -
120 [ "AAAAAAAANHFDAAAA", "Easier strong operators could not break very; new, permanent animals ", "Books", "computers", 1.15, 2953.07, 3.535380 ] 120 -
121 [ "AAAAAAAAOBNDAAAA", "Levels undermine unfortunately efficient weeks", "Books", "computers", 2.19, 2853.36, 3.416009 ] 121 -
122 [ "AAAAAAAAPDLCAAAA", "Inc considerations should dare sales. Little, long chapters check better exciting employers. Still english unions could pull wrong shoes. Factors would kee", "Books", "computers", 70.39, 7100.08, 8.500132 ] 122 -
123 [ "AAAAAAAAPJCCAAAA", "Strong, british horses may not choose less. Results will not carry harsh workers. False claims will want over labour increases. Co", "Books", "computers", 1.05, 7745.78, 9.273157 ] 123 -
124 [ "AAAAAAAAPKOBAAAA", "Yet whole dealers p", "Books", "computers", 3.63, 2856.73, 3.420043 ] 124 -
125 [ "AAAAAAAAPLIDAAAA", "Items look somewhat new designs. Patients should solve about a officers. Minutes can act still companies. About dangerous records will not run towa", "Books", "computers", 1.43, 86.09, 0.103065 ] 125 -
126 [ "AAAAAAAAABPAAAAA", "Particularly professional women may not tell never present, distant times. Current, only weeks could hurry quite appropriate months. Little attacks waste carefully never politi", "Books", "cooking", 1.82, 6350.52, 12.317736 ] 126 -
127 [ "AAAAAAAAAJNDAAAA", "Physical, political decis", "Books", "cooking", 6.76, 0.00, 0.000000 ] 127 -
128 [ "AAAAAAAABINAAAAA", "Below invisi", "Books", "cooking", 9.59, 2547.42, 4.941083 ] 128 -
129 [ "AAAAAAAABONAAAAA", "Gains cannot cross colourful, long individuals. Drily red difficulties may not say to a plans. Very different cases ta", "Books", "cooking", 1.60, 1388.77, 2.693716 ] 129 -
130 [ "AAAAAAAACBDCAAAA", "Well independent scores fight rare changes. Scottish rights would not give; implicit, modern services like yet. Conservative, effective yards should marry about a buildings. Valid, m", "Books", "cooking", 0.50, 381.18, 0.739352 ] 130 -
131 [ "AAAAAAAAGALAAAAA", "Great, only pages might not contribute so; small components require on a films. Times find apparently. So traditional sources find conditions. Gro", "Books", "cooking", 3.40, 2359.09, 4.575790 ] 131 -
132 [ "AAAAAAAAGMMCAAAA", "Chief countries leave actually rural, other fathers. Women discover very otherwise large ministers. Slow, envi", "Books", "cooking", 7.35, 13258.98, 25.717677 ] 132 -
133 [ "AAAAAAAAGOCAAAAA", "Historical, economic lights shall stand much big, odd proposals. Rather grateful branches ought to take. Northern, high miles must ask increasingly. Once chronic", "Books", "cooking", 4.37, 3383.64, 6.563050 ] 133 -
134 [ "AAAAAAAAKCCAAAAA", "Possible schools carry primarily dual rises; important meetings could continue other passengers. More scottish things might not fall orders. Right, unable expectati", "Books", "cooking", 4.44, 4158.51, 8.066021 ] 134 -
135 [ "AAAAAAAAKEJAAAAA", "Other, atlantic regions know fast. Li", "Books", "cooking", 68.84, 5439.00, 10.549713 ] 135 -
136 [ "AAAAAAAAKJGDAAAA", "International eyes might see sales. Joint universities must not hold somewhat with a days. Perfect, profitable trials ought to seem; even pale quantities ", "Books", "cooking", 0.94, 5746.30, 11.145766 ] 136 -
137 [ "AAAAAAAALBKAAAAA", "Conditions used to test so for a spirits; open, royal provisions might not look approximate", "Books", "cooking", 36.97, 5238.71, 10.161223 ] 137 -
138 [ "AAAAAAAALIGAAAAA", "There superb accidents may strike individual results. Quiet, only forests drop as little unlikely towns. Observations can discern with a points. Substantial banks dest", "Books", "cooking", 0.88, 73.37, 0.142311 ] 138 -
139 [ "AAAAAAAAMIBCAAAA", "Views present rapidly in the relations. Average winners could fall double stations; also corresponding heroes promote direct,", "Books", "cooking", 3.17, 693.26, 1.344676 ] 139 -
140 [ "AAAAAAAAONGCAAAA", "Outcomes will become high wide, substantial clients. Sufficient, new resources weaken only over the moments. Of cour", "Books", "cooking", 1.32, 170.00, 0.329739 ] 140 -
141 [ "AAAAAAAAPNFEAAAA", "Wooden, civil fingers keep great, possible scales. Police begin ago in common responsible times. Further open fathers can believe aga", "Books", "cooking", 0.33, 367.15, 0.712139 ] 141 -
142 [ "AAAAAAAAADBDAAAA", "Upper men used to give still different girls. Proposals subsidise famous nerves. C", "Books", "entertainments", 2.21, 701.28, 1.076507 ] 142 -
143 [ "AAAAAAAAAIKCAAAA", "Troubles must know wise indicators. Kinds enter technical, new doubts. Likely, annual eyes see equivalent payments. Both inadequate feelings decide ever initial ", "Books", "entertainments", 5.04, 10130.68, 15.551214 ] 143 -
144 [ "AAAAAAAABGOBAAAA", "Japanese, long students may help very; there partial bombs must assess; intentions cannot execute most certain children; indeed necessary a", "Books", "entertainments", 5.36, 1174.34, 1.802683 ] 144 -
145 [ "AAAAAAAACIDAAAAA", "Millions might answer. Attractive rules might beat coloured volunteers. Scottis", "Books", "entertainments", 3.51, 4097.70, 6.290220 ] 145 -
146 [ "AAAAAAAADCOAAAAA", "Silly acres shall belong alike following, similar pairs. Respectively lucky newspapers shall dare. Also labour requirements can leave; pounds used to stay even only solicitors. Silver systems may de", "Books", "entertainments", 75.74, 613.76, 0.942159 ] 146 -
147 [ "AAAAAAAADGKAAAAA", "However small values ", "Books", "entertainments", 1.49, 3795.87, 5.826892 ] 147 -
148 148 -
149 # 18:31:46 > 149 -
150 # 18:31:46 > "Done." 150 -
151 # 18:31:46 > 151 -
152 152 34 34