Test setoptimizer.sql (id 257bc073dc33) (err)
setoptimizer.stable.out.FILTERED 2019-12-02 19:40:57.273143400 +0100setoptimizer.test.out.FILTERED 2019-12-02 19:40:59.035946500 +0100
1 Statistics about stdout of test 'setoptimizer` in directory 'sql/test`: 1 1 Statistics about stdout of test 'setoptimizer` in directory 'sql/test`: 1
2 26 lines, 119 words, 3805 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 17 words, 114 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 26 lines, 119 words, 3805 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 17 words, 114 chars in lines not matching '^$|^(\| |)#` 3
4 # 88 lines, 440 words, 6691 chars in all lines 4 ! 4 # 16 lines, 48 words, 414 chars in all lines 4
5 5 5 5
..................
# 88 lines, 440 words,
8 8 8 8
9 # 20:30:45 > 9 ! 9 # 19:39:42 > 9
10 # 20:30:45 > mserver5 "--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=4 --set "monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=39627 --set xrpc_port=43642 --set monet_prompt= --trace "--dbname=mTests_src_test" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. 10 ! 10 # 19:39:42 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34655" "--forcemito" "--dbpath=C:\monettesting\257bc073dc33-2-1-1\tests\sql\dbfarm\mTests_sql_test" "--set" "embedded_c=true" 10
11 # 20:30:45 > 11 ! 11 # 19:39:42 > 11
12 12 ! 12 12
13 # MonetDB 5 server v11.34.0 (hg id: dd50f41573c0+0314fa9c90d0+) 13 ! 13 13
14 # This is an unreleased version 14 ! 14 14
15 # Serving database 'mTests_sql_test', using 8 threads 15 ! 15 ! Server not ready; skipping attempt to start client! 15
16 # Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers 16 ! 16 16
17 # Found 62.693 GiB available main-memory. 17 ! 17 17
18 # Copyright (c) 1993 - July 2008 CWI. 18 ! 18 # 19:40:56 > 18
19 # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved 19 ! 19 # 19:40:56 > "Done." 19
20 # Visit https://www.monetdb.org/ for further information 20 ! 20 # 19:40:56 > 20
21 # Listening for connection requests on mapi:monetdb://methuselah.da.cwi.nl:35848/ 21 -
22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-8518/.s.monetdb.35848 22 -
23 # MonetDB/GIS module loaded 23 -
24 # SQL catalog created, loading sql scripts once 24 -
25 # loading sql script: 09_like.sql 25 -
26 # loading sql script: 10_math.sql 26 -
27 # loading sql script: 11_times.sql 27 -
28 # loading sql script: 12_url.sql 28 -
29 # loading sql script: 13_date.sql 29 -
30 # loading sql script: 14_inet.sql 30 -
31 # loading sql script: 15_history.sql 31 -
32 # loading sql script: 16_tracelog.sql 32 -
33 # loading sql script: 17_compress.sql 33 -
34 # loading sql script: 18_dictionary.sql 34 -
35 # loading sql script: 19_cluster.sql 35 -
36 # loading sql script: 20_vacuum.sql 36 -
37 # loading sql script: 21_dependency_functions.sql 37 -
38 # loading sql script: 22_clients.sql 38 -
39 # loading sql script: 23_skyserver.sql 39 -
40 # loading sql script: 24_zorder.sql 40 -
41 # loading sql script: 25_debug.sql 41 -
42 # loading sql script: 40_geom.sql 42 -
43 # loading sql script: 80_udf.sql 43 -
44 # loading sql script: 99_system.sql 44 -
45 # MonetDB/SQL module loaded 45 -
46 46 -
47 47 -
48 # 02:57:35 > 48 -
49 # 02:57:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=rome" "--port=30272" 49 -
50 # 02:57:35 > 50 -
51 51 -
52 #select optimizer; 52 -
53 % . # table_name 53 -
54 # .L2 # table_name 54 -
55 % L # name 55 -
56 # L2 # name 56 -
57 % varchar # type 57 -
58 % 12 # length 58 -
59 [ "minimal_pipe" ] 59 -
60 #set optimizer=' optimizer.inline(); optimizer.remap(); optimizer.evaluate(); optimizer.costModel(); optimizer.coercions(); optimizer.emptySet(); optimizer.aliases(); optimizer.mergetable(); optimizer.deadcode(); optimizer.commonTerms(); optimizer.joinPath(); optimizer.reorder(); optimizer.deadcode(); optimizer.reduce(); optimizer.history(); optimizer.multiplex(); optimizer.accumulators(); optimizer.garbageCollector();'; 60 -
61 #select optimizer; 61 -
62 % . # table_name 62 -
63 # .L2 # table_name 63 -
64 % L # name 64 -
65 # L2 # name 65 -
66 % varchar # type 66 -
67 % 12 # length 67 -
68 [ "minimal_pipe" ] 68 -
69 #select optimizer; 69 -
70 % . # table_name 70 -
71 # .L2 # table_name 71 -
72 % L # name 72 -
73 # L2 # name 73 -
74 % varchar # type 74 -
75 % 12 # length 75 -
76 [ "minimal_pipe" ] 76 -
77 #select * from optimizers(); 77 -
78 % ., ., . # table_name 78 -
79 # .L1, .L1, .L1 # table_name 79 -
80 % name, def, status # name 80 -
81 % clob, clob, clob # type 81 -
82 % 15, 641, 6 # length 82 -
83 [ "minimal_pipe", "optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.garbageCollector();", "stable" ] 83 -
84 [ "default_pipe", "optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.aliases();optimizer.evaluate();optimizer.emptybind();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.postfix();optimizer.deadcode();optimizer.wlc();optimizer.garbageCollector();", "stable" ] 84 -
85 [ "oltp_pipe", "optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.emptybind();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.postfix();optimizer.deadcode();optimizer.oltp();optimizer.wlc();optimizer.garbageCollector();", "stable" ] 85 -
86 [ "volcano_pipe", "optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.aliases();optimizer.evaluate();optimizer.emptybind();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.volcano();optimizer.profiler();optimizer.candidates();optimizer.postfix();optimizer.deadcode();optimizer.wlc();optimizer.garbageCollector();", "stable" ] 86 -
87 [ "no_mitosis_pipe", "optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.aliases();optimizer.evaluate();optimizer.emptybind();optimizer.pushselect();optimizer.aliases();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.postfix();optimizer.deadcode();optimizer.wlc();optimizer.garbageCollector();", "stable" ] 87 -
88 [ "sequential_pipe", "optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.aliases();optimizer.evaluate();optimizer.emptybind();optimizer.pushselect();optimizer.aliases();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.matpack();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.postfix();optimizer.deadcode();optimizer.wlc();optimizer.garbageCollector();", "stable" ] 88 -
89 89 -
90 # 02:57:35 > 90 -
91 # 02:57:35 > "Done." 91 -
92 # 02:57:35 > 92 -
93 93 21 21