[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-checkins
Subject: MonetDB: default - approve output
From: Niels Nes <commits+niels=cwi.nl () monetdb ! org>
Date: 2016-09-30 17:35:15
Message-ID: hg.7418439d33d6.1475256915.6315528441665844383 () monetdb2 ! cwi-incubator ! nl
[Download RAW message or body]
Changeset: 7418439d33d6 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;nodet18439d33d6
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
monetdb5/optimizer/Tests/dataflow3.stable.out
sql/test/remote/Tests/partition_elim.stable.out
Branch: default
Log Message:
approve output
diffs (253 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
@@ -64,10 +64,10 @@ Ready.
% 126 # length
function user.s8_1():void;
X_38:void := querylog.define("explain copy into ttt from \
\\'/tmp/xyz\\';","default_pipe",12);
-barrier X_56 := language.dataflow();
+barrier X_58 := language.dataflow();
X_0 := sql.mvc();
(X_21:bat[:int],X_22:bat[:int],X_23:bat[:int]) := \
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0,nil:str);
-exit X_56;
+exit X_58;
X_25 := sql.append(X_0,"sys","ttt","a",X_21);
X_30 := sql.append(X_25,"sys","ttt","b",X_22);
X_33 := sql.append(X_30,"sys","ttt","c",X_23);
@@ -125,10 +125,10 @@ end user.s8_1;
% 126 # length
function user.s24_1():void;
X_38:void := querylog.define("explain copy into ttt from \
\\'/tmp/xyz\\';","user_1",12);
-barrier X_56 := language.dataflow();
+barrier X_58 := language.dataflow();
X_0 := sql.mvc();
(X_21:bat[:int],X_22:bat[:int],X_23:bat[:int]) := \
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0,nil:str);
-exit X_56;
+exit X_58;
X_25 := sql.append(X_0,"sys","ttt","a",X_21);
X_30 := sql.append(X_25,"sys","ttt","b",X_22);
X_35 := aggr.count(X_23);
diff --git a/monetdb5/optimizer/Tests/dataflow3.stable.out \
b/monetdb5/optimizer/Tests/dataflow3.stable.out
--- a/monetdb5/optimizer/Tests/dataflow3.stable.out
+++ b/monetdb5/optimizer/Tests/dataflow3.stable.out
@@ -26,13 +26,13 @@ Ready.
#mdb.list("user","s1_0");
function user.s1_0():void;
-barrier X_30 := language.dataflow();
+barrier X_31 := language.dataflow();
X17 := bat.new(:lng);
X54 := bat.new(:lng);
X55 := bat.new(:lng);
X56 := bat.new(:lng);
X57 := bat.new(:lng);
-exit X_30;
+exit X_31;
X59 := remote.connect("mapi:monetdb://volund.ins.cwi.nl:50000/sn4","monetdb","monetdb","msql");
remote.register(X59,"user","s1_0map");
X66 := remote.put(X59,X54);
diff --git a/sql/test/remote/Tests/partition_elim.stable.out \
b/sql/test/remote/Tests/partition_elim.stable.out
--- a/sql/test/remote/Tests/partition_elim.stable.out
+++ b/sql/test/remote/Tests/partition_elim.stable.out
@@ -135,7 +135,7 @@ Ready.
% mal # name
% clob # type
% 68 # length
-function user.SQLanalyze():void;
+function user.main():void;
barrier X_1253 := language.dataflow();
X_1181 := bat.new(nil:str);
X_1188 := bat.append(X_1181,".test");
@@ -189,13 +189,37 @@ barrier X_1253 := language.dataflow();
language.pass(C_1167);
exit X_1253;
sql.resultSet(X_1198,X_1199,X_1200,X_1201,X_1202,X_1169,X_1179);
-end user.SQLanalyze;
+end user.main;
+#inline actions= 0 time=3 usec
+#remap actions= 0 time=8 usec
+#costmodel actions= 1 time=4 usec
+#coercion actions= 0 time=5 usec
+#evaluate actions= 6 timeH usec
+#emptybind actions= 0 time$ usec
+#aliases actions time$ usec
+#mitosis actions= 1 timer usec
+#mergetable actions= 3 time7 usec
+#deadcode actions= 4 time! usec
+#aliases actions= 0 time usec
+#constants actions= 7 time usec
+#commonTerms actions= 0 time usec
+#projectionpath actions= 0 time usec
+#deadcode actions= 0 time usec
+#reorder actions= 1 timey usec
+#reduce actionsC time# usec
+#matpack actions= 2 time usec
+#dataflow actions' timec usec
+#multiplex actions= 0 time=5 usec
+#profiler actions= 1 time=9 usec
+#candidates actions= 1 time=4 usec
+#garbagecollector actions= 1 timeD usec
+#total actions= 1 time4 usec
#explain select x,y from test where x between (7-3) and (7-1);
% .explain # table_name
% mal # name
% clob # type
% 75 # length
-function user.SQLanalyze():void;
+function user.main():void;
barrier X_1397 := language.dataflow();
X_1320 := bat.new(nil:str);
X_1327 := bat.append(X_1320,".test");
@@ -249,13 +273,37 @@ barrier X_1397 := language.dataflow();
language.pass(C_1305);
exit X_1397;
sql.resultSet(X_1337,X_1338,X_1339,X_1340,X_1341,X_1307,X_1318);
-end user.SQLanalyze;
+end user.main;
+#inline actions= 0 time=3 usec
+#remap actions= 0 time=9 usec
+#costmodel actions= 1 time=3 usec
+#coercion actions= 0 time=4 usec
+#evaluate actions time usec
+#emptybind actions= 0 time usec
+#aliases actions$ time usec
+#mitosis actions= 1 timeG usec
+#mergetable actions= 3 time usec
+#deadcode actions= 4 time usec
+#aliases actions= 0 time usec
+#constants actions= 9 time usec
+#commonTerms actions= 0 time usec
+#projectionpath actions= 0 time=9 usec
+#deadcode actions= 0 time usec
+#reorder actions= 1 timeT usec
+#reduce actionsd time% usec
+#matpack actions= 2 time usec
+#dataflow actions' timeF usec
+#multiplex actions= 0 time=5 usec
+#profiler actions= 1 time=7 usec
+#candidates actions= 1 time=2 usec
+#garbagecollector actions= 1 time7 usec
+#total actions= 1 timev6 usec
#explain select x,y from test where x between 4.0 and 6.0 and y between 0.0 and 2.0;
% .explain # table_name
% mal # name
% clob # type
% 68 # length
-function user.SQLanalyze():void;
+function user.main():void;
barrier X_1511 := language.dataflow();
X_1437 := bat.new(nil:str);
X_1444 := bat.append(X_1437,"sys.test");
@@ -299,13 +347,37 @@ barrier X_1511 := language.dataflow();
language.pass(X_1479);
exit X_1511;
sql.resultSet(X_1452,X_1453,X_1455,X_1456,X_1457,X_1434,X_1435);
-end user.SQLanalyze;
+end user.main;
+#inline actions= 0 time=2 usec
+#remap actions= 0 time=8 usec
+#costmodel actions= 1 time=3 usec
+#coercion actions= 0 time=3 usec
+#evaluate actions= 8 time3 usec
+#emptybind actions= 0 time usec
+#aliases actions time) usec
+#mitosis actions= 1 timeA usec
+#mergetable actions= 4 time
usec
+#deadcode actions= 5 time usec
+#aliases actions= 0 time usec
+#constants actions= 9 time usec
+#commonTerms actions= 0 time usec
+#projectionpath actions= 0 time=8 usec
+#deadcode actions= 0 time usec
+#reorder actions= 1 timeE usec
+#reduce actionsD time usec
+#matpack actions= 2 time usec
+#dataflow actions' timeA usec
+#multiplex actions= 0 time=4 usec
+#profiler actions= 1 time=6 usec
+#candidates actions= 1 time=2 usec
+#garbagecollector actions= 1 time2 usec
+#total actions= 1 timea5 usec
#explain select x,y from test where x between 4.0 and 6.0 and y between (1.0-1.0) \
and (4.0-2.0); % .explain # table_name
% mal # name
% clob # type
% 75 # length
-function user.SQLanalyze():void;
+function user.main():void;
barrier X_1639 := language.dataflow();
X_1561 := bat.new(nil:str);
X_1568 := bat.append(X_1561,"sys.test");
@@ -349,13 +421,37 @@ barrier X_1639 := language.dataflow();
language.pass(X_1607);
exit X_1639;
sql.resultSet(X_1577,X_1578,X_1580,X_1581,X_1582,X_1558,X_1559);
-end user.SQLanalyze;
+end user.main;
+#inline actions= 0 time=2 usec
+#remap actions= 0 time=8 usec
+#costmodel actions= 1 time=2 usec
+#coercion actions= 0 time=3 usec
+#evaluate actions time` usec
+#emptybind actions= 0 time usec
+#aliases actions time usec
+#mitosis actions= 1 time@ usec
+#mergetable actions= 4 time usec
+#deadcode actions= 5 time usec
+#aliases actions= 0 time usec
+#constants actions time usec
+#commonTerms actions= 0 time usec
+#projectionpath actions= 0 time=7 usec
+#deadcode actions= 0 time usec
+#reorder actions= 1 timeE usec
+#reduce actionsX time" usec
+#matpack actions= 2 time usec
+#dataflow actions' time@ usec
+#multiplex actions= 0 time=4 usec
+#profiler actions= 1 time=5 usec
+#candidates actions= 1 time=2 usec
+#garbagecollector actions= 1 time3 usec
+#total actions= 1 timec8 usec
#explain select x,y from test where x between (7-3) and (7-1) and y between \
(1.0-1.0) and (4.0-2.0); % .explain # table_name
% mal # name
% clob # type
% 75 # length
-function user.SQLanalyze():void;
+function user.main():void;
barrier X_1781 := language.dataflow();
X_1698 := bat.new(nil:str);
X_1705 := bat.append(X_1698,"sys.test");
@@ -399,7 +495,31 @@ barrier X_1781 := language.dataflow();
language.pass(X_1749);
exit X_1781;
sql.resultSet(X_1714,X_1715,X_1717,X_1718,X_1719,X_1695,X_1696);
-end user.SQLanalyze;
+end user.main;
+#inline actions= 0 time=2 usec
+#remap actions= 0 time=8 usec
+#costmodel actions= 1 time=3 usec
+#coercion actions= 0 time=3 usec
+#evaluate actions$ timep usec
+#emptybind actions= 0 time usec
+#aliases actions& time usec
+#mitosis actions= 1 timeB usec
+#mergetable actions= 4 time usec
+#deadcode actions= 5 time usec
+#aliases actions= 0 time usec
+#constants actions time2 usec
+#commonTerms actions= 0 time usec
+#projectionpath actions= 0 time=7 usec
+#deadcode actions= 0 time usec
+#reorder actions= 1 timeF usec
+#reduce actionsr time& usec
+#matpack actions= 2 time usec
+#dataflow actions' timeA usec
+#multiplex actions= 0 time=5 usec
+#profiler actions= 1 time=5 usec
+#candidates actions= 1 time=2 usec
+#garbagecollector actions= 1 time3 usec
+#total actions= 1 timei5 usec
#drop table test;
#drop table test1;
#drop table test2;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic