Test 99.sql (id 001aedfec00f) (err)
99.stable.out.FILTERED 2018-12-06 00:30:05.000000000 +010099.test.out.FILTERED 2018-12-06 00:30:05.000000000 +0100
+ 1 Statistics about stdout of test '99` in directory 'sql/benchmarks/tpcds`: 1
+ 2 96 lines, 1204 words, 6588 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 96 lines, 1204 words, 6588 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 141 lines, 1423 words, 8280 chars in all lines 4
+ 5 5
+ 6 stdout of test '99` in directory 'sql/benchmarks/tpcds` itself: 6
+ 7 7
+ 8 8
+ 9 # 00:30:04 > 9
+ 10 # 00:30:04 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=32114" "--set" "mapi_usock=/var/tmp/mtest-46502/.s.monetdb.32114" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/Users/monet/scratch/001aedfec00f-7-1-1/tests/sql/dbfarm/mTests_sql_benchmarks_tpcds" "--set" "embedded_c=true" 10
+ 11 # 00:30:04 > 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 4 threads 15
+ 16 # Compiled for x86_64-apple-darwin17.7.0/64bit with 128bit integers 16
+ 17 # Found 16.000 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://mac-mini.testweb.private:32114/ 21
+ 22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-46502/.s.monetdb.32114 22
+ 23 # MonetDB/GIS module loaded 23
+ 24 # MonetDB/SQL module loaded 24
+ 25 25
+ 26 Ready. 26
+ 27 27
+ 28 # 00:30:04 > 28
+ 29 # 00:30:04 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-46502" "--port=32114" 29
+ 30 # 00:30:04 > 30
+ 31 31
+ 32 #SELECT w_substr , 32
+ 33 # sm_type , 33
+ 34 # cc_name , 34
+ 35 # sum(CASE 35
+ 36 # WHEN (cs_ship_date_sk - cs_sold_date_sk <= 30) THEN 1 36
+ 37 # ELSE 0 37
+ 38 # END) AS "30 days", 38
+ 39 # sum(CASE 39
+ 40 # WHEN (cs_ship_date_sk - cs_sold_date_sk > 30) 40
+ 41 # AND (cs_ship_date_sk - cs_sold_date_sk <= 60) THEN 1 41
+ 42 # ELSE 0 42
+ 43 # END) AS "31-60 days", 43
+ 44 # sum(CASE 44
+ 45 # WHEN (cs_ship_date_sk - cs_sold_date_sk > 60) 45
+ 46 # AND (cs_ship_date_sk - cs_sold_date_sk <= 90) THEN 1 46
+ 47 % sys.sq1, sys.ship_mode, sys.call_center, sys., sys., sys., sys., sys. # table_name 47
+ 48 # sys.sq1, sys.ship_mode, sys.call_center, sys.L12, sys.L15, sys.L20, sys.L23, sys.L26 # table_name 48
+ 49 % w_substr, sm_type, cc_name, "30 days", "31-60 days", "61-90 days", "91-120 days", ">120 days" # name 49
+ 50 % clob, char, varchar, hugeint, hugeint, hugeint, hugeint, hugeint # type 50
+ 51 % 20, 30, 13, 4, 4, 4, 1, 1 # length 51
+ 52 [ NULL, "EXPRESS", "Mid Atlantic", 1223, 1314, 1257, 0, 0 ] 52
+ 53 [ NULL, "EXPRESS", "NY Metro", 1274, 1296, 1286, 0, 0 ] 53
+ 54 [ NULL, "EXPRESS", "North Midwest", 1159, 1329, 1276, 0, 0 ] 54
+ 55 [ NULL, "LIBRARY", "Mid Atlantic", 941, 978, 948, 0, 0 ] 55
+ 56 [ NULL, "LIBRARY", "NY Metro", 886, 1001, 1009, 0, 0 ] 56
+ 57 [ NULL, "LIBRARY", "North Midwest", 917, 943, 991, 0, 0 ] 57
+ 58 [ NULL, "NEXT DAY", "Mid Atlantic", 1304, 1264, 1349, 0, 0 ] 58
+ 59 [ NULL, "NEXT DAY", "NY Metro", 1271, 1251, 1291, 0, 0 ] 59
+ 60 [ NULL, "NEXT DAY", "North Midwest", 1199, 1233, 1273, 0, 0 ] 60
+ 61 [ NULL, "OVERNIGHT", "Mid Atlantic", 965, 989, 967, 0, 0 ] 61
+ 62 [ NULL, "OVERNIGHT", "NY Metro", 979, 993, 1039, 0, 0 ] 62
+ 63 [ NULL, "OVERNIGHT", "North Midwest", 946, 1016, 905, 0, 0 ] 63
+ 64 [ NULL, "REGULAR", "Mid Atlantic", 933, 994, 997, 0, 0 ] 64
+ 65 [ NULL, "REGULAR", "NY Metro", 961, 1022, 1034, 0, 0 ] 65
+ 66 [ NULL, "REGULAR", "North Midwest", 893, 921, 949, 0, 0 ] 66
+ 67 [ NULL, "TWO DAY", "Mid Atlantic", 972, 968, 972, 0, 0 ] 67
+ 68 [ NULL, "TWO DAY", "NY Metro", 926, 974, 1004, 0, 0 ] 68
+ 69 [ NULL, "TWO DAY", "North Midwest", 941, 921, 981, 0, 0 ] 69
+ 70 [ "Bad cards must make.", "EXPRESS", "Mid Atlantic", 1270, 1318, 1281, 0, 0 ] 70
+ 71 [ "Bad cards must make.", "EXPRESS", "NY Metro", 1226, 1287, 1282, 0, 0 ] 71
+ 72 [ "Bad cards must make.", "EXPRESS", "North Midwest", 1208, 1242, 1294, 0, 0 ] 72
+ 73 [ "Bad cards must make.", "LIBRARY", "Mid Atlantic", 962, 976, 1009, 0, 0 ] 73
+ 74 [ "Bad cards must make.", "LIBRARY", "NY Metro", 978, 984, 999, 0, 0 ] 74
+ 75 [ "Bad cards must make.", "LIBRARY", "North Midwest", 898, 959, 958, 0, 0 ] 75
+ 76 [ "Bad cards must make.", "NEXT DAY", "Mid Atlantic", 1225, 1328, 1327, 0, 0 ] 76
+ 77 [ "Bad cards must make.", "NEXT DAY", "NY Metro", 1262, 1325, 1246, 0, 0 ] 77
+ 78 [ "Bad cards must make.", "NEXT DAY", "North Midwest", 1227, 1300, 1276, 0, 0 ] 78
+ 79 [ "Bad cards must make.", "OVERNIGHT", "Mid Atlantic", 956, 935, 990, 0, 0 ] 79
+ 80 [ "Bad cards must make.", "OVERNIGHT", "NY Metro", 982, 930, 993, 0, 0 ] 80
+ 81 [ "Bad cards must make.", "OVERNIGHT", "North Midwest", 907, 990, 955, 0, 0 ] 81
+ 82 [ "Bad cards must make.", "REGULAR", "Mid Atlantic", 928, 974, 1005, 0, 0 ] 82
+ 83 [ "Bad cards must make.", "REGULAR", "NY Metro", 942, 1009, 948, 0, 0 ] 83
+ 84 [ "Bad cards must make.", "REGULAR", "North Midwest", 921, 968, 925, 0, 0 ] 84
+ 85 [ "Bad cards must make.", "TWO DAY", "Mid Atlantic", 954, 971, 979, 0, 0 ] 85
+ 86 [ "Bad cards must make.", "TWO DAY", "NY Metro", 947, 1013, 952, 0, 0 ] 86
+ 87 [ "Bad cards must make.", "TWO DAY", "North Midwest", 904, 930, 947, 0, 0 ] 87
+ 88 [ "Conventional childr", "EXPRESS", "Mid Atlantic", 1214, 1296, 1243, 0, 0 ] 88
+ 89 [ "Conventional childr", "EXPRESS", "NY Metro", 1284, 1331, 1277, 0, 0 ] 89
+ 90 [ "Conventional childr", "EXPRESS", "North Midwest", 1180, 1287, 1226, 0, 0 ] 90
+ 91 [ "Conventional childr", "LIBRARY", "Mid Atlantic", 990, 1008, 962, 0, 0 ] 91
+ 92 [ "Conventional childr", "LIBRARY", "NY Metro", 983, 976, 981, 0, 0 ] 92
+ 93 [ "Conventional childr", "LIBRARY", "North Midwest", 925, 892, 953, 0, 0 ] 93
+ 94 [ "Conventional childr", "NEXT DAY", "Mid Atlantic", 1284, 1315, 1274, 0, 0 ] 94
+ 95 [ "Conventional childr", "NEXT DAY", "NY Metro", 1288, 1280, 1284, 0, 0 ] 95
+ 96 [ "Conventional childr", "NEXT DAY", "North Midwest", 1249, 1278, 1308, 0, 0 ] 96
+ 97 [ "Conventional childr", "OVERNIGHT", "Mid Atlantic", 897, 973, 926, 0, 0 ] 97
+ 98 [ "Conventional childr", "OVERNIGHT", "NY Metro", 958, 963, 897, 0, 0 ] 98
+ 99 [ "Conventional childr", "OVERNIGHT", "North Midwest", 942, 934, 937, 0, 0 ] 99
+ 100 [ "Conventional childr", "REGULAR", "Mid Atlantic", 941, 1007, 945, 0, 0 ] 100
+ 101 [ "Conventional childr", "REGULAR", "NY Metro", 949, 928, 987, 0, 0 ] 101
+ 102 [ "Conventional childr", "REGULAR", "North Midwest", 920, 927, 925, 0, 0 ] 102
+ 103 [ "Conventional childr", "TWO DAY", "Mid Atlantic", 926, 979, 1047, 0, 0 ] 103
+ 104 [ "Conventional childr", "TWO DAY", "NY Metro", 925, 1007, 962, 0, 0 ] 104
+ 105 [ "Conventional childr", "TWO DAY", "North Midwest", 879, 980, 971, 0, 0 ] 105
+ 106 [ "Doors canno", "EXPRESS", "Mid Atlantic", 1240, 1245, 1267, 0, 0 ] 106
+ 107 [ "Doors canno", "EXPRESS", "NY Metro", 1234, 1270, 1349, 0, 0 ] 107
+ 108 [ "Doors canno", "EXPRESS", "North Midwest", 1185, 1238, 1197, 0, 0 ] 108
+ 109 [ "Doors canno", "LIBRARY", "Mid Atlantic", 873, 974, 948, 0, 0 ] 109
+ 110 [ "Doors canno", "LIBRARY", "NY Metro", 987, 1005, 990, 0, 0 ] 110
+ 111 [ "Doors canno", "LIBRARY", "North Midwest", 947, 952, 1025, 0, 0 ] 111
+ 112 [ "Doors canno", "NEXT DAY", "Mid Atlantic", 1264, 1276, 1185, 0, 0 ] 112
+ 113 [ "Doors canno", "NEXT DAY", "NY Metro", 1263, 1337, 1310, 0, 0 ] 113
+ 114 [ "Doors canno", "NEXT DAY", "North Midwest", 1202, 1247, 1278, 0, 0 ] 114
+ 115 [ "Doors canno", "OVERNIGHT", "Mid Atlantic", 912, 888, 934, 0, 0 ] 115
+ 116 [ "Doors canno", "OVERNIGHT", "NY Metro", 942, 1003, 959, 0, 0 ] 116
+ 117 [ "Doors canno", "OVERNIGHT", "North Midwest", 896, 903, 911, 0, 0 ] 117
+ 118 [ "Doors canno", "REGULAR", "Mid Atlantic", 888, 953, 974, 0, 0 ] 118
+ 119 [ "Doors canno", "REGULAR", "NY Metro", 971, 1028, 946, 0, 0 ] 119
+ 120 [ "Doors canno", "REGULAR", "North Midwest", 937, 974, 914, 0, 0 ] 120
+ 121 [ "Doors canno", "TWO DAY", "Mid Atlantic", 974, 898, 985, 0, 0 ] 121
+ 122 [ "Doors canno", "TWO DAY", "NY Metro", 982, 1017, 997, 0, 0 ] 122
+ 123 [ "Doors canno", "TWO DAY", "North Midwest", 985, 937, 959, 0, 0 ] 123
+ 124 [ "Important issues liv", "EXPRESS", "Mid Atlantic", 1322, 1329, 1293, 0, 0 ] 124
+ 125 [ "Important issues liv", "EXPRESS", "NY Metro", 1301, 1300, 1239, 0, 0 ] 125
+ 126 [ "Important issues liv", "EXPRESS", "North Midwest", 1266, 1228, 1285, 0, 0 ] 126
+ 127 [ "Important issues liv", "LIBRARY", "Mid Atlantic", 988, 997, 925, 0, 0 ] 127
+ 128 [ "Important issues liv", "LIBRARY", "NY Metro", 947, 963, 988, 0, 0 ] 128
+ 129 [ "Important issues liv", "LIBRARY", "North Midwest", 937, 972, 964, 0, 0 ] 129
+ 130 [ "Important issues liv", "NEXT DAY", "Mid Atlantic", 1221, 1268, 1217, 0, 0 ] 130
+ 131 [ "Important issues liv", "NEXT DAY", "NY Metro", 1281, 1311, 1310, 0, 0 ] 131
+ 132 [ "Important issues liv", "NEXT DAY", "North Midwest", 1219, 1214, 1327, 0, 0 ] 132
+ 133 [ "Important issues liv", "OVERNIGHT", "Mid Atlantic", 929, 1018, 991, 0, 0 ] 133
+ 134 [ "Important issues liv", "OVERNIGHT", "NY Metro", 950, 965, 931, 0, 0 ] 134
+ 135 [ "Important issues liv", "OVERNIGHT", "North Midwest", 936, 989, 932, 0, 0 ] 135
+ 136 [ "Important issues liv", "REGULAR", "Mid Atlantic", 961, 995, 949, 0, 0 ] 136
+ 137 [ "Important issues liv", "REGULAR", "NY Metro", 972, 934, 1018, 0, 0 ] 137
+ 138 [ "Important issues liv", "REGULAR", "North Midwest", 905, 947, 941, 0, 0 ] 138
+ 139 [ "Important issues liv", "TWO DAY", "Mid Atlantic", 954, 982, 944, 0, 0 ] 139
+ 140 [ "Important issues liv", "TWO DAY", "NY Metro", 844, 972, 1006, 0, 0 ] 140
+ 141 [ "Important issues liv", "TWO DAY", "North Midwest", 914, 969, 960, 0, 0 ] 141
+ 142 142
+ 143 # 00:30:05 > 143
+ 144 # 00:30:05 > "Done." 144
+ 145 # 00:30:05 > 145
+ 146 146