Changeset: 1de74fea5cd8 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1de74fea5cd8
Modified Files:
sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
Branch: default
Log Message:
Merge with Oct2014 branch.
diffs (273 lines):
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
@@ -52,90 +52,89 @@ Ready.
% clob # type
% 622 # length
function user.s2_1{autoCommit=true}(A0:bte,A1:bte,A2:bte,A3:date,A4:lng):void;
- X_165:void := querylog.define("explain
select\n\tl_returnflag,\n\tl_linestatus,\n\tsum(l_quantity) as
sum_qty,\n\tsum(l_extendedprice) as sum_base_price,\n\tsum(l_extendedprice * (1
- l_discount)) as sum_disc_price,\n\tsum(l_extendedprice * (1 - l_discount) *
(1 + l_tax)) as sum_charge,\n\tavg(l_quantity) as
avg_qty,\n\tavg(l_extendedprice) as avg_price,\n\tavg(l_discount) as
avg_disc,\n\tcount(*) as count_order\nfrom\n\tlineitem\nwhere\n\tl_shipdate <=
date \\'1998-12-01\\' - interval \\'90\\' day (3)\ngroup
by\n\tl_returnflag,\n\tl_linestatus\norder
by\n\tl_returnflag,\n\tl_linestatus;","sequential_pipe",86);
+ X_165:void := querylog.define("explain
select\n\tl_returnflag,\n\tl_linestatus,\n\tsum(l_quantity) as
sum_qty,\n\tsum(l_extendedprice) as sum_base_price,\n\tsum(l_extendedprice * (1
- l_discount)) as sum_disc_price,\n\tsum(l_extendedprice * (1 - l_discount) *
(1 + l_tax)) as sum_charge,\n\tavg(l_quantity) as
avg_qty,\n\tavg(l_extendedprice) as avg_price,\n\tavg(l_discount) as
avg_disc,\n\tcount(*) as count_order\nfrom\n\tlineitem\nwhere\n\tl_shipdate <=
date \\'1998-12-01\\' - interval \\'90\\' day (3)\ngroup
by\n\tl_returnflag,\n\tl_linestatus\norder
by\n\tl_returnflag,\n\tl_linestatus;","sequential_pipe",85);
X_7 := sql.mvc();
- 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_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_184 := algebra.thetasubselect(X_11,X_8,X_19,"<=");
(X_14,r1_14) := sql.bind(X_7,"sys","lineitem","l_shipdate",2);
X_185 := algebra.thetasubselect(r1_14,nil:bat[:oid,:oid],X_19,"<=");
- X_17:bat[:oid,:date] := sql.bind(X_7,"sys","lineitem","l_shipdate",1);
+ X_17:bat[:oid,:date] := sql.bind(X_7,"sys","lineitem","l_shipdate",1);
X_187 := algebra.thetasubselect(X_17,X_8,X_19,"<=");
X_20 := sql.subdelta(X_184,X_8,X_14,X_185,X_187);
- X_22:bat[:oid,:str] := 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:bat[:oid,:str] := 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:bat[:oid,:str] := 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:bat[:oid,:str] := 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:bat[:oid,:int] := 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:bat[:oid,:int] := 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,:lng] := aggr.subsum(X_61,X_37,r1_45,true,true);
- X_65:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_extendedprice",0);
+ X_62:bat[:oid,:lng] := aggr.subsum(X_61,X_37,r1_45,true,true);
+ 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:bat[:oid,:lng] := 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,:lng] := aggr.subsum(X_70,X_37,r1_45,true,true);
+ X_71:bat[:oid,:lng] := aggr.subsum(X_70,X_37,r1_45,true,true);
X_73 := calc.lng(A0,15,2);
- X_75:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_discount",0);
+ X_75:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_discount",0);
(X_77,r1_90) := sql.bind(X_7,"sys","lineitem","l_discount",2);
- X_79:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_discount",1);
+ X_79:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_discount",1);
X_82 := sql.projectdelta(X_20,X_75,X_77,r1_90,X_79);
- X_83:bat[:oid,:lng] := batcalc.-(X_73,X_82);
- X_84:bat[:oid,:lng] := batcalc.*(X_70,X_83);
- X_85:bat[:oid,:lng] := aggr.subsum(X_84,X_37,r1_45,true,true);
+ X_83:bat[:oid,:lng] := batcalc.-(X_73,X_82);
+ X_84:bat[:oid,:lng] := batcalc.*(X_70,X_83);
+ X_85:bat[:oid,:lng] := aggr.subsum(X_84,X_37,r1_45,true,true);
X_87 := calc.lng(A1,15,2);
- X_89:bat[:oid,:lng] := batcalc.-(X_87,X_82);
- X_90:bat[:oid,:lng] := batcalc.*(X_70,X_89);
+ X_89:bat[:oid,:lng] := batcalc.-(X_87,X_82);
+ X_90:bat[:oid,:lng] := batcalc.*(X_70,X_89);
X_91 := calc.lng(A2,15,2);
- X_92:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_tax",0);
+ X_92:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_tax",0);
(X_95,r1_115) := sql.bind(X_7,"sys","lineitem","l_tax",2);
- X_97:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_tax",1);
+ X_97:bat[:oid,:lng] := sql.bind(X_7,"sys","lineitem","l_tax",1);
X_99 := sql.projectdelta(X_20,X_92,X_95,r1_115,X_97);
- X_100:bat[:oid,:lng] := batcalc.+(X_91,X_99);
- X_101:bat[:oid,:lng] := batcalc.*(X_90,X_100);
- X_102:bat[:oid,:lng] := aggr.subsum(X_101,X_37,r1_45,true,true);
- X_105 := batcalc.dbl(X_61);
- X_106:bat[:oid,:dbl] := aggr.subavg(X_105,X_37,r1_45,true,true);
- X_108:bat[:oid,:dbl] := batcalc.dbl(2,X_70);
- X_109:bat[:oid,:dbl] := aggr.subavg(X_108,X_37,r1_45,true,true);
- X_111:bat[:oid,:dbl] := batcalc.dbl(2,X_82);
- X_112:bat[:oid,:dbl] := aggr.subavg(X_111,X_37,r1_45,true,true);
- X_114:bat[:oid,:wrd] := aggr.subcount(X_37,X_37,r1_45,false);
+ X_100:bat[:oid,:lng] := batcalc.+(X_91,X_99);
+ X_101:bat[:oid,:lng] := batcalc.*(X_90,X_100);
+ X_102:bat[:oid,:lng] := aggr.subsum(X_101,X_37,r1_45,true,true);
+ X_105:bat[:oid,:dbl] := aggr.subavg(X_61,X_37,r1_45,true,true);
+ X_107:bat[:oid,:dbl] := batcalc.dbl(2,X_70);
+ X_108:bat[:oid,:dbl] := aggr.subavg(X_107,X_37,r1_45,true,true);
+ X_110:bat[:oid,:dbl] := batcalc.dbl(2,X_82);
+ X_111:bat[:oid,:dbl] := aggr.subavg(X_110,X_37,r1_45,true,true);
+ X_113:bat[:oid,:wrd] := aggr.subcount(X_37,X_37,r1_45,false);
(X_42,r1_50,r2_50) := algebra.subsort(X_41,false,false);
(X_46,r1_54,r2_54) := algebra.subsort(X_40,r1_50,r2_50,false,false);
X_49 := algebra.leftfetchjoin(r1_54,X_41);
- X_116 := algebra.leftfetchjoin(r1_54,X_114);
- X_113 := algebra.leftfetchjoin(r1_54,X_112);
- X_110 := algebra.leftfetchjoin(r1_54,X_109);
- X_107 := algebra.leftfetchjoin(r1_54,X_106);
+ X_115 := algebra.leftfetchjoin(r1_54,X_113);
+ X_112 := algebra.leftfetchjoin(r1_54,X_111);
+ X_109 := algebra.leftfetchjoin(r1_54,X_108);
+ X_106 := algebra.leftfetchjoin(r1_54,X_105);
X_104 := algebra.leftfetchjoin(r1_54,X_102);
X_86 := algebra.leftfetchjoin(r1_54,X_85);
X_72 := algebra.leftfetchjoin(r1_54,X_71);
X_64 := algebra.leftfetchjoin(r1_54,X_62);
X_50 := algebra.leftfetchjoin(r1_54,X_40);
- X_117 := sql.resultSet(10,1,X_49);
- sql.rsColumn(X_117,"sys.lineitem","l_returnflag","varchar",1,0,X_49);
- sql.rsColumn(X_117,"sys.lineitem","l_linestatus","varchar",1,0,X_50);
- sql.rsColumn(X_117,"sys.L1","sum_qty","bigint",32,0,X_64);
- sql.rsColumn(X_117,"sys.L2","sum_base_price","decimal",15,2,X_72);
- sql.rsColumn(X_117,"sys.L3","sum_disc_price","decimal",19,4,X_86);
- sql.rsColumn(X_117,"sys.L4","sum_charge","decimal",19,6,X_104);
- sql.rsColumn(X_117,"sys.L5","avg_qty","double",53,0,X_107);
- sql.rsColumn(X_117,"sys.L6","avg_price","double",53,0,X_110);
- sql.rsColumn(X_117,"sys.L7","avg_disc","double",53,0,X_113);
- sql.rsColumn(X_117,"sys.L10","count_order","wrd",32,0,X_116);
+ X_116 := sql.resultSet(10,1,X_49);
+ sql.rsColumn(X_116,"sys.lineitem","l_returnflag","varchar",1,0,X_49);
+ sql.rsColumn(X_116,"sys.lineitem","l_linestatus","varchar",1,0,X_50);
+ sql.rsColumn(X_116,"sys.L1","sum_qty","bigint",64,0,X_64);
+ sql.rsColumn(X_116,"sys.L2","sum_base_price","decimal",15,2,X_72);
+ sql.rsColumn(X_116,"sys.L3","sum_disc_price","decimal",19,4,X_86);
+ sql.rsColumn(X_116,"sys.L4","sum_charge","decimal",19,6,X_104);
+ sql.rsColumn(X_116,"sys.L5","avg_qty","double",53,0,X_106);
+ sql.rsColumn(X_116,"sys.L6","avg_price","double",53,0,X_109);
+ sql.rsColumn(X_116,"sys.L7","avg_disc","double",53,0,X_112);
+ sql.rsColumn(X_116,"sys.L10","count_order","wrd",32,0,X_115);
X_163 := io.stdout();
- sql.exportResult(X_163,X_117);
+ sql.exportResult(X_163,X_116);
end user.s2_1;
# 22:53:25 >
diff --git a/sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
b/sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
@@ -67,80 +67,80 @@ Ready.
function
user.s2_1{autoCommit=true}(A0:str,A1:bte,A2:date,A3:date,A4:int,A5:str):void;
X_241:void := querylog.define("explain
select\n\ts_name,\n\ts_address\nfrom\n\tsupplier,\n\tnation\nwhere\n\ts_suppkey
in
(\n\t\tselect\n\t\t\tps_suppkey\n\t\tfrom\n\t\t\tpartsupp\n\t\twhere\n\t\t\tps_partkey
in
(\n\t\t\t\tselect\n\t\t\t\t\tp_partkey\n\t\t\t\tfrom\n\t\t\t\t\tpart\n\t\t\t\twhere\n\t\t\t\t\tp_name
like \\'forest%\\'\n\t\t\t)\n\t\t\tand ps_availqty >
(\n\t\t\t\tselect\n\t\t\t\t\t0.5 *
sum(l_quantity)\n\t\t\t\tfrom\n\t\t\t\t\tlineitem\n\t\t\t\twhere\n\t\t\t\t\tl_partkey
= ps_partkey\n\t\t\t\t\tand l_suppkey = ps_suppkey\n\t\t\t\t\tand l_shipdate
>= date \\'1994-01-01\\'\n\t\t\t\t\tand l_shipdate < date \\'1994-01-01\\' +
interval \\'1\\' year\n\t\t\t)\n\t)\n\tand s_nationkey = n_nationkey\n\tand
n_name = \\'CANADA\\'\norder by\n\ts_name;","sequential_pipe",138);
X_8 := sql.mvc();
- X_9:bat[:oid,:oid] := sql.tid(X_8,"sys","supplier");
- X_12:bat[:oid,:int] := sql.bind(X_8,"sys","supplier","s_suppkey",0);
+ X_9:bat[:oid,:oid] := sql.tid(X_8,"sys","supplier");
+ X_12:bat[:oid,:int] := sql.bind(X_8,"sys","supplier","s_suppkey",0);
(X_15,r1_15) := sql.bind(X_8,"sys","supplier","s_suppkey",2);
- X_18:bat[:oid,:int] := sql.bind(X_8,"sys","supplier","s_suppkey",1);
+ X_18:bat[:oid,:int] := sql.bind(X_8,"sys","supplier","s_suppkey",1);
X_20 := sql.delta(X_12,X_15,r1_15,X_18);
X_21 := algebra.leftfetchjoin(X_9,X_20);
X_22 := bat.mirror(X_21);
- X_23:bat[:oid,:oid] := sql.tid(X_8,"sys","partsupp");
- X_25:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_partkey",0);
+ X_23:bat[:oid,:oid] := sql.tid(X_8,"sys","partsupp");
+ X_25:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_partkey",0);
(X_27,r1_27) := sql.bind(X_8,"sys","partsupp","ps_partkey",2);
- X_29:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_partkey",1);
+ X_29:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_partkey",1);
X_30 := sql.delta(X_25,X_27,r1_27,X_29);
X_31 := algebra.leftfetchjoin(X_23,X_30);
X_32 := bat.mirror(X_31);
- X_33:bat[:oid,:oid] := sql.tid(X_8,"sys","part");
- X_35:bat[:oid,:str] := sql.bind(X_8,"sys","part","p_name",0);
+ X_33:bat[:oid,:oid] := sql.tid(X_8,"sys","part");
+ X_35:bat[:oid,:str] := sql.bind(X_8,"sys","part","p_name",0);
(X_37,r1_37) := sql.bind(X_8,"sys","part","p_name",2);
- X_39:bat[:oid,:str] := sql.bind(X_8,"sys","part","p_name",1);
+ X_39:bat[:oid,:str] := sql.bind(X_8,"sys","part","p_name",1);
X_40 := sql.delta(X_35,X_37,r1_37,X_39);
X_41 := algebra.leftfetchjoin(X_33,X_40);
X_43 := algebra.likesubselect(X_41,nil:BAT,A0,"",false);
- X_46:bat[:oid,:int] := sql.bind(X_8,"sys","part","p_partkey",0);
+ X_46:bat[:oid,:int] := sql.bind(X_8,"sys","part","p_partkey",0);
(X_50,r1_52) := sql.bind(X_8,"sys","part","p_partkey",2);
- X_53:bat[:oid,:int] := sql.bind(X_8,"sys","part","p_partkey",1);
+ X_53:bat[:oid,:int] := sql.bind(X_8,"sys","part","p_partkey",1);
X_55 := sql.delta(X_46,X_50,r1_52,X_53);
- X_56:bat[:oid,:int] := algebra.leftfetchjoinPath(X_43,X_33,X_55);
+ X_56:bat[:oid,:int] := algebra.leftfetchjoinPath(X_43,X_33,X_55);
(X_57,r1_60) := algebra.subjoin(X_31,X_56,nil:BAT,nil:BAT,false,nil:lng);
X_60 := algebra.tinter(X_32,X_57);
X_281 := algebra.leftfetchjoin(X_60,X_23);
- X_61:bat[:oid,:wrd] :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",0);
+ X_61:bat[:oid,:wrd] :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",0);
(X_64,r1_67) :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",2);
- X_66:bat[:oid,:wrd] :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",1);
+ X_66:bat[:oid,:wrd] :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",1);
X_67 := sql.delta(X_61,X_64,r1_67,X_66);
X_68:bat[:oid,:wrd] := algebra.leftfetchjoin(X_281,X_67);
- X_69:bat[:oid,:oid] := sql.tid(X_8,"sys","lineitem");
- X_71:bat[:oid,:date] := sql.bind(X_8,"sys","lineitem","l_shipdate",0);
+ X_69:bat[:oid,:oid] := sql.tid(X_8,"sys","lineitem");
+ X_71:bat[:oid,:date] := sql.bind(X_8,"sys","lineitem","l_shipdate",0);
(X_73,r1_77) := sql.bind(X_8,"sys","lineitem","l_shipdate",2);
- X_75:bat[:oid,:date] := sql.bind(X_8,"sys","lineitem","l_shipdate",1);
+ X_75:bat[:oid,:date] := sql.bind(X_8,"sys","lineitem","l_shipdate",1);
X_76 := sql.delta(X_71,X_73,r1_77,X_75);
X_77 := algebra.leftfetchjoin(X_69,X_76);
X_78 := mtime.addmonths(A3,A4);
X_79 := algebra.subselect(X_77,A2,X_78,true,false,false);
- X_283 := algebra.leftfetchjoin(X_79,X_69);
- X_82:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_partkey",0);
+ X_282 := algebra.leftfetchjoin(X_79,X_69);
+ X_82:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_partkey",0);
(X_86,r1_93) := sql.bind(X_8,"sys","lineitem","l_partkey",2);
- X_89:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_partkey",1);
+ X_89:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_partkey",1);
X_91 := sql.delta(X_82,X_86,r1_93,X_89);
- X_92:bat[:oid,:int] := algebra.leftfetchjoin(X_283,X_91);
- X_93:bat[:oid,:wrd] := batmkey.hash(X_92);
- X_95:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_suppkey",0);
+ X_92:bat[:oid,:int] := algebra.leftfetchjoin(X_282,X_91);
+ X_93:bat[:oid,:wrd] := batmkey.hash(X_92);
+ X_95:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_suppkey",0);
(X_98,r1_109) := sql.bind(X_8,"sys","lineitem","l_suppkey",2);
- X_100:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_suppkey",1);
+ X_100:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_suppkey",1);
X_101 := sql.delta(X_95,X_98,r1_109,X_100);
- X_102:bat[:oid,:int] := algebra.leftfetchjoin(X_283,X_101);
- X_103:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_93,11,X_102);
+ X_102:bat[:oid,:int] := algebra.leftfetchjoin(X_282,X_101);
+ X_103:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_93,11,X_102);
(X_104,r1_116) :=
algebra.subjoin(X_68,X_103,nil:BAT,nil:BAT,false,nil:lng);
X_108 := algebra.leftfetchjoin(X_60,X_31);
X_109 := algebra.leftfetchjoin(X_104,X_108);
X_110 := algebra.leftfetchjoin(r1_116,X_92);
- X_111:bat[:oid,:bit] := batcalc.==(X_109,X_110);
+ X_111:bat[:oid,:bit] := batcalc.==(X_109,X_110);
X_113 := algebra.subselect(X_111,true,true,true,true,false);
X_115 := algebra.leftfetchjoin(X_113,X_104);
- X_116:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
+ X_116:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
(X_121,r1_136) := sql.bind(X_8,"sys","partsupp","ps_suppkey",2);
- X_124:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",1);
+ X_124:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",1);
X_126 := sql.delta(X_116,X_121,r1_136,X_124);
X_127:bat[:oid,:int] := algebra.leftfetchjoin(X_281,X_126);
X_128 := algebra.leftfetchjoin(X_115,X_127);
X_129 := algebra.leftfetchjoin(X_113,r1_116);
X_130 := algebra.leftfetchjoin(X_129,X_102);
- X_131:bat[:oid,:bit] := batcalc.==(X_128,X_130);
+ X_131:bat[:oid,:bit] := batcalc.==(X_128,X_130);
X_132 := algebra.subselect(X_131,true,true,true,true,false);
X_133 := algebra.leftfetchjoin(X_132,X_115);
- X_134:bat[:oid,:oid] := batcalc.identity(X_108);
+ X_134:bat[:oid,:oid] := batcalc.identity(X_108);
X_135 := algebra.leftfetchjoin(X_133,X_134);
(X_136,r1_154,r2_154) := group.subgroupdone(X_135);
X_283 := algebra.leftfetchjoin(r1_154,X_133);
@@ -150,12 +150,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_159 := sql.delta(X_151,X_156,r1_181,X_158);
X_160:bat[:oid,:int] := algebra.leftfetchjoinPath(X_132,X_129,X_282,X_159);
X_161:bat[:oid,:lng] := aggr.subsum(X_160,X_136,r1_154,true,true);
- X_139:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_availqty",0);
+ X_139:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_availqty",0);
(X_141,r1_159) := sql.bind(X_8,"sys","partsupp","ps_availqty",2);
- X_143:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_availqty",1);
+ X_143:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_availqty",1);
X_144 := sql.delta(X_139,X_141,r1_159,X_143);
X_145:bat[:oid,:int] := algebra.leftfetchjoinPath(X_283,X_60,X_23,X_144);
- X_146:bat[:oid,:lng] := batcalc.lng(X_145,19,2);
+ X_146:bat[:oid,:lng] := batcalc.lng(X_145,19,2);
X_149 := calc.lng(1,A1,19,1);
X_163:bat[:oid,:lng] := batcalc.lng(X_161,19,1);
X_164:bat[:oid,:lng] := batcalc.*(X_149,X_163);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
