Test 98.sql (id 3c6cbe78e1fe) (out)
98.stable.err.FILTERED 2019-09-08 11:30:03.000000000 +020098.test.err.FILTERED 2019-09-08 11:30:03.000000000 +0200
1 Statistics about stderr of test '98` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stderr of test '98` in directory 'sql/benchmarks/tpcds`: 1
2 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 19 lines, 66 words, 546 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 63 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 19 lines, 66 words, 546 chars in lines not matching '^$|^(\| |)#` 3
4 # 17 lines, 63 words, 615 chars in all lines 4 ! 4 # 39 lines, 136 words, 1418 chars in all lines 4
5 5 5 5
..................
# 17 lines, 63 words,
8 8 8 8
9 # 09:56:31 > 9 ! 9 # 11:30:03 > 9
10 # 09:56:31 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35529" "--set" "mapi_usock=/var/tmp/mtest-2366/.s.monetdb.35529" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/ufs/sjoerd/@Monet-devel/var/MonetDB/mTests_sql_benchmarks_tpcds" "--set" "embedded_c=true" 10 ! 10 # 11:30:03 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35864" "--set" "mapi_usock=/var/tmp/mtest-99316/.s.monetdb.35864" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/Users/monet/scratch/3c6cbe78e1fe-6-1-1/tests/sql/dbfarm/mTests_sql_benchmarks_tpcds" "--set" "embedded_c=true" 10
11 # 09:56:31 > 11 ! 11 # 11:30:03 > 11
12 12 ! 12 12
13 13 ! 13 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 13
14 # 09:56:31 > 14 ! 14 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 14
15 # 09:56:31 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-2366" "--port=35529" 15 ! 15 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 15
16 # 09:56:31 > 16 ! 16 16
17 17 ! 17 # 11:30:03 > 17
18 18 ! 18 # 11:30:03 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-99316" "--port=35864" 18
19 # 09:56:32 > 19 ! 19 # 11:30:03 > 19
20 # 09:56:32 > "Done." 20 ! 20 20
21 # 09:56:32 > 21 ! 21 #~ MAPI = (monetdb) /var/tmp/mtest-99316/.s.monetdb.35864 21
+ 22 QUERY = SELECT i_item_id , 22
+ 23 i_item_desc, 23
+ 24 i_category, 24
+ 25 i_class, 25
+ 26 i_current_price , 26
+ 27 sum(ss_ext_sales_price) AS itemrevenue, 27
+ 28 sum(ss_ext_sales_price)*100.0000/sum(sum(ss_ext_sales_price)) OVER (PARTITION BY i_class) AS revenueratio 28
+ 29 FROM store_sales , 29
+ 30 item, 30
+ 31 date_dim 31
+ 32 WHERE ss_item_sk = i_item_sk 32
+ 33 AND i_category IN ('Sports', 33
+ 34 'Books', 34
+ 35 'Home') 35
+ 36 AND ss_sold_date_sk = d_date_sk 36
+ 37 AND d_date BETWEEN cast('1999-02-22' AS date) AND cast('1999-03-24' AS date) 37
+ 38 ERROR = !Error in optimizer garbageCollector 38
+ 39 CODE = 42000 39
+ 40 40
+ 41 # 11:30:03 > 41
+ 42 # 11:30:03 > "Done." 42
+ 43 # 11:30:03 > 43
22 22 44 44