Changeset: 8d8338043638 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8d8338043638
Modified Files:
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/02-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
sql/benchmarks/tpch/Tests/04-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/13-explain.stable.out
sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
sql/benchmarks/tpch/Tests/15-explain.stable.out.int128
sql/benchmarks/tpch/Tests/16-explain.stable.out
sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
sql/benchmarks/tpch/Tests/21-explain.stable.out
sql/benchmarks/tpch/Tests/22-explain.stable.out.int128
Branch: default
Log Message:
merged
diffs (truncated from 1588 to 300 lines):
diff --git a/sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
b/sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
--- a/sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
+++ b/sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
@@ -53,42 +53,42 @@ Ready.
% 602 # length
function user.s2_1{autoCommit=true}(A0:bte,A1:bte,A2:bte,A3:date,A4:lng):void;
X_7 := sql.mvc();
- X_11 := sql.bind(X_7,"sys","lineitem","l_shipdate",0);
+ X_11:bat[:oid,:date] := sql.bind(X_7,"sys","lineitem","l_shipdate",0);
X_8:bat[:oid,:oid] := sql.tid(X_7,"sys","lineitem");
X_19 := mtime.date_sub_msec_interval(A3,A4);
X_189 := algebra.thetasubselect(X_11,X_8,X_19,"<=");
(X_14,r1_14) := sql.bind(X_7,"sys","lineitem","l_shipdate",2);
X_190 := algebra.thetasubselect(r1_14,nil:bat[:oid,:oid],X_19,"<=");
- X_17 := sql.bind(X_7,"sys","lineitem","l_shipdate",1);
+ X_17:bat[:oid,:date] := sql.bind(X_7,"sys","lineitem","l_shipdate",1);
X_192 := algebra.thetasubselect(X_17,X_8,X_19,"<=");
X_20 := sql.subdelta(X_189,X_8,X_14,X_190,X_192);
- X_22 := sql.bind(X_7,"sys","lineitem","l_linestatus",0);
+ X_22:bat[:oid,:str] := sql.bind(X_7,"sys","lineitem","l_linestatus",0);
(X_24,r1_28) := sql.bind(X_7,"sys","lineitem","l_linestatus",2);
- X_26 := sql.bind(X_7,"sys","lineitem","l_linestatus",1);
+ X_26:bat[:oid,:str] := sql.bind(X_7,"sys","lineitem","l_linestatus",1);
X_27 := sql.projectdelta(X_20,X_22,X_24,r1_28,X_26);
- X_28 := sql.bind(X_7,"sys","lineitem","l_returnflag",0);
+ X_28:bat[:oid,:str] := sql.bind(X_7,"sys","lineitem","l_returnflag",0);
(X_30,r1_36) := sql.bind(X_7,"sys","lineitem","l_returnflag",2);
- X_32 := sql.bind(X_7,"sys","lineitem","l_returnflag",1);
+ X_32:bat[:oid,:str] := sql.bind(X_7,"sys","lineitem","l_returnflag",1);
X_33 := sql.projectdelta(X_20,X_28,X_30,r1_36,X_32);
(X_34,r1_42,r2_42) := group.subgroup(X_33);
(X_37,r1_45,r2_45) := group.subgroupdone(X_27,X_34);
X_40 := algebra.leftfetchjoin(r1_45,X_27);
X_41 := algebra.leftfetchjoin(r1_45,X_33);
- X_51 := sql.bind(X_7,"sys","lineitem","l_quantity",0);
+ X_51:bat[:oid,:int] := sql.bind(X_7,"sys","lineitem","l_quantity",0);
(X_56,r1_64) := sql.bind(X_7,"sys","lineitem","l_quantity",2);
- X_59 := sql.bind(X_7,"sys","lineitem","l_quantity",1);
+ X_59:bat[:oid,:int] := sql.bind(X_7,"sys","lineitem","l_quantity",1);
X_61 := sql.projectdelta(X_20,X_51,X_56,r1_64,X_59);
X_62:bat[:oid,:hge] := aggr.subsum(X_61,X_37,r1_45,true,true);
- X_65 := sql.bind(X_7,"sys","lineitem","l_extendedprice",0);
+ X_65:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_extendedprice",0);
(X_67,r1_77) := sql.bind(X_7,"sys","lineitem","l_extendedprice",2);
- X_69 := sql.bind(X_7,"sys","lineitem","l_extendedprice",1);
+ X_69:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_extendedprice",1);
X_70 := sql.projectdelta(X_20,X_65,X_67,r1_77,X_69);
X_71:bat[:oid,:hge] := aggr.subsum(X_70,X_37,r1_45,true,true);
X_73:bat[:oid,:hge] := batcalc.hge(2,X_70,33,2);
X_75 := calc.lng(A0,15,2);
- X_77 := sql.bind(X_7,"sys","lineitem","l_discount",0);
+ X_77:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_discount",0);
(X_82,r1_97) := sql.bind(X_7,"sys","lineitem","l_discount",2);
- X_85 := sql.bind(X_7,"sys","lineitem","l_discount",1);
+ X_85:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_discount",1);
X_87 := sql.projectdelta(X_20,X_77,X_82,r1_97,X_85);
X_88:bat[:oid,:lng] := batcalc.-(X_75,X_87);
X_89:bat[:oid,:hge] := batcalc.*(X_73,X_88);
@@ -97,9 +97,9 @@ function user.s2_1{autoCommit=true}(A0:b
X_94:bat[:oid,:lng] := batcalc.-(X_93,X_87);
X_95:bat[:oid,:hge] := batcalc.*(X_73,X_94);
X_96 := calc.lng(A2,15,2);
- X_97 := sql.bind(X_7,"sys","lineitem","l_tax",0);
+ X_97:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_tax",0);
(X_99,r1_121) := sql.bind(X_7,"sys","lineitem","l_tax",2);
- X_101 := sql.bind(X_7,"sys","lineitem","l_tax",1);
+ X_101:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_tax",1);
X_102 := sql.projectdelta(X_20,X_97,X_99,r1_121,X_101);
X_103:bat[:oid,:lng] := batcalc.+(X_96,X_102);
X_104:bat[:oid,:hge] := batcalc.*(X_95,X_103);
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
@@ -77,7 +77,7 @@ function user.s2_1{autoCommit=true}(A0:i
X_356 := algebra.subselect(X_21,X_19,A3,A3,true,true,false);
(X_23,r1_24) := sql.bind(X_6,"sys","region","r_name",2);
X_357 := algebra.subselect(r1_24,nil:bat[:oid,:oid],A3,A3,true,true,false);
- X_25 := sql.bind(X_6,"sys","region","r_name",1);
+ X_25:bat[:oid,:str] := sql.bind(X_6,"sys","region","r_name",1);
X_359 := algebra.subselect(X_25,X_19,A3,A3,true,true,false);
X_26 := sql.subdelta(X_356,X_19,X_23,X_357,X_359);
X_28 := X_26;
@@ -96,28 +96,28 @@ function user.s2_1{autoCommit=true}(A0:i
X_55 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_suppkey_fkey",1);
X_57 := sql.projectdelta(X_47,X_49,X_52,r1_57,X_55);
(X_58,r1_64) := algebra.subjoin(X_46,X_57,nil:BAT,nil:BAT,true,nil:lng);
- X_60 := sql.bind(X_6,"sys","partsupp","ps_partkey",0);
+ X_60:bat[:oid,:int] := sql.bind(X_6,"sys","partsupp","ps_partkey",0);
(X_62,r1_68) := sql.bind(X_6,"sys","partsupp","ps_partkey",2);
- X_64 := sql.bind(X_6,"sys","partsupp","ps_partkey",1);
+ X_64:bat[:oid,:int] := sql.bind(X_6,"sys","partsupp","ps_partkey",1);
X_65 := sql.projectdelta(X_47,X_60,X_62,r1_68,X_64);
X_66 := algebra.leftfetchjoin(r1_64,X_65);
X_68 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_partkey_fkey",0);
(X_70,r1_78) :=
sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_partkey_fkey",2);
X_72 := sql.bind_idxbat(X_6,"sys","partsupp","partsupp_ps_partkey_fkey",1);
X_73 := sql.projectdelta(X_47,X_68,X_70,r1_78,X_72);
- X_76 := sql.bind(X_6,"sys","part","p_type",0);
- X_82 := sql.bind(X_6,"sys","part","p_size",0);
+ X_76:bat[:oid,:str] := sql.bind(X_6,"sys","part","p_type",0);
+ X_82:bat[:oid,:int] := sql.bind(X_6,"sys","part","p_size",0);
X_74:bat[:oid,:oid] := sql.tid(X_6,"sys","part");
X_360 := algebra.subselect(X_82,X_74,A0,A0,true,true,false);
(X_85,r1_98) := sql.bind(X_6,"sys","part","p_size",2);
X_361 := algebra.subselect(r1_98,nil:bat[:oid,:oid],A0,A0,true,true,false);
- X_88 := sql.bind(X_6,"sys","part","p_size",1);
+ X_88:bat[:oid,:int] := sql.bind(X_6,"sys","part","p_size",1);
X_363 := algebra.subselect(X_88,X_74,A0,A0,true,true,false);
X_90 := sql.subdelta(X_360,X_74,X_85,X_361,X_363);
X_364 := algebra.likesubselect(X_76,X_90,A1,"",false);
(X_78,r1_87) := sql.bind(X_6,"sys","part","p_type",2);
X_365 := algebra.likesubselect(r1_87,nil:bat[:oid,:oid],A1,"",false);
- X_80 := sql.bind(X_6,"sys","part","p_type",1);
+ X_80:bat[:oid,:str] := sql.bind(X_6,"sys","part","p_type",1);
X_367 := algebra.likesubselect(X_80,X_90,A1,"",false);
X_93 := sql.subdelta(X_364,X_90,X_78,X_365,X_367);
X_94 := X_93;
@@ -137,20 +137,20 @@ function user.s2_1{autoCommit=true}(A0:i
X_125 := sql.bind_idxbat(X_6,"sys","nation","nation_n_regionkey_fkey",1);
X_126 := sql.projectdelta(X_115,X_120,X_122,r1_147,X_125);
X_127 := algebra.leftfetchjoin(r1_142,X_126);
- X_130 := sql.bind(X_6,"sys","region","r_name",0);
+ X_130:bat[:oid,:str] := sql.bind(X_6,"sys","region","r_name",0);
X_128:bat[:oid,:oid] := sql.tid(X_6,"sys","region");
X_368 := algebra.subselect(X_130,X_128,A2,A2,true,true,false);
(X_132,r1_158) := sql.bind(X_6,"sys","region","r_name",2);
X_369 :=
algebra.subselect(r1_158,nil:bat[:oid,:oid],A2,A2,true,true,false);
- X_134 := sql.bind(X_6,"sys","region","r_name",1);
+ X_134:bat[:oid,:str] := sql.bind(X_6,"sys","region","r_name",1);
X_371 := algebra.subselect(X_134,X_128,A2,A2,true,true,false);
X_135 := sql.subdelta(X_368,X_128,X_132,X_369,X_371);
X_137 := X_135;
(X_138,r1_167) :=
algebra.subjoin(X_127,X_137,nil:BAT,nil:BAT,true,nil:lng);
X_372 := algebra.leftfetchjoin(X_138,X_117);
- X_142 := sql.bind(X_6,"sys","part","p_partkey",0);
+ X_142:bat[:oid,:int] := sql.bind(X_6,"sys","part","p_partkey",0);
(X_146,r1_175) := sql.bind(X_6,"sys","part","p_partkey",2);
- X_149 := sql.bind(X_6,"sys","part","p_partkey",1);
+ X_149:bat[:oid,:int] := sql.bind(X_6,"sys","part","p_partkey",1);
X_151 := sql.projectdelta(X_93,X_142,X_146,r1_175,X_149);
X_152:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_372,X_103,r1_111,X_151);
(X_153,r1_187) := algebra.subjoin(X_66,X_152,nil:BAT,nil:BAT,true,nil:lng);
@@ -158,9 +158,9 @@ function user.s2_1{autoCommit=true}(A0:i
X_157 := algebra.leftfetchjoin(r1_187,X_156);
(X_158,r1_194,r2_194) := group.subgroupdone(X_157);
X_373 := algebra.leftfetchjoin(r1_194,r1_187);
- X_161 := sql.bind(X_6,"sys","partsupp","ps_supplycost",0);
+ X_161:bat[:oid,:lng] := sql.bind(X_6,"sys","partsupp","ps_supplycost",0);
(X_165,r1_201) := sql.bind(X_6,"sys","partsupp","ps_supplycost",2);
- X_167 := sql.bind(X_6,"sys","partsupp","ps_supplycost",1);
+ X_167:bat[:oid,:lng] := sql.bind(X_6,"sys","partsupp","ps_supplycost",1);
X_168 := sql.projectdelta(X_47,X_161,X_165,r1_201,X_167);
X_173:bat[:oid,:lng] := algebra.leftfetchjoinPath(X_153,r1_64,X_168);
X_174:bat[:oid,:lng] := aggr.submin(X_173,X_158,r1_194,true);
@@ -169,28 +169,28 @@ function user.s2_1{autoCommit=true}(A0:i
X_177 := algebra.subselect(X_176,true,true,true,true,false);
X_374 := algebra.leftfetchjoin(X_177,r1_194);
X_179:bat[:oid,:int] := algebra.leftfetchjoinPath(X_374,r1_187,X_152);
- X_180 := sql.bind(X_6,"sys","supplier","s_name",0);
+ X_180:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_name",0);
(X_184,r1_237) := sql.bind(X_6,"sys","supplier","s_name",2);
- X_186 := sql.bind(X_6,"sys","supplier","s_name",1);
+ X_186:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_name",1);
X_187 := sql.projectdelta(X_101,X_180,X_184,r1_237,X_186);
X_188:bat[:oid,:str] :=
algebra.leftfetchjoinPath(X_374,r1_187,X_138,X_117,r1_127,X_187);
- X_189 := sql.bind(X_6,"sys","nation","n_name",0);
+ X_189:bat[:oid,:str] := sql.bind(X_6,"sys","nation","n_name",0);
(X_193,r1_252) := sql.bind(X_6,"sys","nation","n_name",2);
- X_196 := sql.bind(X_6,"sys","nation","n_name",1);
+ X_196:bat[:oid,:str] := sql.bind(X_6,"sys","nation","n_name",1);
X_198 := sql.projectdelta(X_115,X_189,X_193,r1_252,X_196);
X_199:bat[:oid,:str] :=
algebra.leftfetchjoinPath(X_374,r1_187,X_138,r1_142,X_198);
- X_200 := sql.bind(X_6,"sys","supplier","s_acctbal",0);
+ X_200:bat[:oid,:lng] := sql.bind(X_6,"sys","supplier","s_acctbal",0);
(X_202,r1_266) := sql.bind(X_6,"sys","supplier","s_acctbal",2);
- X_206 := sql.bind(X_6,"sys","supplier","s_acctbal",1);
+ X_206:bat[:oid,:lng] := sql.bind(X_6,"sys","supplier","s_acctbal",1);
X_207 := sql.projectdelta(X_101,X_200,X_202,r1_266,X_206);
X_208:bat[:oid,:lng] :=
algebra.leftfetchjoinPath(X_374,r1_187,X_138,X_117,r1_127,X_207);
(X_209,r1_284) := algebra.firstn(X_208,100:wrd,false,false);
(X_212,r1_289) := algebra.firstn(X_199,X_209,r1_284,100:wrd,true,false);
(X_215,r1_294) := algebra.firstn(X_188,X_212,r1_289,100:wrd,true,false);
X_217 := algebra.firstn(X_179,X_215,r1_294,100:wrd,true,false);
- X_242 := sql.bind(X_6,"sys","part","p_mfgr",0);
+ X_242:bat[:oid,:str] := sql.bind(X_6,"sys","part","p_mfgr",0);
(X_247,r1_336) := sql.bind(X_6,"sys","part","p_mfgr",2);
- X_250 := sql.bind(X_6,"sys","part","p_mfgr",1);
+ X_250:bat[:oid,:str] := sql.bind(X_6,"sys","part","p_mfgr",1);
X_251 := sql.projectdelta(X_93,X_242,X_247,r1_336,X_250);
X_218 := algebra.leftfetchjoin(X_217,X_179);
X_219 := algebra.leftfetchjoin(X_217,X_188);
@@ -204,19 +204,19 @@ function user.s2_1{autoCommit=true}(A0:i
X_237 := algebra.subslice(X_234,0:wrd,99:wrd);
X_375 := algebra.leftfetchjoin(X_237,r1_312);
X_252:bat[:oid,:str] :=
algebra.leftfetchjoinPath(X_375,X_217,X_177,r1_194,r1_187,X_138,X_117,X_103,r1_111,X_251);
- X_253 := sql.bind(X_6,"sys","supplier","s_address",0);
+ X_253:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_address",0);
(X_256,r1_356) := sql.bind(X_6,"sys","supplier","s_address",2);
- X_258 := sql.bind(X_6,"sys","supplier","s_address",1);
+ X_258:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_address",1);
X_260 := sql.projectdelta(X_101,X_253,X_256,r1_356,X_258);
X_261:bat[:oid,:str] :=
algebra.leftfetchjoinPath(X_375,X_217,X_177,r1_194,r1_187,X_138,X_117,r1_127,X_260);
- X_262 := sql.bind(X_6,"sys","supplier","s_phone",0);
+ X_262:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_phone",0);
(X_266,r1_375) := sql.bind(X_6,"sys","supplier","s_phone",2);
- X_269 := sql.bind(X_6,"sys","supplier","s_phone",1);
+ X_269:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_phone",1);
X_270 := sql.projectdelta(X_101,X_262,X_266,r1_375,X_269);
X_271:bat[:oid,:str] :=
algebra.leftfetchjoinPath(X_375,X_217,X_177,r1_194,r1_187,X_138,X_117,r1_127,X_270);
- X_272 := sql.bind(X_6,"sys","supplier","s_comment",0);
+ X_272:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_comment",0);
(X_275,r1_393) := sql.bind(X_6,"sys","supplier","s_comment",2);
- X_277 := sql.bind(X_6,"sys","supplier","s_comment",1);
+ X_277:bat[:oid,:str] := sql.bind(X_6,"sys","supplier","s_comment",1);
X_279 := sql.projectdelta(X_101,X_272,X_275,r1_393,X_277);
X_280:bat[:oid,:str] :=
algebra.leftfetchjoinPath(X_375,X_217,X_177,r1_194,r1_187,X_138,X_117,r1_127,X_279);
X_238 := algebra.leftfetchjoin(X_237,X_234);
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
@@ -55,36 +55,36 @@ Ready.
% 496 # length
function user.s2_1{autoCommit=true}(A0:bte,A1:str,A2:date,A3:date):void;
X_6 := sql.mvc();
- X_10 := sql.bind(X_6,"sys","orders","o_orderdate",0);
+ X_10:bat[:oid,:date] := sql.bind(X_6,"sys","orders","o_orderdate",0);
X_7:bat[:oid,:oid] := sql.tid(X_6,"sys","orders");
X_194 := algebra.thetasubselect(X_10,X_7,A2,"<");
(X_13,r1_13) := sql.bind(X_6,"sys","orders","o_orderdate",2);
X_195 := algebra.thetasubselect(r1_13,nil:bat[:oid,:oid],A2,"<");
- X_16 := sql.bind(X_6,"sys","orders","o_orderdate",1);
+ X_16:bat[:oid,:date] := sql.bind(X_6,"sys","orders","o_orderdate",1);
X_197 := algebra.thetasubselect(X_16,X_7,A2,"<");
X_18 := sql.subdelta(X_194,X_7,X_13,X_195,X_197);
X_20 := sql.bind_idxbat(X_6,"sys","orders","orders_o_custkey_fkey",0);
(X_22,r1_25) :=
sql.bind_idxbat(X_6,"sys","orders","orders_o_custkey_fkey",2);
X_24 := sql.bind_idxbat(X_6,"sys","orders","orders_o_custkey_fkey",1);
X_25 := sql.projectdelta(X_18,X_20,X_22,r1_25,X_24);
- X_28 := sql.bind(X_6,"sys","customer","c_mktsegment",0);
+ X_28:bat[:oid,:str] := sql.bind(X_6,"sys","customer","c_mktsegment",0);
X_26:bat[:oid,:oid] := sql.tid(X_6,"sys","customer");
X_198 := algebra.subselect(X_28,X_26,A1,A1,true,true,false);
(X_30,r1_35) := sql.bind(X_6,"sys","customer","c_mktsegment",2);
X_199 := algebra.subselect(r1_35,nil:bat[:oid,:oid],A1,A1,true,true,false);
- X_32 := sql.bind(X_6,"sys","customer","c_mktsegment",1);
+ X_32:bat[:oid,:str] := sql.bind(X_6,"sys","customer","c_mktsegment",1);
X_201 := algebra.subselect(X_32,X_26,A1,A1,true,true,false);
X_33 := sql.subdelta(X_198,X_26,X_30,X_199,X_201);
X_36 := X_33;
(X_37,r1_45) := algebra.subjoin(X_25,X_36,nil:BAT,nil:BAT,true,nil:lng);
X_41 := X_18;
X_42 := algebra.leftfetchjoin(X_37,X_41);
- X_46 := sql.bind(X_6,"sys","lineitem","l_shipdate",0);
+ X_46:bat[:oid,:date] := sql.bind(X_6,"sys","lineitem","l_shipdate",0);
X_43:bat[:oid,:oid] := sql.tid(X_6,"sys","lineitem");
X_202 := algebra.thetasubselect(X_46,X_43,A3,">");
(X_49,r1_57) := sql.bind(X_6,"sys","lineitem","l_shipdate",2);
X_203 := algebra.thetasubselect(r1_57,nil:bat[:oid,:oid],A3,">");
- X_52 := sql.bind(X_6,"sys","lineitem","l_shipdate",1);
+ X_52:bat[:oid,:date] := sql.bind(X_6,"sys","lineitem","l_shipdate",1);
X_205 := algebra.thetasubselect(X_52,X_43,A3,">");
X_54 := sql.subdelta(X_202,X_43,X_49,X_203,X_205);
X_56 := sql.bind_idxbat(X_6,"sys","lineitem","lineitem_l_orderkey_fkey",0);
@@ -95,30 +95,30 @@ function user.s2_1{autoCommit=true}(A0:b
X_206 := algebra.leftfetchjoin(X_62,X_37);
X_65 := sql.projectdelta(X_18,X_10,X_13,r1_13,X_16);
X_66:bat[:oid,:date] := algebra.leftfetchjoin(X_206,X_65);
- X_67 := sql.bind(X_6,"sys","orders","o_shippriority",0);
+ X_67:bat[:oid,:int] := sql.bind(X_6,"sys","orders","o_shippriority",0);
(X_70,r1_84) := sql.bind(X_6,"sys","orders","o_shippriority",2);
- X_73 := sql.bind(X_6,"sys","orders","o_shippriority",1);
+ X_73:bat[:oid,:int] := sql.bind(X_6,"sys","orders","o_shippriority",1);
X_74 := sql.projectdelta(X_18,X_67,X_70,r1_84,X_73);
X_75:bat[:oid,:int] := algebra.leftfetchjoin(X_206,X_74);
- X_76 := sql.bind(X_6,"sys","lineitem","l_orderkey",0);
+ X_76:bat[:oid,:int] := sql.bind(X_6,"sys","lineitem","l_orderkey",0);
(X_80,r1_97) := sql.bind(X_6,"sys","lineitem","l_orderkey",2);
- X_83 := sql.bind(X_6,"sys","lineitem","l_orderkey",1);
+ X_83:bat[:oid,:int] := sql.bind(X_6,"sys","lineitem","l_orderkey",1);
X_85 := sql.projectdelta(X_54,X_76,X_80,r1_97,X_83);
X_86 := algebra.leftfetchjoin(r1_75,X_85);
(X_87,r1_106,r2_106) := group.subgroup(X_86);
(X_90,r1_109,r2_109) := group.subgroup(X_75,X_87);
(X_93,r1_112,r2_112) := group.subgroupdone(X_66,X_90);
X_96 := algebra.leftfetchjoin(r1_112,X_66);
- X_97 := sql.bind(X_6,"sys","lineitem","l_extendedprice",0);
+ X_97:bat[:oid,:lng] := sql.bind(X_6,"sys","lineitem","l_extendedprice",0);
(X_99,r1_118) := sql.bind(X_6,"sys","lineitem","l_extendedprice",2);
- X_102 := sql.bind(X_6,"sys","lineitem","l_extendedprice",1);
+ X_102:bat[:oid,:lng] :=
sql.bind(X_6,"sys","lineitem","l_extendedprice",1);
X_103 := sql.projectdelta(X_54,X_97,X_99,r1_118,X_102);
X_104 := algebra.leftfetchjoin(r1_75,X_103);
X_105:bat[:oid,:hge] := batcalc.hge(2,X_104,33,2);
X_107 := calc.lng(A0,15,2);
- X_110 := sql.bind(X_6,"sys","lineitem","l_discount",0);
+ X_110:bat[:oid,:lng] := sql.bind(X_6,"sys","lineitem","l_discount",0);
(X_114,r1_138) := sql.bind(X_6,"sys","lineitem","l_discount",2);
- X_116 := sql.bind(X_6,"sys","lineitem","l_discount",1);
+ X_116:bat[:oid,:lng] := sql.bind(X_6,"sys","lineitem","l_discount",1);
X_118 := sql.projectdelta(X_54,X_110,X_114,r1_138,X_116);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
