Changeset: 2d47cd51b7ed for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2d47cd51b7ed
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:
fixed and approved test opt_sql_append
diffs (79 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,9 +1,11 @@
create table ttt (a int, b int, c int);
select optimizer;
+select def from optimizers() where name = optimizer;
explain copy into ttt from '/tmp/xyz';
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;
+select def from optimizers() where name = 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
@@ -51,12 +51,18 @@ Ready.
% varchar # type
% 12 # length
[ "default_pipe" ]
+#select def from optimizers() where name = optimizer;
+% . # table_name
+% def # name
+% clob # type
+% 429 # length
+[
"optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.history();optimizer.multiplex();optimizer.accumulators();optimizer.garbageCollector();"
]
#explain copy into ttt from '/tmp/xyz';
% .explain # table_name
% mal # name
% clob # type
% 175 # length
-function user.s2_1{autoCommit=true}():void;
+function user.s3_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);
@@ -64,11 +70,19 @@ function user.s2_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 s2_1;
+end s3_1;
+# optimizer.mitosis()
+# optimizer.dataflow()
#select optimizer;
% . # table_name
% single_value # name
% varchar # type
+% 4 # length
+[ "user" ]
+#select def from optimizers() where name = optimizer;
+% . # table_name
+% def # name
+% clob # type
% 452 # length
[
"optimizer.inline();optimizer.remap();optimizer.evaluate();optimizer.costModel();optimizer.coercions();optimizer.emptySet();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.commonTerms();optimizer.joinPath();optimizer.reorder();optimizer.deadcode();optimizer.reduce();optimizer.dataflow();optimizer.history();optimizer.multiplex();optimizer.accumulators();optimizer.sql_append();optimizer.garbageCollector();"
]
#explain copy into ttt from '/tmp/xyz';
@@ -76,7 +90,7 @@ end s2_1;
% mal # name
% clob # type
% 175 # length
-function user.s5_1{autoCommit=true}():void;
+function user.s11_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);
@@ -84,7 +98,9 @@ function user.s5_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 s5_1;
+end s11_1;
+# optimizer.mitosis()
+# optimizer.dataflow()
#drop table ttt;
# 22:58:58 >
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
