Changeset: fb187e0268f7 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fb187e0268f7 Added Files: monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows.single Branch: default Log Message:
Merge heads. diffs (117 lines): diff --git a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows.single b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows.single new file mode 100755 --- /dev/null +++ b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows.single @@ -0,0 +1,112 @@ +stdout of test 'opt_sql_append` in directory 'monetdb5/extras/mal_optimizer_template` itself: + + +# 22:58:57 > +# 22:58:57 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "gdk_dbfarm=/ufs/manegold/_/Monet/HG/default/prefix/_/var/MonetDB" "--set" "mapi_open=true" "--set" "mapi_port=36275" "--set" "monet_prompt=" "--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_mal_optimizer_template" "--set" "mal_listing=0" +# 22:58:57 > + +# MonetDB 5 server v11.8.0 +# This is an unreleased version +# Serving database 'mTests_extras_mal_optimizer_template', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 15.630 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://rome.ins.cwi.nl:36275/ +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. +# SQL catalog created, loading sql scripts once +# loading sql script: 09_like.sql +# loading sql script: 10_math.sql +# loading sql script: 11_times.sql +# loading sql script: 12_url.sql +# loading sql script: 13_date.sql +# loading sql script: 14_inet.sql +# loading sql script: 15_history.sql +# loading sql script: 16_tracelog.sql +# loading sql script: 17_compress.sql +# loading sql script: 18_dictionary.sql +# loading sql script: 19_cluster.sql +# loading sql script: 20_vacuum.sql +# loading sql script: 21_dependency_functions.sql +# loading sql script: 22_clients.sql +# loading sql script: 23_skyserver.sql +# loading sql script: 24_zorder.sql +# loading sql script: 25_debug.sql +# loading sql script: 40_geom.sql +# loading sql script: 80_udf.sql +# loading sql script: 99_system.sql + +# 22:58:57 > +# 22:58:57 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=rome" "--port=36275" +# 22:58:57 > + +#create table ttt (a int, b int, c int); +#select optimizer; +% .L # table_name +% single_value # name +% varchar # type +% 12 # length +[ "default_pipe" ] +#select def from optimizers() where name = optimizer; +% .L # table_name +% def # name +% clob # type +% 449 # length +[ "optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.garbageCollector();" ] +#explain copy into ttt from 'a:\tmp/xyz'; +% .explain # table_name +% mal # name +% clob # type +% 134 # length +function user.s4_1{autoCommit=true}():void; + X_26:void := querylog.define("explain copy into ttt from \\'a:\\\\tmp/xyz\\';","default_pipe",10); + X_2 := sql.mvc(); + (X_12:bat[:oid,:int],X_13:bat[:oid,:int],X_14:bat[:oid,:int]) := sql.copy_from(nil,"|","\\n",nil:str,"null","a:\\tmp/xyz",-1,0,0); + X_15 := sql.append(X_2,"sys","ttt","a",X_12); + X_19 := sql.append(X_15,"sys","ttt","b",X_13); + X_21 := sql.append(X_19,"sys","ttt","c",X_14); + X_23 := aggr.count(X_14); + sql.affectedRows(X_21,X_23,""); +end user.s4_1; +#declare opt_pipe_name string; +#set opt_pipe_name = ( select optimizer ); +#declare opt_pipe_def string; +#set opt_pipe_def = ( select def from optimizers() where name = opt_pipe_name ); +#set optimizer = substring(opt_pipe_def,0,length(opt_pipe_def)-length('optimizer.garbageCollector();')) || 'optimizer.sql_append();optimizer.garbageCollector();'; +#select optimizer; +% .L # table_name +% single_value # name +% varchar # type +% 6 # length +[ "user_1" ] +#select def from optimizers() where name = optimizer; +% .L # table_name +% def # name +% clob # type +% 472 # length +[ "optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.aliases();optimizer.pushselect();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.sql_append();optimizer.garbageCollector();" ] +#explain copy into ttt from 'Z:/tmp/xyz'; +% .explain # table_name +% mal # name +% clob # type +% 133 # length +function user.s12_1{autoCommit=true}():void; + X_26:void := querylog.define("explain copy into ttt from \\'Z:/tmp/xyz\\';","user_1",10); + X_2 := sql.mvc(); + (X_12:bat[:oid,:int],X_13:bat[:oid,:int],X_14:bat[:oid,:int]) := sql.copy_from(nil,"|","\\n",nil:str,"null","Z:/tmp/xyz",-1,0,0); + X_15 := sql.append(X_2,"sys","ttt","a",X_12); + X_19 := sql.append(X_15,"sys","ttt","b",X_13); + X_23 := aggr.count(X_14); + X_21 := sql.append(X_19,"sys","ttt","c",X_14); + sql.affectedRows(X_21,X_23,""); +end user.s12_1; +#drop table ttt; + +# 22:58:58 > +# 22:58:58 > "Done." +# 22:58:58 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
