Changeset: c9f2735b5377 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c9f2735b5377
Modified Files:
sql/benchmarks/tpch/Tests/02-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
sql/benchmarks/tpch/Tests/10-explain.stable.out
sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
Branch: default
Log Message:
Approve
diffs (251 lines):
diff --git a/sql/benchmarks/tpch/Tests/02-explain.stable.out
b/sql/benchmarks/tpch/Tests/02-explain.stable.out
--- a/sql/benchmarks/tpch/Tests/02-explain.stable.out
+++ b/sql/benchmarks/tpch/Tests/02-explain.stable.out
@@ -66,7 +66,7 @@ Ready.
% clob # type
% 759 # length
function user.s2_1(A0:int,A1:str,A2:str,A3:str):void;
- X_261:void := querylog.define("explain select\n s_acctbal,\n s_name,\n
n_name,\n p_partkey,\n p_mfgr,\n s_address,\n s_phone,\n s_comment\nfrom\n
part,\n supplier,\n partsupp,\n nation,\n region\nwhere\n p_partkey =
ps_partkey\n and s_suppkey = ps_suppkey\n and p_size = 15\n and p_type like
\\'%BRASS\\'\n and s_nationkey = n_nationkey\n and n_regionkey = r_regionkey\n
and r_name = \\'EUROPE\\'\n and ps_supplycost = (\n select\n
min(ps_supplycost)\n from\n partsupp,\n supplier,\n nation,\n region\n where\n
p_partkey = ps_partkey\n and s_suppkey = ps_suppkey\n and s_nationkey =
n_nationkey\n and n_regionkey = r_regionkey\n and r_name = \\'EUROPE\\'\n
)\norder by\n s_acctbal desc,\n n_name,\n s_name,\n p_partkey\nlimit
100;","sequential_pipe",185);
+ X_261:void := querylog.define("explain select\n s_acctbal,\n s_name,\n
n_name,\n p_partkey,\n p_mfgr,\n s_address,\n s_phone,\n s_comment\nfrom\n
part,\n supplier,\n partsupp,\n nation,\n region\nwhere\n p_partkey =
ps_partkey\n and s_suppkey = ps_suppkey\n and p_size = 15\n and p_type like
\\'%BRASS\\'\n and s_nationkey = n_nationkey\n and n_regionkey = r_regionkey\n
and r_name = \\'EUROPE\\'\n and ps_supplycost = (\n select\n
min(ps_supplycost)\n from\n partsupp,\n supplier,\n nation,\n region\n where\n
p_partkey = ps_partkey\n and s_suppkey = ps_suppkey\n and s_nationkey =
n_nationkey\n and n_regionkey = r_regionkey\n and r_name = \\'EUROPE\\'\n
)\norder by\n s_acctbal desc,\n n_name,\n s_name,\n p_partkey\nlimit
100;","sequential_pipe",191);
X_201 := bat.new(nil:oid,nil:str);
X_209 := bat.append(X_201,"sys.supplier");
X_217 := bat.append(X_209,"sys.supplier");
@@ -194,26 +194,25 @@ function user.s2_1(A0:int,A1:str,A2:str,
X_116:bat[:lng] := aggr.submin(X_115,X_105,r1_176,true);
X_117:bat[:bit] := batcalc.==(X_114,X_116);
C_118 := algebra.subselect(X_117,true,true,true,true,false);
- X_119:bat[:int] := algebra.projectionpath(C_118,r1_176,r1_170,X_100);
+ X_288:bat[:oid] := algebra.projectionpath(C_118,r1_176,r1_170);
+ X_119:bat[:int] := algebra.projectionpath(X_288,X_100);
+ X_287:bat[:oid] := algebra.projectionpath(X_288,X_92);
+ X_286:bat[:oid] := algebra.projectionpath(X_287,X_88,r1_119);
X_120:bat[:str] := sql.bind(X_5,"sys","supplier","s_name",0);
(C_122,r1_211) := sql.bind(X_5,"sys","supplier","s_name",2);
X_124:bat[:str] := sql.bind(X_5,"sys","supplier","s_name",1);
X_125 := sql.projectdelta(C_33,X_120,C_122,r1_211,X_124);
- X_126:bat[:str] :=
algebra.projectionpath(C_118,r1_176,r1_170,X_92,X_88,r1_119,X_125);
+ X_126:bat[:str] := algebra.projectionpath(X_286,X_125);
X_127:bat[:str] := sql.bind(X_5,"sys","nation","n_name",0);
(C_129,r1_224) := sql.bind(X_5,"sys","nation","n_name",2);
X_131:bat[:str] := sql.bind(X_5,"sys","nation","n_name",1);
X_132 := sql.projectdelta(C_6,X_127,C_129,r1_224,X_131);
- X_133:bat[:str] :=
algebra.projectionpath(C_118,r1_176,r1_170,X_92,r1_130,X_132);
+ X_133:bat[:str] := algebra.projectionpath(X_287,r1_130,X_132);
X_134:bat[:lng] := sql.bind(X_5,"sys","supplier","s_acctbal",0);
(C_136,r1_236) := sql.bind(X_5,"sys","supplier","s_acctbal",2);
X_138:bat[:lng] := sql.bind(X_5,"sys","supplier","s_acctbal",1);
X_139 := sql.projectdelta(C_33,X_134,C_136,r1_236,X_138);
- X_140:bat[:lng] :=
algebra.projectionpath(C_118,r1_176,r1_170,X_92,X_88,r1_119,X_139);
- X_172:bat[:str] := sql.bind(X_5,"sys","part","p_mfgr",0);
- (C_174,r1_302) := sql.bind(X_5,"sys","part","p_mfgr",2);
- X_176:bat[:str] := sql.bind(X_5,"sys","part","p_mfgr",1);
- X_177 := sql.projectdelta(C_81,X_172,C_174,r1_302,X_176);
+ X_140:bat[:lng] := algebra.projectionpath(X_286,X_139);
(C_143,r1_252) := algebra.firstn(X_140,100,false,false);
(C_145,r1_258) := algebra.firstn(X_133,C_143,r1_252,100,true,false);
(C_147,r1_263) := algebra.firstn(X_126,C_145,r1_258,100,true,false);
@@ -228,26 +227,33 @@ function user.s2_1(A0:int,A1:str,A2:str,
(X_163,r1_281,r2_281) := algebra.subsort(X_150,r1_278,r2_278,false,false);
X_166 := algebra.projection(r1_281,X_153);
X_167 := algebra.subslice(X_166,0,99:wrd);
- X_178:bat[:str] :=
algebra.projectionpath(X_167,r1_281,C_149,C_118,r1_176,r1_170,X_92,X_88,X_85,r1_105,X_177);
+ X_289:bat[:oid] := algebra.projectionpath(X_167,r1_281);
+ X_285:bat[:oid] :=
algebra.projectionpath(X_289,C_149,C_118,r1_176,r1_170,X_92,X_88);
+ X_168 := algebra.projection(X_167,X_166);
+ X_169:bat[:str] := algebra.projectionpath(X_289,X_151);
+ X_170:bat[:str] := algebra.projectionpath(X_289,X_152);
+ X_171:bat[:int] := algebra.projectionpath(X_289,X_150);
+ X_172:bat[:str] := sql.bind(X_5,"sys","part","p_mfgr",0);
+ (C_174,r1_302) := sql.bind(X_5,"sys","part","p_mfgr",2);
+ X_176:bat[:str] := sql.bind(X_5,"sys","part","p_mfgr",1);
+ X_177 := sql.projectdelta(C_81,X_172,C_174,r1_302,X_176);
+ X_178:bat[:str] := algebra.projectionpath(X_285,X_85,r1_105,X_177);
+ X_284:bat[:oid] := algebra.projectionpath(X_285,r1_119);
X_179:bat[:str] := sql.bind(X_5,"sys","supplier","s_address",0);
(C_181,r1_320) := sql.bind(X_5,"sys","supplier","s_address",2);
X_183:bat[:str] := sql.bind(X_5,"sys","supplier","s_address",1);
X_184 := sql.projectdelta(C_33,X_179,C_181,r1_320,X_183);
- X_185:bat[:str] :=
algebra.projectionpath(X_167,r1_281,C_149,C_118,r1_176,r1_170,X_92,X_88,r1_119,X_184);
+ X_185:bat[:str] := algebra.projectionpath(X_284,X_184);
X_186:bat[:str] := sql.bind(X_5,"sys","supplier","s_phone",0);
(C_188,r1_336) := sql.bind(X_5,"sys","supplier","s_phone",2);
X_190:bat[:str] := sql.bind(X_5,"sys","supplier","s_phone",1);
X_191 := sql.projectdelta(C_33,X_186,C_188,r1_336,X_190);
- X_192:bat[:str] :=
algebra.projectionpath(X_167,r1_281,C_149,C_118,r1_176,r1_170,X_92,X_88,r1_119,X_191);
+ X_192:bat[:str] := algebra.projectionpath(X_284,X_191);
X_193:bat[:str] := sql.bind(X_5,"sys","supplier","s_comment",0);
(C_195,r1_352) := sql.bind(X_5,"sys","supplier","s_comment",2);
X_197:bat[:str] := sql.bind(X_5,"sys","supplier","s_comment",1);
X_198 := sql.projectdelta(C_33,X_193,C_195,r1_352,X_197);
- X_199:bat[:str] :=
algebra.projectionpath(X_167,r1_281,C_149,C_118,r1_176,r1_170,X_92,X_88,r1_119,X_198);
- X_168 := algebra.projection(X_167,X_166);
- X_169:bat[:str] := algebra.projectionpath(X_167,r1_281,X_151);
- X_170:bat[:str] := algebra.projectionpath(X_167,r1_281,X_152);
- X_171:bat[:int] := algebra.projectionpath(X_167,r1_281,X_150);
+ X_199:bat[:str] := algebra.projectionpath(X_284,X_198);
sql.resultSet(X_255,X_256,X_257,X_258,X_260,X_168,X_169,X_170,X_171,X_178,X_185,X_192,X_199);
end user.s2_1;
diff --git a/sql/benchmarks/tpch/Tests/03-explain.stable.out
b/sql/benchmarks/tpch/Tests/03-explain.stable.out
--- a/sql/benchmarks/tpch/Tests/03-explain.stable.out
+++ b/sql/benchmarks/tpch/Tests/03-explain.stable.out
@@ -54,7 +54,7 @@ Ready.
% clob # type
% 500 # length
function user.s2_1(A0:bte,A1:str,A2:date,A3:date):void;
- X_160:void := querylog.define("explain select\n l_orderkey,\n
sum(l_extendedprice * (1 - l_discount)) as revenue,\n o_orderdate,\n
o_shippriority\nfrom\n customer,\n orders,\n lineitem\nwhere\n c_mktsegment =
\\'BUILDING\\'\n and c_custkey = o_custkey\n and l_orderkey = o_orderkey\n and
o_orderdate < date \\'1995-03-15\\'\n and l_shipdate > date
\\'1995-03-15\\'\ngroup by\n l_orderkey,\n o_orderdate,\n o_shippriority\norder
by\n revenue desc,\n o_orderdate\nlimit 10;","sequential_pipe",107);
+ X_160:void := querylog.define("explain select\n l_orderkey,\n
sum(l_extendedprice * (1 - l_discount)) as revenue,\n o_orderdate,\n
o_shippriority\nfrom\n customer,\n orders,\n lineitem\nwhere\n c_mktsegment =
\\'BUILDING\\'\n and c_custkey = o_custkey\n and l_orderkey = o_orderkey\n and
o_orderdate < date \\'1995-03-15\\'\n and l_shipdate > date
\\'1995-03-15\\'\ngroup by\n l_orderkey,\n o_orderdate,\n o_shippriority\norder
by\n revenue desc,\n o_orderdate\nlimit 10;","sequential_pipe",109);
X_122 := bat.new(nil:oid,nil:str);
X_130 := bat.append(X_122,"sys.lineitem");
X_138 := bat.append(X_130,"sys.L1");
@@ -116,13 +116,14 @@ function user.s2_1(A0:bte,A1:str,A2:date
X_53:bat[:oid] :=
sql.bind_idxbat(X_5,"sys","lineitem","lineitem_l_orderkey_fkey",1);
X_54 := sql.projectdelta(C_47,X_49,X_51,r1_66,X_53);
(X_55,r1_72) := algebra.subjoin(X_39,X_54,nil:BAT,nil:BAT,false,nil:lng);
+ X_180:bat[:oid] := algebra.projectionpath(X_55,X_35);
X_57 := sql.projectdelta(C_17,X_9,C_12,r1_12,X_15);
- X_58:bat[:date] := algebra.projectionpath(X_55,X_35,X_57);
+ X_58:bat[:date] := algebra.projectionpath(X_180,X_57);
X_59:bat[:int] := sql.bind(X_5,"sys","orders","o_shippriority",0);
(C_61,r1_79) := sql.bind(X_5,"sys","orders","o_shippriority",2);
X_63:bat[:int] := sql.bind(X_5,"sys","orders","o_shippriority",1);
X_64 := sql.projectdelta(C_17,X_59,C_61,r1_79,X_63);
- X_65:bat[:int] := algebra.projectionpath(X_55,X_35,X_64);
+ X_65:bat[:int] := algebra.projectionpath(X_180,X_64);
X_66:bat[:int] := sql.bind(X_5,"sys","lineitem","l_orderkey",0);
(C_68,r1_89) := sql.bind(X_5,"sys","lineitem","l_orderkey",2);
X_70:bat[:int] := sql.bind(X_5,"sys","lineitem","l_orderkey",1);
diff --git a/sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
b/sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
--- a/sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
+++ b/sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
@@ -54,7 +54,7 @@ Ready.
% clob # type
% 500 # length
function user.s2_1(A0:bte,A1:str,A2:date,A3:date):void;
- X_160:void := querylog.define("explain select\n l_orderkey,\n
sum(l_extendedprice * (1 - l_discount)) as revenue,\n o_orderdate,\n
o_shippriority\nfrom\n customer,\n orders,\n lineitem\nwhere\n c_mktsegment =
\\'BUILDING\\'\n and c_custkey = o_custkey\n and l_orderkey = o_orderkey\n and
o_orderdate < date \\'1995-03-15\\'\n and l_shipdate > date
\\'1995-03-15\\'\ngroup by\n l_orderkey,\n o_orderdate,\n o_shippriority\norder
by\n revenue desc,\n o_orderdate\nlimit 10;","sequential_pipe",107);
+ X_160:void := querylog.define("explain select\n l_orderkey,\n
sum(l_extendedprice * (1 - l_discount)) as revenue,\n o_orderdate,\n
o_shippriority\nfrom\n customer,\n orders,\n lineitem\nwhere\n c_mktsegment =
\\'BUILDING\\'\n and c_custkey = o_custkey\n and l_orderkey = o_orderkey\n and
o_orderdate < date \\'1995-03-15\\'\n and l_shipdate > date
\\'1995-03-15\\'\ngroup by\n l_orderkey,\n o_orderdate,\n o_shippriority\norder
by\n revenue desc,\n o_orderdate\nlimit 10;","sequential_pipe",109);
X_122 := bat.new(nil:oid,nil:str);
X_130 := bat.append(X_122,"sys.lineitem");
X_138 := bat.append(X_130,"sys.L1");
@@ -116,13 +116,14 @@ function user.s2_1(A0:bte,A1:str,A2:date
X_53:bat[:oid] :=
sql.bind_idxbat(X_5,"sys","lineitem","lineitem_l_orderkey_fkey",1);
X_54 := sql.projectdelta(C_47,X_49,X_51,r1_66,X_53);
(X_55,r1_72) := algebra.subjoin(X_39,X_54,nil:BAT,nil:BAT,false,nil:lng);
+ X_180:bat[:oid] := algebra.projectionpath(X_55,X_35);
X_57 := sql.projectdelta(C_17,X_9,C_12,r1_12,X_15);
- X_58:bat[:date] := algebra.projectionpath(X_55,X_35,X_57);
+ X_58:bat[:date] := algebra.projectionpath(X_180,X_57);
X_59:bat[:int] := sql.bind(X_5,"sys","orders","o_shippriority",0);
(C_61,r1_79) := sql.bind(X_5,"sys","orders","o_shippriority",2);
X_63:bat[:int] := sql.bind(X_5,"sys","orders","o_shippriority",1);
X_64 := sql.projectdelta(C_17,X_59,C_61,r1_79,X_63);
- X_65:bat[:int] := algebra.projectionpath(X_55,X_35,X_64);
+ X_65:bat[:int] := algebra.projectionpath(X_180,X_64);
X_66:bat[:int] := sql.bind(X_5,"sys","lineitem","l_orderkey",0);
(C_68,r1_89) := sql.bind(X_5,"sys","lineitem","l_orderkey",2);
X_70:bat[:int] := sql.bind(X_5,"sys","lineitem","l_orderkey",1);
@@ -154,10 +155,11 @@ function user.s2_1(A0:bte,A1:str,A2:date
(X_112,r1_156,r2_156) := algebra.subsort(X_107,r1_153,r2_153,false,false);
X_115:bat[:int] := algebra.projectionpath(r1_156,C_106,r1_102,X_72);
X_116 := algebra.subslice(X_115,0,9:wrd);
- X_120:bat[:int] := algebra.projectionpath(X_116,r1_156,C_106,r1_102,X_65);
+ X_181:bat[:oid] := algebra.projectionpath(X_116,r1_156);
+ X_120:bat[:int] := algebra.projectionpath(X_181,C_106,r1_102,X_65);
X_117 := algebra.projection(X_116,X_115);
- X_118:bat[:hge] := algebra.projectionpath(X_116,r1_156,X_108);
- X_119:bat[:date] := algebra.projectionpath(X_116,r1_156,X_107);
+ X_118:bat[:hge] := algebra.projectionpath(X_181,X_108);
+ X_119:bat[:date] := algebra.projectionpath(X_181,X_107);
sql.resultSet(X_155,X_156,X_157,X_158,X_159,X_117,X_118,X_119,X_120);
end user.s2_1;
diff --git a/sql/benchmarks/tpch/Tests/10-explain.stable.out
b/sql/benchmarks/tpch/Tests/10-explain.stable.out
--- a/sql/benchmarks/tpch/Tests/10-explain.stable.out
+++ b/sql/benchmarks/tpch/Tests/10-explain.stable.out
@@ -63,7 +63,7 @@ Ready.
% clob # type
% 619 # length
function user.s2_1(A0:bte,A1:date,A2:date,A3:int,A4:str):void;
- X_215:void := querylog.define("explain select\n c_custkey,\n c_name,\n
sum(l_extendedprice * (1 - l_discount)) as revenue,\n c_acctbal,\n n_name,\n
c_address,\n c_phone,\n c_comment\nfrom\n customer,\n orders,\n lineitem,\n
nation\nwhere\n c_custkey = o_custkey\n and l_orderkey = o_orderkey\n and
o_orderdate >= date \\'1993-10-01\\'\n and o_orderdate < date \\'1993-10-01\\'
+ interval \\'3\\' month\n and l_returnflag = \\'R\\'\n and c_nationkey =
n_nationkey\ngroup by\n c_custkey,\n c_name,\n c_acctbal,\n c_phone,\n
n_name,\n c_address,\n c_comment\norder by\n revenue desc\nlimit
20;","sequential_pipe",148);
+ X_215:void := querylog.define("explain select\n c_custkey,\n c_name,\n
sum(l_extendedprice * (1 - l_discount)) as revenue,\n c_acctbal,\n n_name,\n
c_address,\n c_phone,\n c_comment\nfrom\n customer,\n orders,\n lineitem,\n
nation\nwhere\n c_custkey = o_custkey\n and l_orderkey = o_orderkey\n and
o_orderdate >= date \\'1993-10-01\\'\n and o_orderdate < date \\'1993-10-01\\'
+ interval \\'3\\' month\n and l_returnflag = \\'R\\'\n and c_nationkey =
n_nationkey\ngroup by\n c_custkey,\n c_name,\n c_acctbal,\n c_phone,\n
n_name,\n c_address,\n c_comment\norder by\n revenue desc\nlimit
20;","sequential_pipe",152);
X_153 := bat.new(nil:oid,nil:str);
X_161 := bat.append(X_153,"sys.customer");
X_169 := bat.append(X_161,"sys.customer");
diff --git a/sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
b/sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
--- a/sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
+++ b/sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
@@ -63,7 +63,7 @@ Ready.
% clob # type
% 619 # length
function user.s2_1(A0:bte,A1:date,A2:date,A3:int,A4:str):void;
- X_215:void := querylog.define("explain select\n c_custkey,\n c_name,\n
sum(l_extendedprice * (1 - l_discount)) as revenue,\n c_acctbal,\n n_name,\n
c_address,\n c_phone,\n c_comment\nfrom\n customer,\n orders,\n lineitem,\n
nation\nwhere\n c_custkey = o_custkey\n and l_orderkey = o_orderkey\n and
o_orderdate >= date \\'1993-10-01\\'\n and o_orderdate < date \\'1993-10-01\\'
+ interval \\'3\\' month\n and l_returnflag = \\'R\\'\n and c_nationkey =
n_nationkey\ngroup by\n c_custkey,\n c_name,\n c_acctbal,\n c_phone,\n
n_name,\n c_address,\n c_comment\norder by\n revenue desc\nlimit
20;","sequential_pipe",148);
+ X_215:void := querylog.define("explain select\n c_custkey,\n c_name,\n
sum(l_extendedprice * (1 - l_discount)) as revenue,\n c_acctbal,\n n_name,\n
c_address,\n c_phone,\n c_comment\nfrom\n customer,\n orders,\n lineitem,\n
nation\nwhere\n c_custkey = o_custkey\n and l_orderkey = o_orderkey\n and
o_orderdate >= date \\'1993-10-01\\'\n and o_orderdate < date \\'1993-10-01\\'
+ interval \\'3\\' month\n and l_returnflag = \\'R\\'\n and c_nationkey =
n_nationkey\ngroup by\n c_custkey,\n c_name,\n c_acctbal,\n c_phone,\n
n_name,\n c_address,\n c_comment\norder by\n revenue desc\nlimit
20;","sequential_pipe",152);
X_153 := bat.new(nil:oid,nil:str);
X_161 := bat.append(X_153,"sys.customer");
X_169 := bat.append(X_161,"sys.customer");
@@ -159,17 +159,18 @@ function user.s2_1(A0:bte,A1:date,A2:dat
(X_76,r1_96,r2_96) := group.subgroup(X_75);
(X_79,r1_99,r2_99) := group.subgroupdone(X_68,X_76);
X_82 := algebra.projection(r1_99,X_75);
+ X_233:bat[:oid] := algebra.projectionpath(X_60,X_49,X_36);
X_85:bat[:lng] := sql.bind(X_6,"sys","lineitem","l_extendedprice",0);
(C_87,r1_119) := sql.bind(X_6,"sys","lineitem","l_extendedprice",2);
X_89:bat[:lng] := sql.bind(X_6,"sys","lineitem","l_extendedprice",1);
X_90 := sql.projectdelta(C_18,X_85,C_87,r1_119,X_89);
- X_91:bat[:lng] := algebra.projectionpath(X_60,X_49,X_36,X_90);
+ X_91:bat[:lng] := algebra.projectionpath(X_233,X_90);
X_92 := calc.lng(A0,15,2);
X_94:bat[:lng] := sql.bind(X_6,"sys","lineitem","l_discount",0);
(C_96,r1_138) := sql.bind(X_6,"sys","lineitem","l_discount",2);
X_98:bat[:lng] := sql.bind(X_6,"sys","lineitem","l_discount",1);
X_99 := sql.projectdelta(C_18,X_94,C_96,r1_138,X_98);
- X_100:bat[:lng] := algebra.projectionpath(X_60,X_49,X_36,X_99);
+ X_100:bat[:lng] := algebra.projectionpath(X_233,X_99);
X_101:bat[:lng] := batcalc.-(X_92,X_100);
X_102:bat[:hge] := batcalc.*(X_91,X_101);
X_103:bat[:hge] := aggr.subsum(X_102,X_79,r1_99,true,true);
@@ -180,34 +181,37 @@ function user.s2_1(A0:bte,A1:date,A2:dat
(X_109,r1_164,r2_164) := algebra.subsort(X_108,true,false);
X_112:bat[:int] := algebra.projectionpath(r1_164,C_107,X_83,X_82);
X_113 := algebra.subslice(X_112,0,19:wrd);
- X_130:bat[:str] :=
algebra.projectionpath(X_113,r1_164,C_107,X_83,r1_99,X_68);
+ X_235:bat[:oid] := algebra.projectionpath(X_113,r1_164);
+ X_234:bat[:oid] := algebra.projectionpath(X_235,C_107);
+ X_130:bat[:str] := algebra.projectionpath(X_234,X_83,r1_99,X_68);
X_114 := algebra.projection(X_113,X_112);
+ X_232:bat[:oid] := algebra.projectionpath(X_234,r1_111);
X_115:bat[:str] := sql.bind(X_6,"sys","customer","c_name",0);
(C_117,r1_179) := sql.bind(X_6,"sys","customer","c_name",2);
X_119:bat[:str] := sql.bind(X_6,"sys","customer","c_name",1);
X_120 := sql.projectdelta(C_47,X_115,C_117,r1_179,X_119);
- X_121:bat[:str] := algebra.projectionpath(X_113,r1_164,C_107,r1_111,X_120);
- X_122:bat[:hge] := algebra.projectionpath(X_113,r1_164,X_108);
+ X_121:bat[:str] := algebra.projectionpath(X_232,X_120);
+ X_122:bat[:hge] := algebra.projectionpath(X_235,X_108);
X_123:bat[:lng] := sql.bind(X_6,"sys","customer","c_acctbal",0);
(C_125,r1_192) := sql.bind(X_6,"sys","customer","c_acctbal",2);
X_127:bat[:lng] := sql.bind(X_6,"sys","customer","c_acctbal",1);
X_128 := sql.projectdelta(C_47,X_123,C_125,r1_192,X_127);
- X_129:bat[:lng] := algebra.projectionpath(X_113,r1_164,C_107,r1_111,X_128);
+ X_129:bat[:lng] := algebra.projectionpath(X_232,X_128);
X_131:bat[:str] := sql.bind(X_6,"sys","customer","c_address",0);
(C_133,r1_208) := sql.bind(X_6,"sys","customer","c_address",2);
X_135:bat[:str] := sql.bind(X_6,"sys","customer","c_address",1);
X_136 := sql.projectdelta(C_47,X_131,C_133,r1_208,X_135);
- X_137:bat[:str] := algebra.projectionpath(X_113,r1_164,C_107,r1_111,X_136);
+ X_137:bat[:str] := algebra.projectionpath(X_232,X_136);
X_138:bat[:str] := sql.bind(X_6,"sys","customer","c_phone",0);
(C_140,r1_219) := sql.bind(X_6,"sys","customer","c_phone",2);
X_142:bat[:str] := sql.bind(X_6,"sys","customer","c_phone",1);
X_143 := sql.projectdelta(C_47,X_138,C_140,r1_219,X_142);
- X_144:bat[:str] := algebra.projectionpath(X_113,r1_164,C_107,r1_111,X_143);
+ X_144:bat[:str] := algebra.projectionpath(X_232,X_143);
X_145:bat[:str] := sql.bind(X_6,"sys","customer","c_comment",0);
(C_147,r1_230) := sql.bind(X_6,"sys","customer","c_comment",2);
X_149:bat[:str] := sql.bind(X_6,"sys","customer","c_comment",1);
X_150 := sql.projectdelta(C_47,X_145,C_147,r1_230,X_149);
- X_151:bat[:str] := algebra.projectionpath(X_113,r1_164,C_107,r1_111,X_150);
+ X_151:bat[:str] := algebra.projectionpath(X_232,X_150);
sql.resultSet(X_209,X_210,X_211,X_212,X_214,X_114,X_121,X_122,X_129,X_130,X_137,X_144,X_151);
end user.s2_1;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
