Changeset: d5ddbee32495 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d5ddbee32495
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.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-2015/Tests/useless_casts.Bug-3756.stable.out
sql/test/Tests/setoptimizer.stable.out
sql/test/Tests/setoptimizer.stable.out.Windows
sql/test/remote/Tests/partition_elim.stable.out
Branch: default
Log Message:
Approve output
diffs (truncated from 916 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
@@ -56,7 +56,7 @@ Ready.
% def # name
% clob # type
% 541 # length
-[
"optimizer.inline();optimizer.candidates();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.garbageCollector();"
]
+[
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.garbageCollector();"
]
#explain copy into ttt from '/tmp/xyz';
% .explain # table_name
% mal # name
@@ -90,7 +90,7 @@ end user.s4_1;
% def # name
% clob # type
% 564 # length
-[
"optimizer.inline();optimizer.candidates();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.sql_append();optimizer.garbageCollector();"
]
+[
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.sql_append();optimizer.garbageCollector();"
]
#explain copy into ttt from '/tmp/xyz';
% .explain # table_name
% mal # name
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
@@ -56,7 +56,7 @@ Ready.
% def # name
% clob # type
% 541 # length
-[
"optimizer.inline();optimizer.candidates();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.garbageCollector();"
]
+[
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.garbageCollector();"
]
#explain copy into ttt from '/tmp/xyz';
% .explain # table_name
% mal # name
@@ -88,7 +88,7 @@ end user.s4_1;
% def # name
% clob # type
% 564 # length
-[
"optimizer.inline();optimizer.candidates();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.sql_append();optimizer.garbageCollector();"
]
+[
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.evaluate();optimizer.pushselect();optimizer.aliases();optimizer.mitosis();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.reduce();optimizer.matpack();optimizer.dataflow();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.sql_append();optimizer.garbageCollector();"
]
#explain copy into ttt from '/tmp/xyz';
% .explain # table_name
% mal # name
diff --git
a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
---
a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
+++
b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
@@ -131,12 +131,12 @@ function user.s4_1(A0:str):void;
C_64 := algebra.ilikesubselect(r1_9,nil:bat[:oid],A0,"",false);
X_12:bat[:str] := sql.bind(X_2,"sys","functions","name",1);
C_66 := algebra.ilikesubselect(X_12,C_3,A0,"",false);
- X_15 := sql.subdelta(C_63,C_3,C_9,C_64,C_66);
- X_17 := sql.projectdelta(X_15,X_6,C_9,r1_9,X_12);
+ C_15 := sql.subdelta(C_63,C_3,C_9,C_64,C_66);
+ X_17 := sql.projectdelta(C_15,X_6,C_9,r1_9,X_12);
X_18:bat[:str] := sql.bind(X_2,"sys","functions","func",0);
(C_20,r1_25) := sql.bind(X_2,"sys","functions","func",2);
X_22:bat[:str] := sql.bind(X_2,"sys","functions","func",1);
- X_23 := sql.projectdelta(X_15,X_18,C_20,r1_25,X_22);
+ X_23 := sql.projectdelta(C_15,X_18,C_20,r1_25,X_22);
sql.resultSet(X_41,X_42,X_43,X_44,X_46,X_17,X_23);
end user.s4_1;
#explain select name,func from functions where name not ilike '%optimizers%';
@@ -169,12 +169,12 @@ function user.s5_1(A0:str):void;
C_64 := algebra.ilikesubselect(r1_9,nil:bat[:oid],A0,"",true);
X_12:bat[:str] := sql.bind(X_2,"sys","functions","name",1);
C_66 := algebra.ilikesubselect(X_12,C_3,A0,"",true);
- X_15 := sql.subdelta(C_63,C_3,C_9,C_64,C_66);
- X_17 := sql.projectdelta(X_15,X_6,C_9,r1_9,X_12);
+ C_15 := sql.subdelta(C_63,C_3,C_9,C_64,C_66);
+ X_17 := sql.projectdelta(C_15,X_6,C_9,r1_9,X_12);
X_18:bat[:str] := sql.bind(X_2,"sys","functions","func",0);
(C_20,r1_25) := sql.bind(X_2,"sys","functions","func",2);
X_22:bat[:str] := sql.bind(X_2,"sys","functions","func",1);
- X_23 := sql.projectdelta(X_15,X_18,C_20,r1_25,X_22);
+ X_23 := sql.projectdelta(C_15,X_18,C_20,r1_25,X_22);
sql.resultSet(X_41,X_42,X_43,X_44,X_46,X_17,X_23);
end user.s5_1;
#create function contains(str string, substr string)
diff --git a/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
b/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
--- a/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
+++ b/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
@@ -45,48 +45,77 @@ Ready.
% clob # type
% 206 # length
function user.s5_1(A0:timestamp,A1:timestamp,A2:void):void;
- X_67:void := querylog.define("explain select (t-(select timestamp
\\'1970-1-1\\')),v from foo_nil_2dec union all select (t-(select timestamp
\\'1970-1-1\\')),null from foo_nil_2dec;","default_pipe",44);
- X_45 := bat.new(nil:oid,nil:str);
- X_52 := bat.append(X_45,".L5");
- X_61 := bat.append(X_52,".L5");
- X_47 := bat.new(nil:oid,nil:str);
- X_54 := bat.append(X_47,"L2");
- X_62 := bat.append(X_54,"v");
- X_48 := bat.new(nil:oid,nil:str);
- X_56 := bat.append(X_48,"sec_interval");
- X_63 := bat.append(X_56,"decimal");
- X_49 := bat.new(nil:oid,nil:int);
- X_58 := bat.append(X_49,13);
- X_65 := bat.append(X_58,18);
- X_51 := bat.new(nil:oid,nil:int);
- X_60 := bat.append(X_51,0);
- X_66 := bat.append(X_60,9);
+ X_62:void := querylog.define("explain select (t-(select timestamp
\\'1970-1-1\\')),v from foo_nil_2dec union all select (t-(select timestamp
\\'1970-1-1\\')),null from foo_nil_2dec;","default_pipe",73);
+barrier X_129 := language.dataflow();
+ X_40 := bat.new(nil:oid,nil:str);
+ X_47 := bat.append(X_40,".L5");
+ X_56 := bat.append(X_47,".L5");
+ X_42 := bat.new(nil:oid,nil:str);
+ X_49 := bat.append(X_42,"L2");
+ X_57 := bat.append(X_49,"v");
+ X_43 := bat.new(nil:oid,nil:str);
+ X_51 := bat.append(X_43,"sec_interval");
+ X_58 := bat.append(X_51,"decimal");
+ X_44 := bat.new(nil:oid,nil:int);
+ X_53 := bat.append(X_44,13);
+ X_60 := bat.append(X_53,18);
+ X_46 := bat.new(nil:oid,nil:int);
+ X_55 := bat.append(X_46,0);
+ X_61 := bat.append(X_55,9);
X_5:bat[:lng] := bat.new(nil:oid,nil:lng);
X_4 := sql.mvc();
- C_8:bat[:oid] := sql.tid(X_4,"sys","foo_nil_2dec");
- X_11:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",0);
- (C_14,r1_14) := sql.bind(X_4,"sys","foo_nil_2dec","t",2);
- X_17:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",1);
- X_19 := sql.delta(X_11,C_14,r1_14,X_17);
- X_20 := algebra.projection(C_8,X_19);
- X_21 := calc.timestamp(A0,7);
- X_23 := algebra.project(X_20,X_21);
- X_24:bat[:lng] := batmtime.diff(X_20,X_23);
- X_25 := bat.append(X_5,X_24,true);
- X_27 := calc.timestamp(A1,7);
- X_28 := algebra.project(X_20,X_27);
- X_29:bat[:lng] := batmtime.diff(X_20,X_28);
- X_30 := bat.append(X_25,X_29,true);
- X_31:bat[:lng] := bat.new(nil:oid,nil:lng);
- X_32:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",0);
- (C_34,r1_47) := sql.bind(X_4,"sys","foo_nil_2dec","v",2);
- X_36:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",1);
- X_37 := sql.delta(X_32,C_34,r1_47,X_36);
- X_38 := algebra.projection(C_8,X_37);
- X_39 := bat.append(X_31,X_38,true);
- X_42 := algebra.project(X_29,nil:lng);
- X_43 := bat.append(X_39,X_42,true);
- sql.resultSet(X_61,X_62,X_63,X_65,X_66,X_30,X_43);
+ C_80:bat[:oid] := sql.tid(X_4,"sys","foo_nil_2dec",0,2);
+ X_82:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",0,0,2);
+ (C_84:bat[:oid],X_85:bat[:timestamp]) :=
sql.bind(X_4,"sys","foo_nil_2dec","t",2,0,2);
+ X_95 := sql.delta(X_82,C_84,X_85);
+ X_97 := algebra.projection(C_80,X_95);
+ X_15 := calc.timestamp(A0,7);
+ X_99 := algebra.project(X_97,X_15);
+ X_101 := batmtime.diff(X_97,X_99);
+ C_81:bat[:oid] := sql.tid(X_4,"sys","foo_nil_2dec",1,2);
+ X_83:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",0,1,2);
+ (C_86:bat[:oid],X_87:bat[:timestamp]) :=
sql.bind(X_4,"sys","foo_nil_2dec","t",2,1,2);
+ X_13:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",1);
+ X_96 := sql.delta(X_83,C_86,X_87,X_13);
+ X_98 := algebra.projection(C_81,X_96);
+ X_100 := algebra.project(X_98,X_15);
+ X_102 := batmtime.diff(X_98,X_100);
+ X_116 := mat.packIncrement(X_101,2);
+ X_17:bat[:lng] := mat.packIncrement(X_116,X_102);
+ X_18 := bat.append(X_5,X_17,true);
+ C_20:bat[:oid] := sql.tid(X_4,"sys","foo_nil_2dec");
+ X_21:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",0);
+ (C_22,r1_32) := sql.bind(X_4,"sys","foo_nil_2dec","t",2);
+ X_24 := sql.delta(X_21,C_22,r1_32,X_13);
+ X_25 := algebra.projection(C_20,X_24);
+ X_26 := calc.timestamp(A1,7);
+ X_27 := algebra.project(X_25,X_26);
+ X_28:bat[:lng] := batmtime.diff(X_25,X_27);
+ X_29 := bat.append(X_18,X_28,true);
+ X_30:bat[:lng] := bat.new(nil:oid,nil:lng);
+ X_88:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",0,0,2);
+ (C_90:bat[:oid],X_91:bat[:lng]) :=
sql.bind(X_4,"sys","foo_nil_2dec","v",2,0,2);
+ X_103 := sql.delta(X_88,C_90,X_91);
+ X_105 := algebra.projection(C_80,X_103);
+ X_89:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",0,1,2);
+ (C_92:bat[:oid],X_93:bat[:lng]) :=
sql.bind(X_4,"sys","foo_nil_2dec","v",2,1,2);
+ X_32:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",1);
+ X_104 := sql.delta(X_89,C_92,X_93,X_32);
+ X_106 := algebra.projection(C_81,X_104);
+ X_119 := mat.packIncrement(X_105,2);
+ X_33 := mat.packIncrement(X_119,X_106);
+ X_34 := bat.append(X_30,X_33,true);
+ X_37 := algebra.project(X_28,nil:lng);
+ X_38 := bat.append(X_34,X_37,true);
+ language.pass(X_97);
+ language.pass(X_98);
+ language.pass(X_13);
+ language.pass(X_25);
+ language.pass(C_80);
+ language.pass(C_81);
+ language.pass(X_28);
+exit X_129;
+ sql.resultSet(X_56,X_57,X_58,X_60,X_61,X_29,X_38);
end user.s5_1;
# 23:28:04 >
diff --git
a/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
b/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
--- a/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
+++ b/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
@@ -45,48 +45,77 @@ Ready.
% clob # type
% 206 # length
function user.s5_1(A0:timestamp,A1:timestamp,A2:void):void;
- X_67:void := querylog.define("explain select (t-(select timestamp
\\'1970-1-1\\')),v from foo_nil_2dec union all select (t-(select timestamp
\\'1970-1-1\\')),null from foo_nil_2dec;","default_pipe",44);
- X_45 := bat.new(nil:oid,nil:str);
- X_52 := bat.append(X_45,".L5");
- X_61 := bat.append(X_52,".L5");
- X_47 := bat.new(nil:oid,nil:str);
- X_54 := bat.append(X_47,"L2");
- X_62 := bat.append(X_54,"v");
- X_48 := bat.new(nil:oid,nil:str);
- X_56 := bat.append(X_48,"sec_interval");
- X_63 := bat.append(X_56,"decimal");
- X_49 := bat.new(nil:oid,nil:int);
- X_58 := bat.append(X_49,13);
- X_65 := bat.append(X_58,18);
- X_51 := bat.new(nil:oid,nil:int);
- X_60 := bat.append(X_51,0);
- X_66 := bat.append(X_60,9);
+ X_62:void := querylog.define("explain select (t-(select timestamp
\\'1970-1-1\\')),v from foo_nil_2dec union all select (t-(select timestamp
\\'1970-1-1\\')),null from foo_nil_2dec;","default_pipe",73);
+barrier X_129 := language.dataflow();
+ X_40 := bat.new(nil:oid,nil:str);
+ X_47 := bat.append(X_40,".L5");
+ X_56 := bat.append(X_47,".L5");
+ X_42 := bat.new(nil:oid,nil:str);
+ X_49 := bat.append(X_42,"L2");
+ X_57 := bat.append(X_49,"v");
+ X_43 := bat.new(nil:oid,nil:str);
+ X_51 := bat.append(X_43,"sec_interval");
+ X_58 := bat.append(X_51,"decimal");
+ X_44 := bat.new(nil:oid,nil:int);
+ X_53 := bat.append(X_44,13);
+ X_60 := bat.append(X_53,18);
+ X_46 := bat.new(nil:oid,nil:int);
+ X_55 := bat.append(X_46,0);
+ X_61 := bat.append(X_55,9);
X_5:bat[:lng] := bat.new(nil:oid,nil:lng);
X_4 := sql.mvc();
- C_8:bat[:oid] := sql.tid(X_4,"sys","foo_nil_2dec");
- X_11:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",0);
- (C_14,r1_14) := sql.bind(X_4,"sys","foo_nil_2dec","t",2);
- X_17:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",1);
- X_19 := sql.delta(X_11,C_14,r1_14,X_17);
- X_20 := algebra.projection(C_8,X_19);
- X_21 := calc.timestamp(A0,7);
- X_23 := algebra.project(X_20,X_21);
- X_24:bat[:lng] := batmtime.diff(X_20,X_23);
- X_25 := bat.append(X_5,X_24,true);
- X_27 := calc.timestamp(A1,7);
- X_28 := algebra.project(X_20,X_27);
- X_29:bat[:lng] := batmtime.diff(X_20,X_28);
- X_30 := bat.append(X_25,X_29,true);
- X_31:bat[:lng] := bat.new(nil:oid,nil:lng);
- X_32:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",0);
- (C_34,r1_47) := sql.bind(X_4,"sys","foo_nil_2dec","v",2);
- X_36:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",1);
- X_37 := sql.delta(X_32,C_34,r1_47,X_36);
- X_38 := algebra.projection(C_8,X_37);
- X_39 := bat.append(X_31,X_38,true);
- X_42 := algebra.project(X_29,nil:lng);
- X_43 := bat.append(X_39,X_42,true);
- sql.resultSet(X_61,X_62,X_63,X_65,X_66,X_30,X_43);
+ C_80:bat[:oid] := sql.tid(X_4,"sys","foo_nil_2dec",0,2);
+ X_82:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",0,0,2);
+ (C_84:bat[:oid],X_85:bat[:timestamp]) :=
sql.bind(X_4,"sys","foo_nil_2dec","t",2,0,2);
+ X_95 := sql.delta(X_82,C_84,X_85);
+ X_97 := algebra.projection(C_80,X_95);
+ X_15 := calc.timestamp(A0,7);
+ X_99 := algebra.project(X_97,X_15);
+ X_101 := batmtime.diff(X_97,X_99);
+ C_81:bat[:oid] := sql.tid(X_4,"sys","foo_nil_2dec",1,2);
+ X_83:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",0,1,2);
+ (C_86:bat[:oid],X_87:bat[:timestamp]) :=
sql.bind(X_4,"sys","foo_nil_2dec","t",2,1,2);
+ X_13:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",1);
+ X_96 := sql.delta(X_83,C_86,X_87,X_13);
+ X_98 := algebra.projection(C_81,X_96);
+ X_100 := algebra.project(X_98,X_15);
+ X_102 := batmtime.diff(X_98,X_100);
+ X_116 := mat.packIncrement(X_101,2);
+ X_17:bat[:lng] := mat.packIncrement(X_116,X_102);
+ X_18 := bat.append(X_5,X_17,true);
+ C_20:bat[:oid] := sql.tid(X_4,"sys","foo_nil_2dec");
+ X_21:bat[:timestamp] := sql.bind(X_4,"sys","foo_nil_2dec","t",0);
+ (C_22,r1_32) := sql.bind(X_4,"sys","foo_nil_2dec","t",2);
+ X_24 := sql.delta(X_21,C_22,r1_32,X_13);
+ X_25 := algebra.projection(C_20,X_24);
+ X_26 := calc.timestamp(A1,7);
+ X_27 := algebra.project(X_25,X_26);
+ X_28:bat[:lng] := batmtime.diff(X_25,X_27);
+ X_29 := bat.append(X_18,X_28,true);
+ X_30:bat[:lng] := bat.new(nil:oid,nil:lng);
+ X_88:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",0,0,2);
+ (C_90:bat[:oid],X_91:bat[:lng]) :=
sql.bind(X_4,"sys","foo_nil_2dec","v",2,0,2);
+ X_103 := sql.delta(X_88,C_90,X_91);
+ X_105 := algebra.projection(C_80,X_103);
+ X_89:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",0,1,2);
+ (C_92:bat[:oid],X_93:bat[:lng]) :=
sql.bind(X_4,"sys","foo_nil_2dec","v",2,1,2);
+ X_32:bat[:lng] := sql.bind(X_4,"sys","foo_nil_2dec","v",1);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
