Test 72.sql (id 350cc55cd57a) (err)
72.stable.out.FILTERED 2018-12-07 00:44:55.701357993 +010072.test.out.FILTERED 2018-12-07 00:44:55.703357973 +0100
+ 1 Statistics about stdout of test '72` in directory 'sql/benchmarks/tpcds`: 1
+ 2 106 lines, 2115 words, 12534 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 106 lines, 2115 words, 12534 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 153 lines, 2321 words, 14202 chars in all lines 4
+ 5 5
+ 6 stdout of test '72` in directory 'sql/benchmarks/tpcds` itself: 6
+ 7 7
+ 8 8
+ 9 # 00:44:55 > 9
+ 10 # 00:44:55 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=32982" "--set" "mapi_usock=/var/tmp/mtest-16472/.s.monetdb.32982" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/350cc55cd57a-6-1-2/tests/sql/dbfarm/mTests_sql_benchmarks_tpcds" "--set" "embedded_c=true" 10
+ 11 # 00:44:55 > 11
+ 12 12
+ 13 # MonetDB 5 server v11.32.0 13
+ 14 # This is an unreleased version 14
+ 15 # Serving database 'mTests_sql_benchmarks_tpcds', using 8 threads 15
+ 16 # Compiled for x86_64-redhat-linux-gnu/64bit 16
+ 17 # Found 31.375 GiB available main-memory. 17
+ 18 # Copyright (c) 1993 - July 2008 CWI. 18
+ 19 # Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved 19
+ 20 # Visit https://www.monetdb.org/ for further information 20
+ 21 # Listening for connection requests on mapi:monetdb://lab05.da.cwi.nl:32982/ 21
+ 22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-16472/.s.monetdb.32982 22
+ 23 # MonetDB/GIS module loaded 23
+ 24 # MonetDB/SQL module loaded 24
+ 25 25
+ 26 Ready. 26
+ 27 27
+ 28 # 00:44:55 > 28
+ 29 # 00:44:55 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16472" "--port=32982" 29
+ 30 # 00:44:55 > 30
+ 31 31
+ 32 #SELECT i_item_desc, 32
+ 33 # w_warehouse_name, 33
+ 34 # d1.d_week_seq, 34
+ 35 # sum(CASE 35
+ 36 # WHEN p_promo_sk IS NULL THEN 1 36
+ 37 # ELSE 0 37
+ 38 # END) no_promo, 38
+ 39 # sum(CASE 39
+ 40 # WHEN p_promo_sk IS NOT NULL THEN 1 40
+ 41 # ELSE 0 41
+ 42 # END) promo, 42
+ 43 # count(*) total_cnt 43
+ 44 #FROM catalog_sales 44
+ 45 #JOIN inventory ON (cs_item_sk = inv_item_sk) 45
+ 46 #JOIN warehouse ON (w_warehouse_sk=inv_warehouse_sk) 46
+ 47 #JOIN item ON (i_item_sk = cs_item_sk) 47
+ 48 #JOIN customer_demographics ON (cs_bill_cdemo_sk = cd_demo_sk) 48
+ 49 % .item, .warehouse, .d1, ., ., . # table_name 49
+ 50 # .item, .warehouse, .d1, .L6, .L11, .L14 # table_name 50
+ 51 % i_item_desc, w_warehouse_name, d_week_seq, no_promo, promo, total_cnt # name 51
+ 52 % varchar, varchar, int, bigint, bigint, bigint # type 52
+ 53 % 197, 20, 4, 1, 1, 1 # length 53
+ 54 [ "Best possible ages tell together new, st", "Conventional childr", 5213, 0, 2, 2 ] 54
+ 55 [ "Closed, good condition", "Doors canno", 5169, 0, 2, 2 ] 55
+ 56 [ "Departments make once again police. Very acceptable results call still extended, known ends; relationships shoot strangely. Acids shall discharge in order ethnic, ric", NULL, 5168, 0, 2, 2 ] 56
+ 57 [ "Futures should enjoy able galleries. Late blue tickets pass longer urgently dead types. Shoulders will see rigidly institutions. Other con", "Conventional childr", 5210, 0, 2, 2 ] 57
+ 58 [ "Good, open studies dream more; industrial, social organisations could understand recently quick tall theories. Lines must answer functions; subtle factor", "Important issues liv", 5214, 0, 2, 2 ] 58
+ 59 [ "Hard sudden aspects shall not commemorate about a functions. Western, british cases see here churches. Stairs a", "Doors canno", 5212, 0, 2, 2 ] 59
+ 60 [ "High, essential groups should not weigh more other years; there different papers could announce; large departments c", "Important issues liv", 5198, 0, 2, 2 ] 60
+ 61 [ "Just young partie", "Important issues liv", 5213, 0, 2, 2 ] 61
+ 62 [ "Levels undermine unfortunately efficient weeks", NULL, 5210, 0, 2, 2 ] 62
+ 63 [ "New, full rises drive however. Legs retain often in a women. Remaining, parliamentary miles may help nevertheless rather full pupils. Glad crimes might", "Bad cards must make.", 5217, 0, 2, 2 ] 63
+ 64 [ "Provisions go too. Sad others contain italian branches. Keys k", "Bad cards must make.", 5213, 0, 2, 2 ] 64
+ 65 [ "Provisions go too. Sad others contain italian branches. Keys k", "Doors canno", 5213, 0, 2, 2 ] 65
+ 66 [ "Shortly desperate nat", "Conventional childr", 5210, 0, 2, 2 ] 66
+ 67 [ "True tears continue currently pale, close men. Soon medical numbers might not take other, ", "Important issues liv", 5199, 0, 2, 2 ] 67
+ 68 [ "Very, new trends should not des", "Important issues liv", 5213, 0, 2, 2 ] 68
+ 69 [ "White employees name; figures feed sure. Speeches can achieve. Extremely final seats may exist too all religious studies. Medite", "Bad cards must make.", 5168, 0, 2, 2 ] 69
+ 70 [ "Words use up a documents. Collections may", "Conventional childr", 5168, 0, 2, 2 ] 70
+ 71 [ "Words use up a documents. Collections may", "Important issues liv", 5168, 0, 2, 2 ] 71
+ 72 [ NULL, NULL, 5175, 0, 1, 1 ] 72
+ 73 [ NULL, NULL, 5217, 0, 1, 1 ] 73
+ 74 [ NULL, "Doors canno", 5175, 0, 1, 1 ] 74
+ 75 [ NULL, "Doors canno", 5207, 0, 1, 1 ] 75
+ 76 [ NULL, "Important issues liv", 5205, 0, 1, 1 ] 76
+ 77 [ "A little average flames ought to break old, unique men. Things select often red, economic others. Hands will lift sufficiently; german, proper sections worry perhaps for the po", NULL, 5212, 0, 1, 1 ] 77
+ 78 [ "Abilities would not require almost; local", "Bad cards must make.", 5197, 0, 1, 1 ] 78
+ 79 [ "Able", "Conventional childr", 5177, 0, 1, 1 ] 79
+ 80 [ "Able hands help however inevitable policemen. Far true matters will not forgive never hands. Absolutely french events stop now. Well able procedures unde", "Conventional childr", 5195, 0, 1, 1 ] 80
+ 81 [ "Able hands help however inevitable policemen. Far true matters will not forgive never hands. Absolutely french events stop now. Well able procedures unde", "Doors canno", 5195, 0, 1, 1 ] 81
+ 82 [ "Able, alternative police shall not give so other complaints. There complex ", NULL, 5212, 0, 1, 1 ] 82
+ 83 [ "Able, long mammals can want new, serious years. Questions would not cope again mainly unable contributions. Less responsible shelves lose records; leading, similar ", "Important issues liv", 5170, 0, 1, 1 ] 83
+ 84 [ "Able, main parties think really. Resources arrive only independent, old representations. Small, double advantages ", "Doors canno", 5213, 0, 1, 1 ] 84
+ 85 [ "Able, main parties think really. Resources arrive only independent, old representations. Small, double advantages ", "Important issues liv", 5180, 0, 1, 1 ] 85
+ 86 [ "About international concentrations could avoid then alone apparent activities; inadequate, mediterranean days get eve", "Important issues liv", 5215, 0, 1, 1 ] 86
+ 87 [ "About natural economie", "Bad cards must make.", 5202, 0, 1, 1 ] 87
+ 88 [ "About other levels should proceed certainly fine, severe facts.", "Important issues liv", 5210, 0, 1, 1 ] 88
+ 89 [ "About working feelings could produce only types. Electoral, new visitors will not make more afraid, large tr", NULL, 5197, 0, 1, 1 ] 89
+ 90 [ "Absolutely", "Bad cards must make.", 5203, 0, 1, 1 ] 90
+ 91 [ "Absolutely", "Doors canno", 5203, 0, 1, 1 ] 91
+ 92 [ "Absolutely ", NULL, 5206, 0, 1, 1 ] 92
+ 93 [ "Absolutely front men turn spatial hours. Good, free sales used to marry outside appropriate ships. Noble men sa", NULL, 5207, 0, 1, 1 ] 93
+ 94 [ "Absolutely old payments will b", "Doors canno", 5216, 0, 1, 1 ] 94
+ 95 [ "Abstract, red patterns return definitely police; different studies wear mainly pr", "Conventional childr", 5210, 0, 1, 1 ] 95
+ 96 [ "Accused men cannot increase e", "Important issues liv", 5207, 0, 1, 1 ] 96
+ 97 [ "Acids grab below previous standards. Ever large metals will come on a articles. Underlying stories protect at last. Reasonable directions believe rather due to a", "Bad cards must make.", 5169, 0, 1, 1 ] 97
+ 98 [ "Active plants need necessary, widespread roads. Best back visits hold regularly fresh friend", NULL, 5209, 0, 1, 1 ] 98
+ 99 [ "Active plants need necessary, widespread roads. Best back visits hold regularly fresh friend", "Conventional childr", 5209, 0, 1, 1 ] 99
+ 100 [ "Active values may not capture. Casually political minutes would recognis", "Conventional childr", 5200, 0, 1, 1 ] 100
+ 101 [ "Active windows shall not find small, relig", "Conventional childr", 5203, 0, 1, 1 ] 101
+ 102 [ "Actively different proceedings light yet so similar houses. Good circumstances shall not take only levels. Then moral pounds will clean very only national organisations. ", NULL, 5183, 0, 1, 1 ] 102
+ 103 [ "Activities say. Right lips resort current techniques. Regional, possible daughters might not present changes; students can notice ridiculous, l", "Conventional childr", 5192, 0, 1, 1 ] 103
+ 104 [ "Acts", "Bad cards must make.", 5218, 0, 1, 1 ] 104
+ 105 [ "Acts", "Conventional childr", 5218, 0, 1, 1 ] 105
+ 106 [ "Actual, grey hands giv", NULL, 5214, 0, 1, 1 ] 106
+ 107 [ "Actually correct presents will fill else double, useful operations. African, external penalties will", NULL, 5180, 0, 1, 1 ] 107
+ 108 [ "Acute, important performances afford. New, nuclear men used to assess again small results.", NULL, 5187, 0, 1, 1 ] 108
+ 109 [ "Added, similar grounds spend also concrete terms. Fellow, mass", "Important issues liv", 5206, 0, 1, 1 ] 109
+ 110 [ "Additional responses will", "Conventional childr", 5209, 0, 1, 1 ] 110
+ 111 [ "Additional, terrible characters shall examine. Ago lexical conditions get into a weeks. Barely trying results perform still hot men. Great kinds end also committees. Police should live only on the ", "Doors canno", 5216, 0, 1, 1 ] 111
+ 112 [ "Additional, terrible characters shall examine. Ago lexical conditions get into a weeks. Barely trying results perform still hot men. Great kinds end also committees. Police should live only on the ", "Important issues liv", 5214, 0, 1, 1 ] 112
+ 113 [ "Adequate things reassure unknown legs. Old, possible bishops shall locate else during a companies; bitter, alone ", "Bad cards must make.", 5206, 0, 1, 1 ] 113
+ 114 [ "Adequately unemployed aspects ought to keep on a years. Years get somewhere sometimes late examples; laws must shape determined stones. Recently real decisions may cost now other female thousands. ", "Conventional childr", 5214, 0, 1, 1 ] 114
+ 115 [ "Adequately unemployed aspects ought to keep on a years. Years get somewhere sometimes late examples; laws must shape determined stones. Recently real decisions may cost now other female thousands. ", "Important issues liv", 5214, 0, 1, 1 ] 115
+ 116 [ "Adults throw close recent women. Orange, guilty libraries let earnings. Initiatives ought to walk. Simple, successful states might work eventually full orders. Formerly very ", NULL, 5206, 0, 1, 1 ] 116
+ 117 [ "Adults throw close recent women. Orange, guilty libraries let earnings. Initiatives ought to walk. Simple, successful states might work eventually full orders. Formerly very ", "Bad cards must make.", 5206, 0, 1, 1 ] 117
+ 118 [ "Advanced, certain fields miss electronically for the books. Open measures match therefore s", "Doors canno", 5196, 0, 1, 1 ] 118
+ 119 [ "Advanced, certain fields miss electronically for the books. Open measures match therefore s", "Important issues liv", 5210, 0, 1, 1 ] 119
+ 120 [ "Advantages go small. Organisers could make of course like a problems; probably reasonable humans shall attract categories. Agencies will enable much heavy matters. Stair", NULL, 5206, 0, 1, 1 ] 120
+ 121 [ "Advantages go small. Organisers could make of course like a problems; probably reasonable humans shall attract categories. Agencies will enable much heavy matters. Stair", "Doors canno", 5186, 0, 1, 1 ] 121
+ 122 [ "Advantages go small. Organisers could make of course like a problems; probably reasonable humans shall attract categories. Agencies will enable much heavy matters. Stair", "Important issues liv", 5186, 0, 1, 1 ] 122
+ 123 [ "Afraid years suspend much building", NULL, 5171, 0, 1, 1 ] 123
+ 124 [ "Afraid, grey officers mean costly institutions. Societi", "Conventional childr", 5199, 0, 1, 1 ] 124
+ 125 [ "Afraid, old meals will get chronic, strong applicants. Arms could look with a needs. Hence wor", "Important issues liv", 5210, 0, 1, 1 ] 125
+ 126 [ "Afraid, southern problems need according to a dec", "Conventional childr", 5207, 0, 1, 1 ] 126
+ 127 [ "Afraid, southern problems need according to a dec", "Important issues liv", 5207, 0, 1, 1 ] 127
+ 128 [ "Again available bags breathe good circumstances. Thus final cases must ", NULL, 5211, 0, 1, 1 ] 128
+ 129 [ "Again available bags breathe good circumstances. Thus final cases must ", "Bad cards must make.", 5214, 0, 1, 1 ] 129
+ 130 [ "Again available bags breathe good circumstances. Thus final cases must ", "Conventional childr", 5218, 0, 1, 1 ] 130
+ 131 [ "Again available bags breathe good circumstances. Thus final cases must ", "Important issues liv", 5211, 0, 1, 1 ] 131
+ 132 [ "Again judicial colours may blame fully british strange groups. Rules shall cover probably participants. W", NULL, 5214, 0, 1, 1 ] 132
+ 133 [ "Again small deaths could flou", "Bad cards must make.", 5175, 0, 1, 1 ] 133
+ 134 [ "Agencies shall not consider false in a others. Obviously interesting authorities come anyway men. Small, ", "Important issues liv", 5206, 0, 1, 1 ] 134
+ 135 [ "Agents see companies. Weekly clergy might not enable always mere studies. Men throw possible relations. Then static rights wr", "Conventional childr", 5209, 0, 1, 1 ] 135
+ 136 [ "Ago foreign writings leave; even considerable artists let fully then minimal workers. Clear ministers keep. Specifically dry men increase central tests. Living, alternative meanings ought", "Important issues liv", 5180, 0, 1, 1 ] 136
+ 137 [ "Ago regional objects finish courts. Large, serio", "Bad cards must make.", 5187, 0, 1, 1 ] 137
+ 138 [ "Agricultural, difficult engines marry according to the things; instances shall not go however quietly statutory images. Still sharp patients work no doubt producers. Magazines ", "Doors canno", 5210, 0, 1, 1 ] 138
+ 139 [ "Agricultural, selective groups follow much worthwhile panels. Fully sim", "Bad cards must make.", 5207, 0, 1, 1 ] 139
+ 140 [ "Aims play already", "Doors canno", 5198, 0, 1, 1 ] 140
+ 141 [ "Al", NULL, 5167, 0, 1, 1 ] 141
+ 142 [ "All ", "Bad cards must make.", 5175, 0, 1, 1 ] 142
+ 143 [ "All ", "Important issues liv", 5210, 0, 1, 1 ] 143
+ 144 [ "All numerous reasons explain upper teachers; necessary, inte", "Bad cards must make.", 5181, 0, 1, 1 ] 144
+ 145 [ "All realistic employees should attempt all only expert parties. Complete days cannot come as possible rules. Normal candidates would not pay there improved, o", "Doors canno", 5204, 0, 1, 1 ] 145
+ 146 [ "All right deliberate difficulties wait still between a seats; final, actual jobs may mee", "Bad cards must make.", 5212, 0, 1, 1 ] 146
+ 147 [ "All right deliberate difficulties wait still between a seats; final, actual jobs may mee", "Conventional childr", 5174, 0, 1, 1 ] 147
+ 148 [ "All right used men must demand. Visual companies take entirely inhabitants; forward common hands hear here local customers. So traditional questions shal", "Doors canno", 5188, 0, 1, 1 ] 148
+ 149 [ "Alm", "Important issues liv", 5204, 0, 1, 1 ] 149
+ 150 [ "Almost armed animals will maintain always pure, professional days; differe", "Conventional childr", 5175, 0, 1, 1 ] 150
+ 151 [ "Almost armed animals will maintain always pure, professional days; differe", "Doors canno", 5175, 0, 1, 1 ] 151
+ 152 [ "Almost armed animals will maintain always pure, professional days; differe", "Important issues liv", 5175, 0, 1, 1 ] 152
+ 153 [ "Almost low provisions suggest to", "Conventional childr", 5211, 0, 1, 1 ] 153
+ 154 154
+ 155 # 00:44:55 > 155
+ 156 # 00:44:55 > "Done." 156
+ 157 # 00:44:55 > 157
+ 158 158