Changeset: 6074e07bf71a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6074e07bf71a
Modified Files:
        monetdb5/modules/mal/mosaic.mal
        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-2013/Tests/between.Bug-3259.stable.out.int128
        sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
        sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
        sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
        sql/test/leaks/Tests/check1_bam.stable.out.int128
        sql/test/leaks/Tests/check2_bam.stable.out.int128
        sql/test/leaks/Tests/check3_bam.stable.out.int128
        sql/test/leaks/Tests/check4_bam.stable.out.int128
        sql/test/leaks/Tests/check5_bam.stable.out.int128
        sql/test/mergetables/Tests/mergequery.stable.out
        sql/test/mosaic/Tests/xqueries_delta.stable.out
        sql/test/mosaic/Tests/xqueries_rle.stable.out
Branch: mosaic
Log Message:

Approve output after merge


diffs (truncated from 1536 to 300 lines):

diff --git a/monetdb5/modules/mal/mosaic.mal b/monetdb5/modules/mal/mosaic.mal
--- a/monetdb5/modules/mal/mosaic.mal
+++ b/monetdb5/modules/mal/mosaic.mal
@@ -225,6 +225,9 @@ address MOSleftfetchjoin;
 pattern leftfetchjoin(b:bat[:oid,:oid], cand:bat[:oid,:lng]) :bat[:oid,:lng]
 address MOSleftfetchjoin;
 
+pattern leftfetchjoin(b:bat[:oid,:oid], cand:bat[:oid,:hge]) :bat[:oid,:hge]
+address MOSleftfetchjoin;
+
 pattern leftfetchjoin(b:bat[:oid,:oid], cand:bat[:oid,:oid]) :bat[:oid,:oid]
 address MOSleftfetchjoin;
 
diff --git 
a/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128 
b/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128
--- a/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128
+++ b/sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128
@@ -49,11 +49,11 @@ function user.s4_1(A0:hge,A1:bte):void;
     X_3 := sql.mvc();
     X_4:bat[:oid,:oid]  := sql.tid(X_3,"sys","dbg");
     X_7:bat[:oid,:int]  := sql.bind(X_3,"sys","dbg","a",0);
-    X_10 := algebra.leftfetchjoin(X_4,X_7);
+    X_10 := mosaic.leftfetchjoin(X_4,X_7);
     (X_11,r1_11,r2_11) := group.subgroupdone(X_10);
     X_14 := algebra.leftfetchjoin(r1_11,X_10);
     X_15:bat[:oid,:int]  := sql.bind(X_3,"sys","dbg","b",0);
-    X_17 := algebra.leftfetchjoin(X_4,X_15);
+    X_17 := mosaic.leftfetchjoin(X_4,X_15);
     X_18:bat[:oid,:hge]  := aggr.subsum(X_17,X_11,r1_11,true,true);
     X_20 := algebra.project(X_10,A1);
     X_21 := algebra.leftfetchjoin(r1_11,X_20);
@@ -102,11 +102,11 @@ function user.s10_1(A0:hge,A1:bte):void;
     X_3 := sql.mvc();
     X_4:bat[:oid,:oid]  := sql.tid(X_3,"sys","dbg");
     X_7:bat[:oid,:int]  := sql.bind(X_3,"sys","dbg","a",0);
-    X_10 := algebra.leftfetchjoin(X_4,X_7);
+    X_10 := mosaic.leftfetchjoin(X_4,X_7);
     (X_11,r1_11,r2_11) := group.subgroupdone(X_10);
     X_14 := algebra.leftfetchjoin(r1_11,X_10);
     X_15:bat[:oid,:int]  := sql.bind(X_3,"sys","dbg","b",0);
-    X_17 := algebra.leftfetchjoin(X_4,X_15);
+    X_17 := mosaic.leftfetchjoin(X_4,X_15);
     X_18:bat[:oid,:hge]  := aggr.subsum(X_17,X_11,r1_11,true,true);
     X_20 := algebra.project(X_10,A1);
     X_21 := algebra.leftfetchjoin(r1_11,X_20);
diff --git 
a/sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out 
b/sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
--- a/sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
+++ b/sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
@@ -42,9 +42,9 @@ function user.s5_1{autoCommit=true}(A0:f
     X_15 := sql.delta(X_7,X_10,r1_10,X_13);
     X_16 := X_15;
     X_17 := batcalc.flt(X_16);
-    X_41 := batmmath.log10(X_17);
+    X_42 := batmmath.log10(X_17);
     X_4:bat[:oid,:oid]  := sql.tid(X_3,"sys","tab_2826");
-    X_18 := algebra.thetasubselect(X_41,X_4,A0,">");
+    X_18 := algebra.thetasubselect(X_42,X_4,A0,">");
     X_20 := sql.projectdelta(X_18,X_7,X_10,r1_10,X_13);
     X_21 := sql.resultSet(1,1,X_20);
     sql.rsColumn(X_21,"sys.tab_2826","d","double",53,0,X_20);
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
@@ -34,12 +34,12 @@ function user.s2_1(A0:str):void;
     X_2 := sql.mvc();
     X_6:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",0);
     X_3:bat[:oid,:oid]  := sql.tid(X_2,"sys","functions");
-    X_47 := algebra.likesubselect(X_6,X_3,A0,"",false);
+    X_48 := algebra.likesubselect(X_6,X_3,A0,"",false);
     (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2);
-    X_48 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],A0,"",false);
+    X_49 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],A0,"",false);
     X_12:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",1);
-    X_50 := algebra.likesubselect(X_12,X_3,A0,"",false);
-    X_15 := sql.subdelta(X_47,X_3,X_9,X_48,X_50);
+    X_51 := algebra.likesubselect(X_12,X_3,A0,"",false);
+    X_15 := sql.subdelta(X_48,X_3,X_9,X_49,X_51);
     X_17 := sql.projectdelta(X_15,X_6,X_9,r1_9,X_12);
     X_18:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","func",0);
     (X_20,r1_25) := sql.bind(X_2,"sys","functions","func",2);
@@ -61,12 +61,12 @@ function user.s3_1(A0:str):void;
     X_2 := sql.mvc();
     X_6:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",0);
     X_3:bat[:oid,:oid]  := sql.tid(X_2,"sys","functions");
-    X_47 := algebra.likesubselect(X_6,X_3,A0,"",true);
+    X_48 := algebra.likesubselect(X_6,X_3,A0,"",true);
     (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2);
-    X_48 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],A0,"",true);
+    X_49 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],A0,"",true);
     X_12:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",1);
-    X_50 := algebra.likesubselect(X_12,X_3,A0,"",true);
-    X_15 := sql.subdelta(X_47,X_3,X_9,X_48,X_50);
+    X_51 := algebra.likesubselect(X_12,X_3,A0,"",true);
+    X_15 := sql.subdelta(X_48,X_3,X_9,X_49,X_51);
     X_17 := sql.projectdelta(X_15,X_6,X_9,r1_9,X_12);
     X_18:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","func",0);
     (X_20,r1_25) := sql.bind(X_2,"sys","functions","func",2);
@@ -88,12 +88,12 @@ function user.s4_1(A0:str):void;
     X_2 := sql.mvc();
     X_6:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",0);
     X_3:bat[:oid,:oid]  := sql.tid(X_2,"sys","functions");
-    X_47 := algebra.ilikesubselect(X_6,X_3,A0,"",false);
+    X_48 := algebra.ilikesubselect(X_6,X_3,A0,"",false);
     (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2);
-    X_48 := algebra.ilikesubselect(r1_9,nil:bat[:oid,:oid],A0,"",false);
+    X_49 := algebra.ilikesubselect(r1_9,nil:bat[:oid,:oid],A0,"",false);
     X_12:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",1);
-    X_50 := algebra.ilikesubselect(X_12,X_3,A0,"",false);
-    X_15 := sql.subdelta(X_47,X_3,X_9,X_48,X_50);
+    X_51 := algebra.ilikesubselect(X_12,X_3,A0,"",false);
+    X_15 := sql.subdelta(X_48,X_3,X_9,X_49,X_51);
     X_17 := sql.projectdelta(X_15,X_6,X_9,r1_9,X_12);
     X_18:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","func",0);
     (X_20,r1_25) := sql.bind(X_2,"sys","functions","func",2);
@@ -115,12 +115,12 @@ function user.s5_1(A0:str):void;
     X_2 := sql.mvc();
     X_6:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",0);
     X_3:bat[:oid,:oid]  := sql.tid(X_2,"sys","functions");
-    X_47 := algebra.ilikesubselect(X_6,X_3,A0,"",true);
+    X_48 := algebra.ilikesubselect(X_6,X_3,A0,"",true);
     (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2);
-    X_48 := algebra.ilikesubselect(r1_9,nil:bat[:oid,:oid],A0,"",true);
+    X_49 := algebra.ilikesubselect(r1_9,nil:bat[:oid,:oid],A0,"",true);
     X_12:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",1);
-    X_50 := algebra.ilikesubselect(X_12,X_3,A0,"",true);
-    X_15 := sql.subdelta(X_47,X_3,X_9,X_48,X_50);
+    X_51 := algebra.ilikesubselect(X_12,X_3,A0,"",true);
+    X_15 := sql.subdelta(X_48,X_3,X_9,X_49,X_51);
     X_17 := sql.projectdelta(X_15,X_6,X_9,r1_9,X_12);
     X_18:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","func",0);
     (X_20,r1_25) := sql.bind(X_2,"sys","functions","func",2);
@@ -162,14 +162,14 @@ function user.s10_1(A0:str):void;
     X_2 := sql.mvc();
     X_6:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",0);
     X_3:bat[:oid,:oid]  := sql.tid(X_2,"sys","functions");
-    X_46 := calc.+("%",A0);
-    X_47 := calc.+(X_46,"%");
-    X_50 := algebra.likesubselect(X_6,X_3,X_47,"",false,false);
+    X_47 := calc.+("%",A0);
+    X_48 := calc.+(X_47,"%");
+    X_51 := algebra.likesubselect(X_6,X_3,X_48,"",false,false);
     (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2);
-    X_51 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],X_47,"",false,false);
+    X_52 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],X_48,"",false,false);
     X_12:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",1);
-    X_53 := algebra.likesubselect(X_12,X_3,X_47,"",false,false);
-    X_14 := sql.subdelta(X_50,X_3,X_9,X_51,X_53);
+    X_54 := algebra.likesubselect(X_12,X_3,X_48,"",false,false);
+    X_14 := sql.subdelta(X_51,X_3,X_9,X_52,X_54);
     X_15 := sql.projectdelta(X_14,X_6,X_9,r1_9,X_12);
     X_16:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","func",0);
     (X_18,r1_27) := sql.bind(X_2,"sys","functions","func",2);
@@ -191,14 +191,14 @@ function user.s11_1(A0:str):void;
     X_2 := sql.mvc();
     X_6:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",0);
     X_3:bat[:oid,:oid]  := sql.tid(X_2,"sys","functions");
-    X_46 := calc.+("%",A0);
-    X_47 := calc.+(X_46,"%");
-    X_51 := algebra.likesubselect(X_6,X_3,X_47,"",false,true);
+    X_47 := calc.+("%",A0);
+    X_48 := calc.+(X_47,"%");
+    X_52 := algebra.likesubselect(X_6,X_3,X_48,"",false,true);
     (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2);
-    X_52 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],X_47,"",false,true);
+    X_53 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],X_48,"",false,true);
     X_12:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",1);
-    X_54 := algebra.likesubselect(X_12,X_3,X_47,"",false,true);
-    X_14 := sql.subdelta(X_51,X_3,X_9,X_52,X_54);
+    X_55 := algebra.likesubselect(X_12,X_3,X_48,"",false,true);
+    X_14 := sql.subdelta(X_52,X_3,X_9,X_53,X_55);
     X_15 := sql.projectdelta(X_14,X_6,X_9,r1_9,X_12);
     X_16:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","func",0);
     (X_18,r1_27) := sql.bind(X_2,"sys","functions","func",2);
@@ -220,14 +220,14 @@ function user.s12_1(A0:str):void;
     X_2 := sql.mvc();
     X_6:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",0);
     X_3:bat[:oid,:oid]  := sql.tid(X_2,"sys","functions");
-    X_46 := calc.+("%",A0);
-    X_47 := calc.+(X_46,"%");
-    X_51 := algebra.likesubselect(X_6,X_3,X_47,"",true,false);
+    X_47 := calc.+("%",A0);
+    X_48 := calc.+(X_47,"%");
+    X_52 := algebra.likesubselect(X_6,X_3,X_48,"",true,false);
     (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2);
-    X_52 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],X_47,"",true,false);
+    X_53 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],X_48,"",true,false);
     X_12:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",1);
-    X_54 := algebra.likesubselect(X_12,X_3,X_47,"",true,false);
-    X_14 := sql.subdelta(X_51,X_3,X_9,X_52,X_54);
+    X_55 := algebra.likesubselect(X_12,X_3,X_48,"",true,false);
+    X_14 := sql.subdelta(X_52,X_3,X_9,X_53,X_55);
     X_15 := sql.projectdelta(X_14,X_6,X_9,r1_9,X_12);
     X_16:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","func",0);
     (X_18,r1_27) := sql.bind(X_2,"sys","functions","func",2);
@@ -249,14 +249,14 @@ function user.s13_1(A0:str):void;
     X_2 := sql.mvc();
     X_6:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",0);
     X_3:bat[:oid,:oid]  := sql.tid(X_2,"sys","functions");
-    X_46 := calc.+("%",A0);
-    X_47 := calc.+(X_46,"%");
-    X_50 := algebra.likesubselect(X_6,X_3,X_47,"",true,true);
+    X_47 := calc.+("%",A0);
+    X_48 := calc.+(X_47,"%");
+    X_51 := algebra.likesubselect(X_6,X_3,X_48,"",true,true);
     (X_9,r1_9) := sql.bind(X_2,"sys","functions","name",2);
-    X_51 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],X_47,"",true,true);
+    X_52 := algebra.likesubselect(r1_9,nil:bat[:oid,:oid],X_48,"",true,true);
     X_12:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","name",1);
-    X_53 := algebra.likesubselect(X_12,X_3,X_47,"",true,true);
-    X_14 := sql.subdelta(X_50,X_3,X_9,X_51,X_53);
+    X_54 := algebra.likesubselect(X_12,X_3,X_48,"",true,true);
+    X_14 := sql.subdelta(X_51,X_3,X_9,X_52,X_54);
     X_15 := sql.projectdelta(X_14,X_6,X_9,r1_9,X_12);
     X_16:bat[:oid,:str]  := sql.bind(X_2,"sys","functions","func",0);
     (X_18,r1_27) := sql.bind(X_2,"sys","functions","func",2);
diff --git a/sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128 
b/sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128
--- a/sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128
+++ b/sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128
@@ -46,26 +46,26 @@ Ready.
 % clob # type
 % 173 # length
 function user.s2_1():void;
-barrier X_50 := language.dataflow();
+barrier X_51 := language.dataflow();
     X_1 := sql.mvc();
     X_2:bat[:oid,:oid]  := sql.tid(X_1,"sys","treeitems");
     X_5:bat[:oid,:lng]  := sql.bind(X_1,"sys","treeitems","pre",0);
-    X_8 := algebra.leftfetchjoin(X_2,X_5);
+    X_8 := mosaic.leftfetchjoin(X_2,X_5);
     X_9 := batcalc.hge(X_8);
     X_10:bat[:oid,:lng]  := sql.bind(X_1,"sys","treeitems","size",0);
-    X_12 := algebra.leftfetchjoin(X_2,X_10);
+    X_12 := mosaic.leftfetchjoin(X_2,X_10);
     X_13 := batcalc.hge(X_12);
     X_14:bat[:oid,:hge]  := batcalc.+(X_9,X_13);
     (X_15,r1_22) := algebra.join(X_9,X_9,X_14,true,true);
     X_18:bat[:oid,:int]  := sql.bind(X_1,"sys","treeitems","subject",0);
-    X_20 := algebra.leftfetchjoin(X_2,X_18);
+    X_20 := mosaic.leftfetchjoin(X_2,X_18);
     X_21 := algebra.leftfetchjoin(r1_22,X_20);
     X_22 := algebra.leftfetchjoin(X_15,X_20);
     language.pass(X_9);
     language.pass(X_9);
     language.pass(X_2);
     language.pass(X_20);
-exit X_50;
+exit X_51;
     X_23 := sql.resultSet(2,1,X_21);
     sql.rsColumn(X_23,"sys.L","id1","int",32,0,X_21);
     sql.rsColumn(X_23,"sys.L","id2","int",32,0,X_22);
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
@@ -44,57 +44,57 @@ Ready.
 % clob # type
 % 187 # length
 function user.s5_1{autoCommit=true}(A0:timestamp,A1:timestamp,A2:void):void;
-barrier X_109 := language.dataflow();
+barrier X_110 := language.dataflow();
     X_6:bat[:oid,:lng]  := bat.new(nil:oid,nil:lng);
     X_5 := sql.mvc();
-    X_66:bat[:oid,:oid]  := sql.tid(X_5,"sys","foo_nil_2dec",0,2);
-    X_69:bat[:oid,:timestamp]  := sql.bind(X_5,"sys","foo_nil_2dec","t",0,0,2);
-    (X_71:bat[:oid,:oid] ,X_72:bat[:oid,:timestamp] ) := 
sql.bind(X_5,"sys","foo_nil_2dec","t",2,0,2);
-    X_81 := sql.delta(X_69,X_71,X_72);
-    X_83 := algebra.leftfetchjoin(X_66,X_81);
+    X_67:bat[:oid,:oid]  := sql.tid(X_5,"sys","foo_nil_2dec",0,2);
+    X_70:bat[:oid,:timestamp]  := sql.bind(X_5,"sys","foo_nil_2dec","t",0,0,2);
+    (X_72:bat[:oid,:oid] ,X_73:bat[:oid,:timestamp] ) := 
sql.bind(X_5,"sys","foo_nil_2dec","t",2,0,2);
+    X_82 := sql.delta(X_70,X_72,X_73);
+    X_84 := algebra.leftfetchjoin(X_67,X_82);
     X_16 := calc.timestamp(A0,7);
-    X_85 := algebra.project(X_83,X_16);
-    X_87 := batmtime.diff(X_83,X_85);
-    X_68:bat[:oid,:oid]  := sql.tid(X_5,"sys","foo_nil_2dec",1,2);
-    X_70:bat[:oid,:timestamp]  := sql.bind(X_5,"sys","foo_nil_2dec","t",0,1,2);
-    (X_73:bat[:oid,:oid] ,X_74:bat[:oid,:timestamp] ) := 
sql.bind(X_5,"sys","foo_nil_2dec","t",2,1,2);
-    X_14:bat[:oid,:timestamp]  := sql.bind(X_5,"sys","foo_nil_2dec","t",1);
-    X_82 := sql.delta(X_70,X_73,X_74,X_14);
-    X_84 := algebra.leftfetchjoin(X_68,X_82);
     X_86 := algebra.project(X_84,X_16);
     X_88 := batmtime.diff(X_84,X_86);
-    X_99 := mat.packIncrement(X_87,2);
-    X_18:bat[:oid,:lng]  := mat.packIncrement(X_99,X_88);
+    X_69:bat[:oid,:oid]  := sql.tid(X_5,"sys","foo_nil_2dec",1,2);
+    X_71:bat[:oid,:timestamp]  := sql.bind(X_5,"sys","foo_nil_2dec","t",0,1,2);
+    (X_74:bat[:oid,:oid] ,X_75:bat[:oid,:timestamp] ) := 
sql.bind(X_5,"sys","foo_nil_2dec","t",2,1,2);
+    X_14:bat[:oid,:timestamp]  := sql.bind(X_5,"sys","foo_nil_2dec","t",1);
+    X_83 := sql.delta(X_71,X_74,X_75,X_14);
+    X_85 := algebra.leftfetchjoin(X_69,X_83);
+    X_87 := algebra.project(X_85,X_16);
+    X_89 := batmtime.diff(X_85,X_87);
+    X_100 := mat.packIncrement(X_88,2);
+    X_18:bat[:oid,:lng]  := mat.packIncrement(X_100,X_89);
     X_19 := bat.append(X_6,X_18,true);
     X_20 := calc.timestamp(A1,7);
-    X_91 := algebra.project(X_83,X_20);
-    X_93 := batmtime.diff(X_83,X_91);
     X_92 := algebra.project(X_84,X_20);
     X_94 := batmtime.diff(X_84,X_92);
-    X_101 := mat.packIncrement(X_93,2);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to