Changeset: 6b4033ac14f5 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6b4033ac14f5
Modified Files:
        
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
        monetdb5/optimizer/Tests/All
        monetdb5/optimizer/Tests/manifold2.stable.out.single
        sql/backends/monet5/generator/Tests/joins00.sql
        sql/backends/monet5/generator/Tests/joins01.sql
        sql/backends/monet5/generator/Tests/joins01.stable.out
        sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
        sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
        
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
        sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.single
        sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
        sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
        sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out
        sql/test/Tests/median_stdev.sql
Branch: default
Log Message:

Approved 32bit/single thread output, added order by, added conditionals.


diffs (truncated from 1453 to 300 lines):

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
@@ -61,16 +61,16 @@ Ready.
 % .explain # table_name
 % mal # name
 % clob # type
-% 133 # length
-function user.s4_1{autoCommit=true}():void;
-    X_26:void := querylog.define("explain copy into ttt from 
\\'/tmp/xyz\\';","default_pipe",10);
-    X_2 := sql.mvc();
-    (X_12:bat[:oid,:int],X_13:bat[:oid,:int],X_14:bat[:oid,:int]) := 
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0);
-    X_15 := sql.append(X_2,"sys","ttt","a",X_12);
-    X_19 := sql.append(X_15,"sys","ttt","b",X_13);
-    X_21 := sql.append(X_19,"sys","ttt","c",X_14);
-    X_23 := aggr.count(X_14);
-    sql.affectedRows(X_21,X_23,"");
+% 118 # length
+function user.s4_1():void;
+    X_24:void := querylog.define("explain copy into ttt from 
\\'/tmp/xyz\\';","default_pipe",10);
+    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);
+    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);
 end user.s4_1;
 #declare opt_pipe_name string;
 #set opt_pipe_name = ( select optimizer );
@@ -93,16 +93,16 @@ end user.s4_1;
 % .explain # table_name
 % mal # name
 % clob # type
-% 133 # length
-function user.s12_1{autoCommit=true}():void;
-    X_26:void := querylog.define("explain copy into ttt from 
\\'/tmp/xyz\\';","user_1",10);
-    X_2 := sql.mvc();
-    (X_12:bat[:oid,:int],X_13:bat[:oid,:int],X_14:bat[:oid,:int]) := 
sql.copy_from(nil,"|","\\n",nil:str,"null","/tmp/xyz",-1,0,0,0);
-    X_15 := sql.append(X_2,"sys","ttt","a",X_12);
-    X_19 := sql.append(X_15,"sys","ttt","b",X_13);
-    X_23 := aggr.count(X_14);
-    X_21 := sql.append(X_19,"sys","ttt","c",X_14);
-    sql.affectedRows(X_21,X_23,"");
+% 118 # length
+function user.s12_1():void;
+    X_24:void := querylog.define("explain copy into ttt from 
\\'/tmp/xyz\\';","user_1",10);
+    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);
+    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);
 end user.s12_1;
 #drop table ttt;
 
diff --git a/monetdb5/optimizer/Tests/All b/monetdb5/optimizer/Tests/All
--- a/monetdb5/optimizer/Tests/All
+++ b/monetdb5/optimizer/Tests/All
@@ -69,7 +69,7 @@ CXexample
 JPexample
 Mexample
 
-dataflow
-dataflow3
-dataflow4
-dataflow5
+THREADS>=2?dataflow
+THREADS>=2?dataflow3
+THREADS>=2?dataflow4
+THREADS>=2?dataflow5
diff --git a/monetdb5/optimizer/Tests/manifold2.stable.out.single 
b/monetdb5/optimizer/Tests/manifold2.stable.out.single
--- a/monetdb5/optimizer/Tests/manifold2.stable.out.single
+++ b/monetdb5/optimizer/Tests/manifold2.stable.out.single
@@ -17,37 +17,32 @@ stdout of test 'manifold2` in directory 
 # Listening for UNIX domain connection requests on 
mapi:monetdb:///var/tmp/mtest-28130/.s.monetdb.33759
 # MonetDB/GIS module loaded
 # MonetDB/SQL module loaded
-function user.tst(b:bat[:oid,:dbl],b2:bat[:oid,:dbl]):void;
-    c := aggr.count(b);
-    c2 := aggr.count(b2);
-    z:bat[:oid,:dbl]  := mal.multiplex("calc","max",b,b2);
-    io.print(z,b,b2);
-end user.tst;
+# MonetDB/R   module loaded
+
+Ready.
 #WARNING To speedup calc.max a bulk operator implementation is needed
-function user.main():void;
-# the manifold code blocks  
-    b := bat.new(:oid,:dbl);
-    b2 := bat.new(:oid,:dbl);
-    mdb.List("user","tst");
-    mdb.var("user","tst");
-    mdb.List("user","tst");
-end user.main;
-function user.tst(b:bat[:oid,:dbl],b2:bat[:oid,:dbl]):void;    # 
-    c:wrd := aggr.count(b:bat[:oid,:dbl]);     # ALGcount_bat
-    c2:wrd := aggr.count(b2:bat[:oid,:dbl]);   # ALGcount_bat
-    X_9:bat[:oid,:dbl] := bat.new(nil:oid,nil:dbl);    # CMDBATnew
-barrier (X_13:oid,X_14:dbl) := iterator.new(b:bat[:oid,:dbl]); # ITRbunIterator
-    X_16:dbl := algebra.fetch(b2:bat[:oid,:dbl],X_13:oid);     # ALGfetchoid
-    X_18:dbl := calc.max(X_14:dbl,X_16:dbl);   # CALCmax
-    bat.append(X_9:bat[:oid,:dbl],X_18:dbl);   # BKCappend_val_wrap
-    redo (X_13:oid,X_14:dbl) := iterator.next(b:bat[:oid,:dbl]);       # 
ITRbunNext
-exit (X_13:oid,X_14:dbl);                      # 
-    z:bat[:oid,:dbl] := X_9:bat[:oid,:dbl];    # 
-    io.print(z:bat[:oid,:dbl],b:bat[:oid,:dbl],b2:bat[:oid,:dbl]);     # 
IOtable
-end user.tst;                                  # 
-#[1]     b =  :bat[:oid,:dbl]  
-#[2]    b2 =  :bat[:oid,:dbl]  
-#[5]     z =  :bat[:oid,:dbl]  
+#    z:bat[:dbl] := 
mal.multiplex("calc":str,"max":str,b:bat[:dbl],b2:bat[:dbl]);
+
+# 12:52:57 >  
+# 12:52:57 >  "mclient" "-lmal" "-ftest" "-Eutf-8" 
"--host=/var/tmp/mtest-23074" "--port=30414"
+# 12:52:57 >  
+
+function user.tst(b:bat[:dbl],b2:bat[:dbl]):void;      #[0]  0 <- 1 2 
+    c:wrd := aggr.count(b:bat[:dbl]);          #[1] ALGcount_bat 3 <- 1 
+    c2:wrd := aggr.count(b2:bat[:dbl]);        #[2] ALGcount_bat 4 <- 2 
+    X_9:bat[:dbl] := bat.new(nil:oid,nil:dbl); #[3] CMDBATnew 9 <- 10 11 
+barrier (X_13:oid,X_14:dbl) := iterator.new(b:bat[:dbl]);      #[4] 
ITRbunIterator 13 14 <- 1 
+    X_16:dbl := algebra.fetch(b2:bat[:dbl],X_13:oid);  #[5] ALGfetchoid 16 <- 
2 13 
+    X_18:dbl := calc.max(X_14:dbl,X_16:dbl);   #[6] CALCmax 18 <- 14 16 
+    bat.append(X_9:bat[:dbl],X_18:dbl);        #[7] BKCappend_val_wrap 19 <- 9 
18 
+    redo (X_13:oid,X_14:dbl) := iterator.next(b:bat[:dbl]);    #[8] ITRbunNext 
13 14 <- 1 
+exit (X_13:oid,X_14:dbl);                      #[9]  13 14 
+    z:bat[:dbl] := X_9:bat[:dbl];              #[10]  5 <- 9 
+    io.print(z:bat[:dbl],b:bat[:dbl],b2:bat[:dbl]);    #[11] IOtable 8 <- 5 1 
2 
+end user.tst;                                  #[12]  
+#[1]     b =  :bat[:dbl]  
+#[2]    b2 =  :bat[:dbl]  
+#[5]     z =  :bat[:dbl]  
 #[6]    _6 = "calc" :str  constant 
 #[7]    _7 = "max" :str  constant 
 #[9]    _9 =  :bat[:oid,:dbl]  
@@ -57,19 +52,19 @@ end user.tst;                           
 #[14]   _14 =  :dbl  
 #[16]   _16 =  :dbl  
 #[18]   _18 =  :dbl  
-function user.tst(b:bat[:oid,:dbl],b2:bat[:oid,:dbl]):void;    # 
-    c:wrd := aggr.count(b:bat[:oid,:dbl]);     # ALGcount_bat
-    c2:wrd := aggr.count(b2:bat[:oid,:dbl]);   # ALGcount_bat
-    X_9:bat[:oid,:dbl] := bat.new(nil:oid,nil:dbl);    # CMDBATnew
-barrier (X_13:oid,X_14:dbl) := iterator.new(b:bat[:oid,:dbl]); # ITRbunIterator
-    X_16:dbl := algebra.fetch(b2:bat[:oid,:dbl],X_13:oid);     # ALGfetchoid
-    X_18:dbl := calc.max(X_14:dbl,X_16:dbl);   # CALCmax
-    bat.append(X_9:bat[:oid,:dbl],X_18:dbl);   # BKCappend_val_wrap
-    redo (X_13:oid,X_14:dbl) := iterator.next(b:bat[:oid,:dbl]);       # 
ITRbunNext
-exit (X_13:oid,X_14:dbl);                      # 
-    z:bat[:oid,:dbl] := X_9:bat[:oid,:dbl];    # 
-    io.print(z:bat[:oid,:dbl],b:bat[:oid,:dbl],b2:bat[:oid,:dbl]);     # 
IOtable
-end user.tst;                                  # 
+function user.tst(b:bat[:dbl],b2:bat[:dbl]):void;      #[0]  0 <- 1 2 
+    c:wrd := aggr.count(b:bat[:dbl]);          #[1] ALGcount_bat 3 <- 1 
+    c2:wrd := aggr.count(b2:bat[:dbl]);        #[2] ALGcount_bat 4 <- 2 
+    X_9:bat[:dbl] := bat.new(nil:oid,nil:dbl); #[3] CMDBATnew 9 <- 10 11 
+barrier (X_13:oid,X_14:dbl) := iterator.new(b:bat[:dbl]);      #[4] 
ITRbunIterator 13 14 <- 1 
+    X_16:dbl := algebra.fetch(b2:bat[:dbl],X_13:oid);  #[5] ALGfetchoid 16 <- 
2 13 
+    X_18:dbl := calc.max(X_14:dbl,X_16:dbl);   #[6] CALCmax 18 <- 14 16 
+    bat.append(X_9:bat[:dbl],X_18:dbl);        #[7] BKCappend_val_wrap 19 <- 9 
18 
+    redo (X_13:oid,X_14:dbl) := iterator.next(b:bat[:dbl]);    #[8] ITRbunNext 
13 14 <- 1 
+exit (X_13:oid,X_14:dbl);                      #[9]  13 14 
+    z:bat[:dbl] := X_9:bat[:dbl];              #[10]  5 <- 9 
+    io.print(z:bat[:dbl],b:bat[:dbl],b2:bat[:dbl]);    #[11] IOtable 8 <- 5 1 
2 
+end user.tst;                                  #[12]  
 
 # 09:02:36 >  
 # 09:02:36 >  "Done."
diff --git a/sql/backends/monet5/generator/Tests/joins00.sql 
b/sql/backends/monet5/generator/Tests/joins00.sql
--- a/sql/backends/monet5/generator/Tests/joins00.sql
+++ b/sql/backends/monet5/generator/Tests/joins00.sql
@@ -33,13 +33,13 @@ drop table tmp2;
 -- negative range
 create table tmp(i tinyint);
 insert into tmp values(3),(4),(5);
-select * from tmp;
+select * from tmp order by i;
 
-select * from generate_series(9,0,-2) X, tmp Y where X.value = Y.i;
-select * from generate_series(9,0,-2) X, tmp Y where Y.i = X.value;
+select * from generate_series(9,0,-2) X, tmp Y where X.value = Y.i order by 
X.value, Y.i;
+select * from generate_series(9,0,-2) X, tmp Y where Y.i = X.value order by 
X.value, Y.i;
 
-select * from generate_series(9,0,-2) X, tmp Y where X.value = Y.i and value 
<5;
+select * from generate_series(9,0,-2) X, tmp Y where X.value = Y.i and value 
<5 order by X.value, Y.i;
 
-select * from generate_series(9,0,-2) as  X, tmp Y where X.value = Y.i and 
value <7 and value >3;
+select * from generate_series(9,0,-2) as  X, tmp Y where X.value = Y.i and 
value <7 and value >3 order by X.value, Y.i;
 
 drop table tmp;
diff --git a/sql/backends/monet5/generator/Tests/joins01.sql 
b/sql/backends/monet5/generator/Tests/joins01.sql
--- a/sql/backends/monet5/generator/Tests/joins01.sql
+++ b/sql/backends/monet5/generator/Tests/joins01.sql
@@ -7,36 +7,36 @@ insert into tmp values
 (timestamp '2008-03-01 00:00'),
 (timestamp '2008-03-01 10:00'),
 (timestamp '2008-03-01 20:00');
-select * from tmp;
+select * from tmp order by i;
 
-select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where X.value = Y.i;
-select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where Y.i = X.value;
+select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where X.value = Y.i 
order by X.value, Y.i;
+select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where Y.i = X.value 
order by X.value, Y.i;
 
-select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where X.value = Y.i 
and value < timestamp '2008-03-01 20:00';
-select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where Y.i = X.value  
and value < timestamp '2008-03-01 20:00';
+select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where X.value = Y.i 
and value < timestamp '2008-03-01 20:00' order by X.value, Y.i;
+select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where Y.i = X.value  
and value < timestamp '2008-03-01 20:00' order by X.value, Y.i;
 
-select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) as  X, tmp Y where X.value = 
Y.i and value < timestamp '2008-03-01 20:00' and value > timestamp '200-03-01 
00:00';
+select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) as  X, tmp Y where X.value = 
Y.i and value < timestamp '2008-03-01 20:00' and value > timestamp '200-03-01 
00:00' order by X.value, Y.i;
 
-select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) as  X, tmp Y where X.value = 
Y.i and i < timestamp '2008-03-01 20:00' and i > timestamp '200-03-01 00:00';
+select * from generate_series(timestamp '2008-03-01 00:00',timestamp 
'2008-03-04 12:00',cast( '10' as interval hour)) as  X, tmp Y where X.value = 
Y.i and i < timestamp '2008-03-01 20:00' and i > timestamp '200-03-01 00:00' 
order by X.value, Y.i;
 
 -- negative range
-select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X;
-select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i;
-select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where Y.i = X.value;
+select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X order by X.value;
+select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i 
order by X.value, Y.i;
+select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where Y.i = X.value 
order by X.value, Y.i;
 
 select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
-and value > timestamp '2008-03-01 11:00';
+and value > timestamp '2008-03-01 11:00' order by X.value, Y.i;
 select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
-and i > timestamp '2008-03-01 11:00';
+and i > timestamp '2008-03-01 11:00' order by X.value, Y.i;
 
-select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X where value > timestamp 
'2008-03-01 11:00' and value < timestamp '2008-03-01 21:00';
+select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X where value > timestamp 
'2008-03-01 11:00' and value < timestamp '2008-03-01 21:00' order by X.value;
 
 select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
 and value > timestamp '2008-03-01 11:00'
-and value < timestamp '2008-03-01 21:00';
+and value < timestamp '2008-03-01 21:00' order by X.value, Y.i;
 
 select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i
 and i > timestamp '2008-03-01 11:00'
-and i < timestamp '2008-03-01 21:00';
+and i < timestamp '2008-03-01 21:00' order by X.value, Y.i;
 
 drop table tmp;
diff --git a/sql/backends/monet5/generator/Tests/joins01.stable.out 
b/sql/backends/monet5/generator/Tests/joins01.stable.out
--- a/sql/backends/monet5/generator/Tests/joins01.stable.out
+++ b/sql/backends/monet5/generator/Tests/joins01.stable.out
@@ -87,16 +87,15 @@ Ready.
 % value # name
 % timestamp # type
 % 26 # length
-[ 2008-03-04 18:00:00.000000   ]
+[ 2008-03-01 10:00:00.000000   ]
+[ 2008-03-01 20:00:00.000000   ]
+[ 2008-03-02 06:00:00.000000   ]
+[ 2008-03-02 16:00:00.000000   ]
+[ 2008-03-03 02:00:00.000000   ]
+[ 2008-03-03 12:00:00.000000   ]
+[ 2008-03-03 22:00:00.000000   ]
 [ 2008-03-04 08:00:00.000000   ]
-[ 2008-03-03 22:00:00.000000   ]
-[ 2008-03-03 12:00:00.000000   ]
-[ 2008-03-03 02:00:00.000000   ]
-[ 2008-03-02 16:00:00.000000   ]
-[ 2008-03-02 06:00:00.000000   ]
-[ 2008-03-01 20:00:00.000000   ]
-[ 2008-03-01 10:00:00.000000   ]
-#select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i;
+#select * from generate_series(timestamp '2008-03-04 18:00',timestamp 
'2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i 
order by X.value, Y.i;
 % .x,  sys.y # table_name
 % value,       i # name
 % timestamp,   timestamp # type
diff --git a/sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit 
b/sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
@@ -108,77 +108,77 @@ function user.s2_1(A0:bte,A1:bte,A2:bte,
     X_172 := bat.append(X_165,0);
     X_179 := bat.append(X_172,0);
     X_188 := bat.append(X_179,0);
-    X_7 := sql.mvc();
-    X_11:bat[:oid,:date] := sql.bind(X_7,"sys","lineitem","l_shipdate",0);
-    C_8:bat[:oid,:oid] := sql.tid(X_7,"sys","lineitem");
-    X_19:date := mtime.date_sub_msec_interval(A3,A4);
-    C_197 := algebra.thetasubselect(X_11,C_8,X_19,"<=");
-    (C_14,r1_14) := sql.bind(X_7,"sys","lineitem","l_shipdate",2);
-    C_198 := algebra.thetasubselect(r1_14,nil:bat[:oid,:oid],X_19,"<=");
-    X_17:bat[:oid,:date]  := sql.bind(X_7,"sys","lineitem","l_shipdate",1);
-    C_200 := algebra.thetasubselect(X_17,C_8,X_19,"<=");
-    C_20 := sql.subdelta(C_197,C_8,C_14,C_198,C_200);
-    X_22:bat[:oid,:str]  := sql.bind(X_7,"sys","lineitem","l_linestatus",0);
-    (C_24,r1_28) := sql.bind(X_7,"sys","lineitem","l_linestatus",2);
-    X_26:bat[:oid,:str] := sql.bind(X_7,"sys","lineitem","l_linestatus",1);
-    X_27 := sql.projectdelta(C_20,X_22,C_24,r1_28,X_26);
-    X_28:bat[:oid,:str] := sql.bind(X_7,"sys","lineitem","l_returnflag",0);
-    (C_30,r1_36) := sql.bind(X_7,"sys","lineitem","l_returnflag",2);
-    X_32:bat[:oid,:str] := sql.bind(X_7,"sys","lineitem","l_returnflag",1);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to