Test 83.sql (id 001aedfec00f) (err)
83.stable.out.FILTERED 2018-12-06 00:30:04.000000000 +010083.test.out.FILTERED 2018-12-06 00:30:04.000000000 +0100
+ 1 Statistics about stdout of test '83` in directory 'sql/benchmarks/tpcds`: 1
+ 2 27 lines, 263 words, 1703 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 27 lines, 263 words, 1703 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 75 lines, 470 words, 3390 chars in all lines 4
+ 5 5
+ 6 stdout of test '83` in directory 'sql/benchmarks/tpcds` itself: 6
+ 7 7
+ 8 8
+ 9 # 00:30:03 > 9
+ 10 # 00:30:03 > "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:03 > 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 #WITH sr_items AS 32
+ 33 # (SELECT i_item_id item_id, 33
+ 34 # sum(sr_return_quantity) sr_item_qty 34
+ 35 # FROM store_returns, 35
+ 36 # item, 36
+ 37 # date_dim 37
+ 38 # WHERE sr_item_sk = i_item_sk 38
+ 39 # AND d_date IN 39
+ 40 # (SELECT d_date 40
+ 41 # FROM date_dim 41
+ 42 # WHERE d_week_seq IN 42
+ 43 # (SELECT d_week_seq 43
+ 44 # FROM date_dim 44
+ 45 # WHERE d_date IN ('2000-06-30', 45
+ 46 # '2000-09-27', 46
+ 47 # '2000-11-17'))) 47
+ 48 # AND sr_returned_date_sk = d_date_sk 48
+ 49 # GROUP BY i_item_id), 49
+ 50 % sys.sr_items, sys.sr_items, sys., sys.cr_items, sys., sys.wr_items, sys., sys. # table_name 50
+ 51 # sys.sr_items, sys.sr_items, sys.L64, sys.cr_items, sys.L67, sys.wr_items, sys.L72, sys.L74 # table_name 51
+ 52 % item_id, sr_item_qty, sr_dev, cr_item_qty, cr_dev, wr_item_qty, wr_dev, average # name 52
+ 53 % char, hugeint, decimal, hugeint, decimal, hugeint, decimal, decimal # type 53
+ 54 % 16, 2, 40, 2, 40, 2, 40, 40 # length 54
+ 55 [ "AAAAAAAAANECAAAA", 34, 18.500, 9, 4.900, 18, 9.800, 20.333 ] 55
+ 56 [ "AAAAAAAACAOBAAAA", 27, 11.600, 38, 16.400, 12, 5.100, 25.666 ] 56
+ 57 [ "AAAAAAAACBNDAAAA", 38, 11.600, 52, 15.900, 19, 5.800, 36.333 ] 57
+ 58 [ "AAAAAAAACCGAAAAA", 30, 15.100, 18, 9.000, 18, 9.000, 22.000 ] 58
+ 59 [ "AAAAAAAACKBDAAAA", 32, 12.600, 22, 8.700, 30, 11.900, 28.000 ] 59
+ 60 [ "AAAAAAAACOIBAAAA", 31, 8.000, 29, 7.500, 68, 17.700, 42.666 ] 60
+ 61 [ "AAAAAAAAEBLDAAAA", 9, 3.700, 34, 13.900, 38, 15.600, 27.000 ] 61
+ 62 [ "AAAAAAAAELFDAAAA", 54, 20.200, 4, 1.400, 31, 11.600, 29.666 ] 62
+ 63 [ "AAAAAAAAFEBAAAAA", 19, 15.400, 17, 13.800, 5, 4.000, 13.666 ] 63
+ 64 [ "AAAAAAAAFODDAAAA", 30, 11.400, 7, 2.600, 50, 19.100, 29.000 ] 64
+ 65 [ "AAAAAAAAGLMCAAAA", 37, 26.800, 3, 2.100, 6, 4.300, 15.333 ] 65
+ 66 [ "AAAAAAAAHAGDAAAA", 16, 8.300, 15, 7.800, 33, 17.100, 21.333 ] 66
+ 67 [ "AAAAAAAAHCDEAAAA", 41, 19.200, 1, 0.400, 29, 13.600, 23.666 ] 67
+ 68 [ "AAAAAAAALAEBAAAA", 19, 6.900, 21, 7.600, 51, 18.600, 30.333 ] 68
+ 69 [ "AAAAAAAAMBDEAAAA", 26, 6.300, 66, 16.100, 44, 10.700, 45.333 ] 69
+ 70 [ "AAAAAAAAMBGBAAAA", 5, 5.000, 1, 1.000, 27, 27.200, 11.000 ] 70
+ 71 [ "AAAAAAAAMDODAAAA", 17, 10.800, 32, 20.500, 3, 1.900, 17.333 ] 71
+ 72 [ "AAAAAAAAMOIAAAAA", 84, 25.400, 12, 3.600, 14, 4.200, 36.666 ] 72
+ 73 [ "AAAAAAAANMAAAAAA", 12, 25.000, 1, 2.000, 3, 6.200, 5.333 ] 73
+ 74 [ "AAAAAAAAODOAAAAA", 5, 4.300, 3, 2.600, 30, 26.300, 12.666 ] 74
+ 75 [ "AAAAAAAAPJOCAAAA", 29, 15.300, 21, 11.100, 13, 6.800, 21.000 ] 75
+ 76 76
+ 77 # 00:30:04 > 77
+ 78 # 00:30:04 > "Done." 78
+ 79 # 00:30:04 > 79
+ 80 80