Changeset: abdd02f8f73a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=abdd02f8f73a
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.sql
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
Branch: default
Log Message:
opt_sql_append test: minor extension for debugging and demonstration
diffs (65 lines):
diff --git a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.sql
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.sql
--- a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.sql
+++ b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.sql
@@ -1,5 +1,7 @@
create table ttt (a int, b int, c int);
+select optimizer;
explain copy into ttt from '/tmp/xyz';
set optimizer =
substring(optimizer,0,length(optimizer)-length('garbageCollector')) ||
'sql_append,garbageCollector';
+select optimizer;
explain copy into ttt from '/tmp/xyz';
drop table ttt;
diff --git
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
--- a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
+++ b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
@@ -45,12 +45,18 @@ Ready.
# 22:58:57 >
#create table ttt (a int, b int, c int);
+#select optimizer;
+% . # table_name
+% single_value # name
+% varchar # type
+% 188 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,accumulators,garbageCollector"
]
#explain copy into ttt from '/tmp/xyz';
% .explain # table_name
% mal # name
% clob # type
% 175 # length
-function user.s1_1{autoCommit=true}():void;
+function user.s2_1{autoCommit=true}():void;
X_2 := sql.mvc();
(X_6:bat[:oid,:int] ,X_7:bat[:oid,:int] ,X_8:bat[:oid,:int] ) :=
sql.copy_from("sys":str,"ttt":str,"|":str,"\\n":str,nil:str,"null":str,"/tmp/xyz":str,-1:lng,0:lng,0:int);
X_9 := sql.append(X_2,"sys","ttt","a",X_6);
@@ -58,13 +64,19 @@ function user.s1_1{autoCommit=true}():vo
X_14 := sql.append(X_11,"sys":str,"ttt":str,"c",X_8);
X_16 := aggr.count(X_8);
sql.affectedRows(X_14,X_16,"");
-end s1_1;
+end s2_1;
+#select optimizer;
+% . # table_name
+% single_value # name
+% varchar # type
+% 199 # length
+[
"inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,accumulators,sql_append,garbageCollector"
]
#explain copy into ttt from '/tmp/xyz';
% .explain # table_name
% mal # name
% clob # type
% 175 # length
-function user.s3_1{autoCommit=true}():void;
+function user.s5_1{autoCommit=true}():void;
X_2 := sql.mvc();
(X_6:bat[:oid,:int] ,X_7:bat[:oid,:int] ,X_8:bat[:oid,:int] ) :=
sql.copy_from("sys":str,"ttt":str,"|":str,"\\n":str,nil:str,"null":str,"/tmp/xyz":str,-1:lng,0:lng,0:int);
X_9 := sql.append(X_2,"sys","ttt","a",X_6);
@@ -72,7 +84,7 @@ function user.s3_1{autoCommit=true}():vo
X_16 := aggr.count(X_8);
X_14 := sql.append(X_11,"sys":str,"ttt":str,"c",X_8);
sql.affectedRows(X_14,X_16,"");
-end s3_1;
+end s5_1;
#drop table ttt;
# 22:58:58 >
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
