Test 70.sql (id 3c6cbe78e1fe) (err)
70.stable.out.int128.FILTERED 2019-09-08 12:10:41.000000000 +020070.test.out.FILTERED 2019-09-08 12:10:41.000000000 +0200
1 Statistics about stdout of test '70` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test '70` in directory 'sql/benchmarks/tpcds`: 1
2 8 lines, 62 words, 409 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 8 lines, 62 words, 409 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3
4 # 50 lines, 256 words, 1940 chars in all lines 4 ! 4 # 29 lines, 142 words, 1247 chars in all lines 4
5 5 5 5
..................
# MonetDB/SQL module loaded
26 26 29 29
27 # 18:29:58 > 27 ! 30 30
28 # 18:29:58 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" 28 ! 31 # 12:10:41 > 31
29 # 18:29:58 > 29 ! 32 # 12:10:41 > "Done." 32
30 30 ! 33 # 12:10:41 > 33
31 #WITH results AS 31 -
32 # (SELECT sum(ss_net_profit) AS total_sum, 32 -
33 # s_state, 33 -
34 # s_county, 34 -
35 # 0 AS gstate, 35 -
36 # 0 AS g_county 36 -
37 # FROM store_sales , 37 -
38 # date_dim d1 , 38 -
39 # store 39 -
40 # WHERE d1.d_month_seq BETWEEN 1200 AND 1200 + 11 40 -
41 # AND d1.d_date_sk = ss_sold_date_sk 41 -
42 # AND s_store_sk = ss_store_sk 42 -
43 % .results_rollup, .results_rollup, .results_rollup, .results_rollup, . # table_name 43 -
44 # .results_rollup, .results_rollup, .results_rollup, .results_rollup, .L127 # table_name 44 -
45 % total_sum, s_state, s_county, lochierarchy, rank_within_parent # name 45 -
46 % decimal, char, varchar, tinyint, int # type 46 -
47 % 40, 2, 17, 1, 1 # length 47 -
48 [ -440986113.22, NULL, NULL, 2, 1 ] 48 -
49 [ -440986113.22, "TN", NULL, 1, 1 ] 49 -
50 [ -440986113.22, "TN", "Williamson County", 0, 1 ] 50 -
51 51 -
52 # 18:32:39 > 52 -
53 # 18:32:39 > "Done." 53 -
54 # 18:32:39 > 54 -
55 55 34 34