[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-checkins
Subject: MonetDB: default - Approved 32bit/single thread output, added or...
From: Sjoerd Mullender <commits+sjoerd=acm.org () monetdb ! org>
Date: 2016-01-29 13:17:24
Message-ID: hg.6b4033ac14f5.1454073444.6315528441665844383 () monetdb2 ! cwi-incubator ! nl
[Download RAW message or body]
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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic