Changeset: e0fe450a89f0 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e0fe450a89f0
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/02-explain.stable.out
sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/03-explain.stable.out
sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/04-explain.stable.out
sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/05-explain.stable.out
sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/06-explain.stable.out
sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/13-explain.stable.out
sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/02-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
sql/benchmarks/tpch/Tests/04-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/13-explain.stable.out
sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
sql/benchmarks/tpch/Tests/16-explain.stable.out
sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
sql/benchmarks/tpch/Tests/21-explain.stable.out
sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/22-explain.stable.out.int128
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128
sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out
sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.stable.err
sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.stable.out
sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out
sql/test/mergetables/Tests/mergequery.stable.out
sql/test/remote/Tests/partition_elim.stable.out
Branch: jit
Log Message:
Approve output
diffs (truncated from 9027 to 300 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
@@ -61,18 +61,25 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 118 # length
+% 115 # length
function user.s4_1():void;
- X_24:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';","default_pipe",12);
-barrier X_34 := language.dataflow();
- X_1 := sql.mvc();
- (X_11:bat[:int],X_12:bat[:int],X_13:bat[:int]) :=
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0);
-exit X_34;
- X_14 := sql.append(X_1,"sys","ttt","a",X_11);
- X_18 := sql.append(X_14,"sys","ttt","b",X_12);
- X_20 := sql.append(X_18,"sys","ttt","c",X_13);
- X_22 := aggr.count(X_13);
- sql.affectedRows(X_20,X_22);
+ sql.mvc();
+ calc.ptr(nil);
+ calc.str("|");
+ calc.str("\\n");
+ calc.str(nil:str);
+ calc.str("null");
+ calc.str("/tmp/xyz");
+ calc.lng(-1);
+ calc.lng(0);
+ calc.int(0);
+ calc.int(0);
+ (X_21:bat[:int],X_22:bat[:int],X_23:bat[:int]) :=
sql.copy_from(X_2,X_4,X_6,X_8,X_10,X_12,X_14,X_16,X_18,X_20);
+ sql.append(X_1,"sys","ttt","a",X_21);
+ sql.append(X_25,"sys","ttt","b",X_22);
+ sql.append(X_30,"sys","ttt","c",X_23);
+ aggr.count(X_23);
+ sql.affectedRows(X_33,X_35);
end user.s4_1;
#declare opt_pipe_name string;
#set opt_pipe_name = ( select optimizer );
@@ -95,18 +102,25 @@ end user.s4_1;
% .explain # table_name
% mal # name
% clob # type
-% 118 # length
+% 115 # length
function user.s12_1():void;
- X_24:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';","user_1",12);
-barrier X_35 := language.dataflow();
- X_1 := sql.mvc();
- (X_11:bat[:int],X_12:bat[:int],X_13:bat[:int]) :=
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0);
-exit X_35;
- X_14 := sql.append(X_1,"sys","ttt","a",X_11);
- X_18 := sql.append(X_14,"sys","ttt","b",X_12);
- X_22 := aggr.count(X_13);
- X_20 := sql.append(X_18,"sys","ttt","c",X_13);
- sql.affectedRows(X_20,X_22);
+ sql.mvc();
+ calc.ptr(nil);
+ calc.str("|");
+ calc.str("\\n");
+ calc.str(nil:str);
+ calc.str("null");
+ calc.str("/tmp/xyz");
+ calc.lng(-1);
+ calc.lng(0);
+ calc.int(0);
+ calc.int(0);
+ (X_21:bat[:int],X_22:bat[:int],X_23:bat[:int]) :=
sql.copy_from(X_2,X_4,X_6,X_8,X_10,X_12,X_14,X_16,X_18,X_20);
+ sql.append(X_1,"sys","ttt","a",X_21);
+ sql.append(X_25,"sys","ttt","b",X_22);
+ sql.append(X_30,"sys","ttt","c",X_23);
+ aggr.count(X_23);
+ sql.affectedRows(X_33,X_35);
end user.s12_1;
#drop table ttt;
diff --git a/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
b/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
--- a/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
+++ b/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
@@ -27,11 +27,13 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 82 # length
+% 66 # length
function user.s2_1(A0:bte,A1:bte):void;
- X_11:void := querylog.define("explain select
fuse(1,2);","sequential_pipe",5);
- X_3:sht := udf.fuse(A0,A1);
- sql.resultSet(".L","fuse_single_value","smallint",16,0,7,X_3);
+ sql.mvc();
+ A0;
+ A1;
+ X_6:sht := udf.fuse(X_4,X_5);
+ sql.resultSet(".L","fuse_single_value","smallint",16,0,7,X_6);
end user.s2_1;
#select fuse(1,2);
% .L # table_name
@@ -43,11 +45,13 @@ end user.s2_1;
% .explain # table_name
% mal # name
% clob # type
-% 88 # length
+% 70 # length
function user.s3_1(A0:sht,A1:sht):void;
- X_11:void := querylog.define("explain select
fuse(1000,2000);","sequential_pipe",5);
- X_3:int := udf.fuse(A0,A1);
- sql.resultSet(".L","fuse_single_value","int",32,0,7,X_3);
+ sql.mvc();
+ A0;
+ A1;
+ X_6:int := udf.fuse(X_4,X_5);
+ sql.resultSet(".L","fuse_single_value","int",32,0,7,X_6);
end user.s3_1;
#select fuse(1000,2000);
% .L # table_name
@@ -59,11 +63,13 @@ end user.s3_1;
% .explain # table_name
% mal # name
% clob # type
-% 94 # length
+% 76 # length
function user.s4_1(A0:int,A1:int):void;
- X_11:void := querylog.define("explain select
fuse(1000000,2000000);","sequential_pipe",5);
- X_3:lng := udf.fuse(A0,A1);
- sql.resultSet(".L","fuse_single_value","bigint",64,0,7,X_3);
+ sql.mvc();
+ A0;
+ A1;
+ X_6:lng := udf.fuse(X_4,X_5);
+ sql.resultSet(".L","fuse_single_value","bigint",64,0,7,X_6);
end user.s4_1;
#select fuse(1000000,2000000);
% .L # table_name
@@ -93,97 +99,94 @@ end user.s4_1;
% .explain # table_name
% mal # name
% clob # type
-% 97 # length
+% 78 # length
function user.s8_1():void;
- X_41:void := querylog.define("explain select fuse(a,b) from
udf_fuse;","sequential_pipe",27);
- X_24 := bat.new(nil:oid,nil:str);
- X_32 := bat.append(X_24,"sys.L");
- X_27 := bat.new(nil:oid,nil:str);
- X_34 := bat.append(X_27,"fuse_a");
- X_28 := bat.new(nil:oid,nil:str);
- X_36 := bat.append(X_28,"smallint");
- X_29 := bat.new(nil:oid,nil:int);
- X_38 := bat.append(X_29,16);
- X_31 := bat.new(nil:oid,nil:int);
- X_40 := bat.append(X_31,0);
- X_1 := sql.mvc();
- C_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
+ sql.mvc();
+ X_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
X_5:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","a",0);
- (C_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","a",2);
+ (X_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","a",2);
X_11:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","a",1);
- X_13 := sql.delta(X_5,C_8,r1_8,X_11);
- X_14 := algebra.projection(C_2,X_13);
+ sql.delta(X_5,X_8,r1_8,X_11);
+ algebra.projection(X_2,X_13);
X_15:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","b",0);
- (C_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","b",2);
+ (X_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","b",2);
X_19:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","b",1);
- X_20 := sql.delta(X_15,C_17,r1_17,X_19);
- X_21 := algebra.projection(C_2,X_20);
- X_22:bat[:sht] := batudf.fuse(X_14,X_21);
- sql.resultSet(X_32,X_34,X_36,X_38,X_40,X_22);
+ sql.delta(X_15,X_17,r1_17,X_19);
+ algebra.projection(X_2,X_20);
+ X_22:bat[:sht] := mal.multiplex("udf","fuse",X_14,X_21);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:int);
+ bat.new(nil:oid,nil:int);
+ bat.append(X_26,"sys.L");
+ bat.append(X_29,"fuse_a");
+ bat.append(X_30,"smallint");
+ bat.append(X_31,16);
+ bat.append(X_33,0);
+ sql.resultSet(X_34,X_36,X_38,X_40,X_42,X_22);
end user.s8_1;
#explain select fuse(c,d) from udf_fuse;
% .explain # table_name
% mal # name
% clob # type
-% 97 # length
+% 78 # length
function user.s9_1():void;
- X_41:void := querylog.define("explain select fuse(c,d) from
udf_fuse;","sequential_pipe",27);
- X_24 := bat.new(nil:oid,nil:str);
- X_32 := bat.append(X_24,"sys.L");
- X_27 := bat.new(nil:oid,nil:str);
- X_34 := bat.append(X_27,"fuse_c");
- X_28 := bat.new(nil:oid,nil:str);
- X_36 := bat.append(X_28,"int");
- X_29 := bat.new(nil:oid,nil:int);
- X_38 := bat.append(X_29,32);
- X_31 := bat.new(nil:oid,nil:int);
- X_40 := bat.append(X_31,0);
- X_1 := sql.mvc();
- C_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
+ sql.mvc();
+ X_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
X_5:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","c",0);
- (C_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","c",2);
+ (X_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","c",2);
X_11:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","c",1);
- X_13 := sql.delta(X_5,C_8,r1_8,X_11);
- X_14 := algebra.projection(C_2,X_13);
+ sql.delta(X_5,X_8,r1_8,X_11);
+ algebra.projection(X_2,X_13);
X_15:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","d",0);
- (C_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","d",2);
+ (X_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","d",2);
X_19:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","d",1);
- X_20 := sql.delta(X_15,C_17,r1_17,X_19);
- X_21 := algebra.projection(C_2,X_20);
- X_22:bat[:int] := batudf.fuse(X_14,X_21);
- sql.resultSet(X_32,X_34,X_36,X_38,X_40,X_22);
+ sql.delta(X_15,X_17,r1_17,X_19);
+ algebra.projection(X_2,X_20);
+ X_22:bat[:int] := mal.multiplex("udf","fuse",X_14,X_21);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:int);
+ bat.new(nil:oid,nil:int);
+ bat.append(X_26,"sys.L");
+ bat.append(X_29,"fuse_c");
+ bat.append(X_30,"int");
+ bat.append(X_31,32);
+ bat.append(X_33,0);
+ sql.resultSet(X_34,X_36,X_38,X_40,X_42,X_22);
end user.s9_1;
#explain select fuse(e,f) from udf_fuse;
% .explain # table_name
% mal # name
% clob # type
-% 97 # length
+% 78 # length
function user.s10_1():void;
- X_41:void := querylog.define("explain select fuse(e,f) from
udf_fuse;","sequential_pipe",27);
- X_24 := bat.new(nil:oid,nil:str);
- X_32 := bat.append(X_24,"sys.L");
- X_27 := bat.new(nil:oid,nil:str);
- X_34 := bat.append(X_27,"fuse_e");
- X_28 := bat.new(nil:oid,nil:str);
- X_36 := bat.append(X_28,"bigint");
- X_29 := bat.new(nil:oid,nil:int);
- X_38 := bat.append(X_29,64);
- X_31 := bat.new(nil:oid,nil:int);
- X_40 := bat.append(X_31,0);
- X_1 := sql.mvc();
- C_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
+ sql.mvc();
+ X_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
X_5:bat[:int] := sql.bind(X_1,"sys","udf_fuse","e",0);
- (C_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","e",2);
+ (X_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","e",2);
X_11:bat[:int] := sql.bind(X_1,"sys","udf_fuse","e",1);
- X_13 := sql.delta(X_5,C_8,r1_8,X_11);
- X_14 := algebra.projection(C_2,X_13);
+ sql.delta(X_5,X_8,r1_8,X_11);
+ algebra.projection(X_2,X_13);
X_15:bat[:int] := sql.bind(X_1,"sys","udf_fuse","f",0);
- (C_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","f",2);
+ (X_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","f",2);
X_19:bat[:int] := sql.bind(X_1,"sys","udf_fuse","f",1);
- X_20 := sql.delta(X_15,C_17,r1_17,X_19);
- X_21 := algebra.projection(C_2,X_20);
- X_22:bat[:lng] := batudf.fuse(X_14,X_21);
- sql.resultSet(X_32,X_34,X_36,X_38,X_40,X_22);
+ sql.delta(X_15,X_17,r1_17,X_19);
+ algebra.projection(X_2,X_20);
+ X_22:bat[:lng] := mal.multiplex("udf","fuse",X_14,X_21);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:str);
+ bat.new(nil:oid,nil:int);
+ bat.new(nil:oid,nil:int);
+ bat.append(X_26,"sys.L");
+ bat.append(X_29,"fuse_e");
+ bat.append(X_30,"bigint");
+ bat.append(X_31,64);
+ bat.append(X_33,0);
+ sql.resultSet(X_34,X_36,X_38,X_40,X_42,X_22);
end user.s10_1;
#select fuse(a,b) from udf_fuse;
% sys.L # table_name
diff --git a/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
b/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
--- a/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
+++ b/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
@@ -48,11 +48,12 @@ Ready.
% .explain # table_name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
