Changeset: af93717a8e2a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=af93717a8e2a
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
Branch: jit
Log Message:
Approve output
diffs (246 lines):
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
@@ -62,7 +62,7 @@ Ready.
% mal # name
% clob # type
% 118 # length
-function user.s4_1():void;
+function user.s8_1():void;
X_24:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';","default_pipe",12);
barrier X_54 := language.dataflow();
X_1 := sql.mvc();
@@ -73,7 +73,34 @@ exit X_54;
X_20 := sql.append(X_18,"sys","ttt","c",X_13);
X_22 := aggr.count(X_13);
sql.affectedRows(X_20,X_22);
-end user.s4_1;
+end user.s8_1;
+#inline actions= 0 time=1 usec
+#candidates actions= 1 time=14 usec
+#remap actions= 0 time=3 usec
+#costModel actions= 1 time=12 usec
+#coercions actions=10 time=13 usec
+#evaluate actions= 0 time=2 usec
+#emptybind actions= 0 time=4 usec
+#pushselect actions= 0 time=3 usec
+#aliases actions= 0 time=4 usec
+#mitosis actions= 0 time=2 usec
+#mergetable actions= 0 time=17 usec
+#deadcode actions= 0 time=5 usec
+#aliases actions= 0 time=4 usec
+#constants actions= 0 time=5 usec
+#commonTerms actions= 0 time=4 usec
+#projectionpath actions= 0 time=3 usec
+#deadcode actions= 0 time=4 usec
+#reorder actions= 1 time=19 usec
+#reduce actions=33 time=23 usec
+#matpack actions= 0 time=3 usec
+#dataflow actions=31 time=20 usec
+#querylog actions= 0 time=0 usec
+#multiplex actions= 0 time=3 usec
+#generator actions= 0 time=1 usec
+#profiler actions= 1 time=6 usec
+#garbageCollector actions= 1 time=13 usec
+#total actions= 1 time=245 usec
#declare opt_pipe_name string;
#set opt_pipe_name = ( select optimizer );
#declare opt_pipe_def string;
@@ -96,7 +123,7 @@ end user.s4_1;
% mal # name
% clob # type
% 118 # length
-function user.s12_1():void;
+function user.s24_1():void;
X_24:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';","user_1",12);
barrier X_55 := language.dataflow();
X_1 := sql.mvc();
@@ -107,7 +134,35 @@ exit X_55;
X_22 := aggr.count(X_13);
X_20 := sql.append(X_18,"sys","ttt","c",X_13);
sql.affectedRows(X_20,X_22);
-end user.s12_1;
+end user.s24_1;
+#inline actions= 0 time=1 usec
+#candidates actions= 1 time=14 usec
+#remap actions= 0 time=3 usec
+#costModel actions= 1 time=13 usec
+#coercions actions=10 time=14 usec
+#evaluate actions= 0 time=3 usec
+#emptybind actions= 0 time=3 usec
+#pushselect actions= 0 time=3 usec
+#aliases actions= 0 time=4 usec
+#mitosis actions= 0 time=2 usec
+#mergetable actions= 0 time=16 usec
+#deadcode actions= 0 time=4 usec
+#aliases actions= 0 time=4 usec
+#constants actions= 0 time=4 usec
+#commonTerms actions= 0 time=4 usec
+#projectionpath actions= 0 time=3 usec
+#deadcode actions= 0 time=4 usec
+#reorder actions= 1 time=19 usec
+#reduce actions=33 time=23 usec
+#matpack actions= 0 time=3 usec
+#dataflow actions=32 time=19 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=3 usec
+#generator actions= 0 time=1 usec
+#profiler actions= 1 time=7 usec
+#optimizer.sql_append actions= 1 time=8 usec
+#garbageCollector actions= 1 time=19 usec
+#total actions= 1 time=261 usec
#drop table ttt;
# 22:58:58 >
diff --git
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
---
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
+++
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
@@ -73,7 +73,34 @@ exit X_34;
X_20 := sql.append(X_18,"sys","ttt","c",X_13);
X_22 := aggr.count(X_13);
sql.affectedRows(X_20,X_22);
-end user.s4_1;
+end user.s8_1;
+#inline actions= 0 time=1 usec
+#candidates actions= 1 time=14 usec
+#remap actions= 0 time=3 usec
+#costModel actions= 1 time=12 usec
+#coercions actions=10 time=13 usec
+#evaluate actions= 0 time=2 usec
+#emptybind actions= 0 time=4 usec
+#pushselect actions= 0 time=3 usec
+#aliases actions= 0 time=4 usec
+#mitosis actions= 0 time=2 usec
+#mergetable actions= 0 time=17 usec
+#deadcode actions= 0 time=5 usec
+#aliases actions= 0 time=4 usec
+#constants actions= 0 time=5 usec
+#commonTerms actions= 0 time=4 usec
+#projectionpath actions= 0 time=3 usec
+#deadcode actions= 0 time=4 usec
+#reorder actions= 1 time=19 usec
+#reduce actions=33 time=23 usec
+#matpack actions= 0 time=3 usec
+#dataflow actions=31 time=20 usec
+#querylog actions= 0 time=0 usec
+#multiplex actions= 0 time=3 usec
+#generator actions= 0 time=1 usec
+#profiler actions= 1 time=6 usec
+#garbageCollector actions= 1 time=13 usec
+#total actions= 1 time=245 usec
#declare opt_pipe_name string;
#set opt_pipe_name = ( select optimizer );
#declare opt_pipe_def string;
@@ -107,7 +134,35 @@ exit X_35;
X_22 := aggr.count(X_13);
X_20 := sql.append(X_18,"sys","ttt","c",X_13);
sql.affectedRows(X_20,X_22);
-end user.s12_1;
+end user.s24_1;
+#inline actions= 0 time=1 usec
+#candidates actions= 1 time=14 usec
+#remap actions= 0 time=3 usec
+#costModel actions= 1 time=13 usec
+#coercions actions=10 time=14 usec
+#evaluate actions= 0 time=3 usec
+#emptybind actions= 0 time=3 usec
+#pushselect actions= 0 time=3 usec
+#aliases actions= 0 time=4 usec
+#mitosis actions= 0 time=2 usec
+#mergetable actions= 0 time=16 usec
+#deadcode actions= 0 time=4 usec
+#aliases actions= 0 time=4 usec
+#constants actions= 0 time=4 usec
+#commonTerms actions= 0 time=4 usec
+#projectionpath actions= 0 time=3 usec
+#deadcode actions= 0 time=4 usec
+#reorder actions= 1 time=19 usec
+#reduce actions=33 time=23 usec
+#matpack actions= 0 time=3 usec
+#dataflow actions=32 time=19 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=3 usec
+#generator actions= 0 time=1 usec
+#profiler actions= 1 time=7 usec
+#optimizer.sql_append actions= 1 time=8 usec
+#garbageCollector actions= 1 time=19 usec
+#total actions= 1 time=261 usec
#drop table ttt;
# 22:58:58 >
diff --git
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
---
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
+++
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
@@ -71,7 +71,34 @@ function user.s4_1():void;
X_20 := sql.append(X_18,"sys","ttt","c",X_13);
X_22 := aggr.count(X_13);
sql.affectedRows(X_20,X_22);
-end user.s4_1;
+end user.s8_1;
+#inline actions= 0 time=1 usec
+#candidates actions= 1 time=14 usec
+#remap actions= 0 time=3 usec
+#costModel actions= 1 time=12 usec
+#coercions actions=10 time=13 usec
+#evaluate actions= 0 time=2 usec
+#emptybind actions= 0 time=4 usec
+#pushselect actions= 0 time=3 usec
+#aliases actions= 0 time=4 usec
+#mitosis actions= 0 time=2 usec
+#mergetable actions= 0 time=17 usec
+#deadcode actions= 0 time=5 usec
+#aliases actions= 0 time=4 usec
+#constants actions= 0 time=5 usec
+#commonTerms actions= 0 time=4 usec
+#projectionpath actions= 0 time=3 usec
+#deadcode actions= 0 time=4 usec
+#reorder actions= 1 time=19 usec
+#reduce actions=33 time=23 usec
+#matpack actions= 0 time=3 usec
+#dataflow actions=31 time=20 usec
+#querylog actions= 0 time=0 usec
+#multiplex actions= 0 time=3 usec
+#generator actions= 0 time=1 usec
+#profiler actions= 1 time=6 usec
+#garbageCollector actions= 1 time=13 usec
+#total actions= 1 time=245 usec
#declare opt_pipe_name string;
#set opt_pipe_name = ( select optimizer );
#declare opt_pipe_def string;
@@ -103,7 +130,35 @@ function user.s12_1():void;
X_22 := aggr.count(X_13);
X_20 := sql.append(X_18,"sys","ttt","c",X_13);
sql.affectedRows(X_20,X_22);
-end user.s12_1;
+end user.s24_1;
+#inline actions= 0 time=1 usec
+#candidates actions= 1 time=14 usec
+#remap actions= 0 time=3 usec
+#costModel actions= 1 time=13 usec
+#coercions actions=10 time=14 usec
+#evaluate actions= 0 time=3 usec
+#emptybind actions= 0 time=3 usec
+#pushselect actions= 0 time=3 usec
+#aliases actions= 0 time=4 usec
+#mitosis actions= 0 time=2 usec
+#mergetable actions= 0 time=16 usec
+#deadcode actions= 0 time=4 usec
+#aliases actions= 0 time=4 usec
+#constants actions= 0 time=4 usec
+#commonTerms actions= 0 time=4 usec
+#projectionpath actions= 0 time=3 usec
+#deadcode actions= 0 time=4 usec
+#reorder actions= 1 time=19 usec
+#reduce actions=33 time=23 usec
+#matpack actions= 0 time=3 usec
+#dataflow actions=32 time=19 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=3 usec
+#generator actions= 0 time=1 usec
+#profiler actions= 1 time=7 usec
+#optimizer.sql_append actions= 1 time=8 usec
+#garbageCollector actions= 1 time=19 usec
+#total actions= 1 time=261 usec
#drop table ttt;
# 22:58:58 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
