Changeset: 555ac74169c6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=555ac74169c6
Modified Files:
sql/test/mapi/Tests/sql_int128.stable.out.int128
sql/test/mergetables/Tests/mergequery.stable.out
Branch: default
Log Message:
approved output
diffs (truncated from 469 to 300 lines):
diff --git a/sql/test/mapi/Tests/sql_int128.stable.out.int128
b/sql/test/mapi/Tests/sql_int128.stable.out.int128
--- a/sql/test/mapi/Tests/sql_int128.stable.out.int128
+++ b/sql/test/mapi/Tests/sql_int128.stable.out.int128
@@ -58,83 +58,81 @@ stdout of test 'sql_int128` in directory
% mal # name
% clob # type
% 103 # length
-function user.s4_1():void;
+function user.s4_0():void;
X_2:void := querylog.define("explain set a = 1234567890987654321;":str,
"default_pipe":str, 8:int);
X_5:int := sql.mvc();
sql.setVariable(X_5:int, "a":str, 1234567890987654321:hge);
sql.exportOperation();
-end user.s4_1;
-#inline actions= 0 time=3 usec
-#candidates actions= 1 time=14 usec
-#remap actions= 0 time=6 usec
-#costModel actions= 1 time=12 usec
-#coercions actions= 1 time=13 usec
-#evaluate actions= 1 time=40 usec
-#emptybind actions= 0 time=7 usec
-#pushselect actions= 0 time=5 usec
-#aliases actions= 1 time=16 usec
-#mitosis actions= 0 time=4 usec
-#mergetable actions= 0 time=26 usec
-#deadcode actions= 0 time=8 usec
-#aliases actions= 0 time=7 usec
-#constants actions= 1 time=13 usec
-#commonTerms actions= 0 time=7 usec
-#projectionpath actions= 0 time=6 usec
-#deadcode actions= 0 time=7 usec
-#reorder actions= 1 time=28 usec
-#reduce actions=23 time=65 usec
-#matpack actions= 0 time=8 usec
-#dataflow actions=29 time=27 usec
-#querylog actions= 0 time=1 usec
-#multiplex actions= 0 time=5 usec
-#generator actions= 0 time=3 usec
-#profiler actions= 1 time=8 usec
-#garbageCollector actions= 1 time=21 usec
-#total actions= 1 time=474 usec
+end user.s4_0;
+#inline actions= 0 time=0 usec
+#remap actions= 0 time=1 usec
+#costmodel actions= 1 time=0 usec
+#coercion actions= 0 time=1 usec
+#aliases actions= 1 time=3 usec
+#evaluate actions= 1 time=10 usec
+#emptybind actions= 0 time=0 usec
+#pushselect actions= 0 time=2 usec
+#aliases actions= 1 time=2 usec
+#mergetable actions= 0 time=12 usec
+#deadcode actions= 0 time=3 usec
+#aliases actions= 0 time=0 usec
+#constants actions= 0 time=1 usec
+#commonTerms actions= 0 time=1 usec
+#projectionpath actions= 0 time=1 usec
+#deadcode actions= 0 time=2 usec
+#reorder actions= 1 time=8 usec
+#matpack actions= 0 time=0 usec
+#dataflow actions= 0 time=3 usec
+#multiplex actions= 0 time=1 usec
+#profiler actions= 1 time=1 usec
+#candidates actions= 1 time=1 usec
+#deadcode actions= 0 time=2 usec
+#wlc actions= 0 time=0 usec
+#garbagecollector actions= 1 time=5 usec
+#total actions=29 time=117 usec
#explain SET b = 10000000000;
% .explain # table_name
% mal # name
% clob # type
% 95 # length
-function user.s6_1():void;
+function user.s6_0():void;
X_2:void := querylog.define("explain set b = 10000000000;":str,
"default_pipe":str, 8:int);
X_5:int := sql.mvc();
sql.setVariable(X_5:int, "b":str, 10000000000:hge);
sql.exportOperation();
-end user.s6_1;
-#inline actions= 0 time=3 usec
-#candidates actions= 1 time=13 usec
-#remap actions= 0 time=5 usec
-#costModel actions= 1 time=22 usec
-#coercions actions= 1 time=13 usec
-#evaluate actions= 1 time=30 usec
-#emptybind actions= 0 time=6 usec
-#pushselect actions= 0 time=4 usec
-#aliases actions= 1 time=16 usec
-#mitosis actions= 0 time=4 usec
-#mergetable actions= 0 time=27 usec
-#deadcode actions= 0 time=8 usec
-#aliases actions= 0 time=6 usec
-#constants actions= 1 time=12 usec
-#commonTerms actions= 0 time=7 usec
-#projectionpath actions= 0 time=7 usec
-#deadcode actions= 0 time=7 usec
-#reorder actions= 1 time=39 usec
-#reduce actions=23 time=30 usec
-#matpack actions= 0 time=7 usec
-#dataflow actions=29 time=28 usec
-#querylog actions= 0 time=1 usec
-#multiplex actions= 0 time=6 usec
-#generator actions= 0 time=3 usec
-#profiler actions= 1 time=7 usec
-#garbageCollector actions= 1 time=17 usec
-#total actions= 1 time=444 usec
+end user.s6_0;
+#inline actions= 0 time=1 usec
+#remap actions= 0 time=1 usec
+#costmodel actions= 1 time=1 usec
+#coercion actions= 0 time=1 usec
+#aliases actions= 1 time=2 usec
+#evaluate actions= 1 time=8 usec
+#emptybind actions= 0 time=0 usec
+#pushselect actions= 0 time=2 usec
+#aliases actions= 1 time=2 usec
+#mergetable actions= 0 time=13 usec
+#deadcode actions= 0 time=3 usec
+#aliases actions= 0 time=0 usec
+#constants actions= 0 time=1 usec
+#commonTerms actions= 0 time=1 usec
+#projectionpath actions= 0 time=1 usec
+#deadcode actions= 0 time=2 usec
+#reorder actions= 1 time=8 usec
+#matpack actions= 0 time=0 usec
+#dataflow actions= 0 time=3 usec
+#multiplex actions= 0 time=0 usec
+#profiler actions= 1 time=1 usec
+#candidates actions= 1 time=1 usec
+#deadcode actions= 0 time=2 usec
+#wlc actions= 0 time=0 usec
+#garbagecollector actions= 1 time=5 usec
+#total actions=29 time=116 usec
#explain SET c = a * b;
% .explain # table_name
% mal # name
% clob # type
% 89 # length
-function user.s8_1():void;
+function user.s8_0():void;
X_1:void := querylog.define("explain set c = a * b;":str,
"default_pipe":str, 9:int);
X_4:int := sql.mvc();
X_5:hge := sql.getVariable(X_4:int, "a":str);
@@ -142,40 +140,39 @@ function user.s8_1():void;
X_9:hge := calc.*(X_5:hge, X_7:hge);
sql.setVariable(X_4:int, "c":str, X_9:hge);
sql.exportOperation();
-end user.s8_1;
-#inline actions= 0 time=3 usec
-#candidates actions= 1 time=22 usec
-#remap actions= 0 time=5 usec
-#costModel actions= 1 time=19 usec
-#coercions actions= 3 time=21 usec
-#evaluate actions= 0 time=4 usec
-#emptybind actions= 0 time=6 usec
-#pushselect actions= 0 time=4 usec
-#aliases actions= 0 time=7 usec
-#mitosis actions= 0 time=3 usec
-#mergetable actions= 0 time=34 usec
-#deadcode actions= 0 time=8 usec
-#aliases actions= 0 time=7 usec
-#constants actions= 0 time=4 usec
-#commonTerms actions= 0 time=7 usec
-#projectionpath actions= 0 time=6 usec
-#deadcode actions= 0 time=7 usec
-#reorder actions= 1 time=48 usec
-#reduce actions=23 time=41 usec
-#matpack actions= 0 time=7 usec
-#dataflow actions=31 time=34 usec
-#querylog actions= 0 time=2 usec
-#multiplex actions= 0 time=6 usec
-#generator actions= 0 time=3 usec
-#profiler actions= 1 time=13 usec
-#garbageCollector actions= 1 time=23 usec
-#total actions= 1 time=457 usec
+end user.s8_0;
+#inline actions= 0 time=0 usec
+#remap actions= 0 time=1 usec
+#costmodel actions= 1 time=0 usec
+#coercion actions= 0 time=1 usec
+#aliases actions= 0 time=0 usec
+#evaluate actions= 0 time=3 usec
+#emptybind actions= 0 time=0 usec
+#pushselect actions= 0 time=2 usec
+#aliases actions= 0 time=0 usec
+#mergetable actions= 0 time=18 usec
+#deadcode actions= 0 time=3 usec
+#aliases actions= 0 time=0 usec
+#constants actions= 0 time=1 usec
+#commonTerms actions= 0 time=1 usec
+#projectionpath actions= 0 time=1 usec
+#deadcode actions= 0 time=3 usec
+#reorder actions= 1 time=10 usec
+#matpack actions= 0 time=0 usec
+#dataflow actions= 0 time=4 usec
+#multiplex actions= 0 time=1 usec
+#profiler actions= 1 time=1 usec
+#candidates actions= 1 time=1 usec
+#deadcode actions= 0 time=3 usec
+#wlc actions= 0 time=0 usec
+#garbagecollector actions= 1 time=8 usec
+#total actions=29 time=141 usec
#explain SET d = c * b;
% .explain # table_name
% mal # name
% clob # type
% 89 # length
-function user.s10_1():void;
+function user.s10_0():void;
X_1:void := querylog.define("explain set d = c * b;":str,
"default_pipe":str, 9:int);
X_4:int := sql.mvc();
X_5:hge := sql.getVariable(X_4:int, "c":str);
@@ -183,40 +180,39 @@ function user.s10_1():void;
X_9:hge := calc.*(X_5:hge, X_7:hge);
sql.setVariable(X_4:int, "d":str, X_9:hge);
sql.exportOperation();
-end user.s10_1;
-#inline actions= 0 time=3 usec
-#candidates actions= 1 time=20 usec
-#remap actions= 0 time=6 usec
-#costModel actions= 1 time=19 usec
-#coercions actions= 3 time=20 usec
-#evaluate actions= 0 time=5 usec
-#emptybind actions= 0 time=6 usec
-#pushselect actions= 0 time=5 usec
-#aliases actions= 0 time=7 usec
-#mitosis actions= 0 time=4 usec
-#mergetable actions= 0 time=60 usec
-#deadcode actions= 0 time=9 usec
-#aliases actions= 0 time=7 usec
-#constants actions= 0 time=5 usec
-#commonTerms actions= 0 time=7 usec
-#projectionpath actions= 0 time=6 usec
-#deadcode actions= 0 time=7 usec
-#reorder actions= 1 time=43 usec
-#reduce actions=23 time=19 usec
-#matpack actions= 0 time=8 usec
-#dataflow actions=31 time=34 usec
-#querylog actions= 0 time=1 usec
-#multiplex actions= 0 time=5 usec
-#generator actions= 0 time=3 usec
-#profiler actions= 1 time=14 usec
-#garbageCollector actions= 1 time=22 usec
-#total actions= 1 time=469 usec
+end user.s10_0;
+#inline actions= 0 time=1 usec
+#remap actions= 0 time=1 usec
+#costmodel actions= 1 time=0 usec
+#coercion actions= 0 time=1 usec
+#aliases actions= 0 time=0 usec
+#evaluate actions= 0 time=2 usec
+#emptybind actions= 0 time=0 usec
+#pushselect actions= 0 time=2 usec
+#aliases actions= 0 time=0 usec
+#mergetable actions= 0 time=16 usec
+#deadcode actions= 0 time=4 usec
+#aliases actions= 0 time=0 usec
+#constants actions= 0 time=1 usec
+#commonTerms actions= 0 time=1 usec
+#projectionpath actions= 0 time=1 usec
+#deadcode actions= 0 time=2 usec
+#reorder actions= 1 time=9 usec
+#matpack actions= 0 time=0 usec
+#dataflow actions= 0 time=3 usec
+#multiplex actions= 0 time=1 usec
+#profiler actions= 1 time=0 usec
+#candidates actions= 1 time=1 usec
+#deadcode actions= 0 time=3 usec
+#wlc actions= 0 time=0 usec
+#garbagecollector actions= 1 time=9 usec
+#total actions=29 time=114 usec
#explain SET e = d + a;
% .explain # table_name
% mal # name
% clob # type
% 89 # length
-function user.s12_1():void;
+function user.s12_0():void;
X_1:void := querylog.define("explain set e = d + a;":str,
"default_pipe":str, 9:int);
X_4:int := sql.mvc();
X_5:hge := sql.getVariable(X_4:int, "d":str);
@@ -224,34 +220,33 @@ function user.s12_1():void;
X_9:hge := calc.+(X_5:hge, X_7:hge);
sql.setVariable(X_4:int, "e":str, X_9:hge);
sql.exportOperation();
-end user.s12_1;
-#inline actions= 0 time=3 usec
-#candidates actions= 1 time=19 usec
-#remap actions= 0 time=5 usec
-#costModel actions= 1 time=18 usec
-#coercions actions= 3 time=30 usec
-#evaluate actions= 0 time=4 usec
-#emptybind actions= 0 time=5 usec
-#pushselect actions= 0 time=4 usec
-#aliases actions= 0 time=7 usec
-#mitosis actions= 0 time=3 usec
-#mergetable actions= 0 time=32 usec
-#deadcode actions= 0 time=7 usec
-#aliases actions= 0 time=6 usec
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
