Changeset: f5ac657b4c16 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f5ac657b4c16
Modified Files:
sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/13-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/21-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
Branch: Oct2014
Log Message:
Approved 32-bit output.
diffs (truncated from 702 to 300 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
@@ -53,41 +53,41 @@ 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_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,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_186 := algebra.thetasubselect(X_17,X_8,X_19,"<=");
X_20 := sql.subdelta(X_184,X_8,X_14,X_185,X_186);
- 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,:lng] := 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,:lng] := aggr.subsum(X_70,X_37,r1_45,true,true);
X_73 := calc.lng(A0,15,2);
- X_75 := 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 := 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);
@@ -96,9 +96,9 @@ function user.s2_1{autoCommit=true}(A0:b
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 := 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 := 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);
diff --git a/sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
b/sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
@@ -54,43 +54,43 @@ Ready.
function user.s2_1{autoCommit=true}(A0:date,A1:date,A2:int):void;
X_5 := sql.mvc();
X_6:bat[:oid,:oid] := sql.tid(X_5,"sys","orders");
- X_9 := sql.bind(X_5,"sys","orders","o_orderdate",0);
+ X_9:bat[:oid,:date] := sql.bind(X_5,"sys","orders","o_orderdate",0);
(X_12,r1_12) := sql.bind(X_5,"sys","orders","o_orderdate",2);
- X_15 := sql.bind(X_5,"sys","orders","o_orderdate",1);
+ X_15:bat[:oid,:date] := sql.bind(X_5,"sys","orders","o_orderdate",1);
X_17 := sql.delta(X_9,X_12,r1_12,X_15);
X_18 := algebra.leftfetchjoin(X_6,X_17);
X_19 := mtime.addmonths(A1,A2);
X_20 := algebra.subselect(X_18,A0,X_19,true,false,false);
X_119 := algebra.leftfetchjoin(X_20,X_6);
- X_22 := sql.bind(X_5,"sys","orders","o_orderkey",0);
+ X_22:bat[:oid,:int] := sql.bind(X_5,"sys","orders","o_orderkey",0);
(X_24,r1_27) := sql.bind(X_5,"sys","orders","o_orderkey",2);
- X_26 := sql.bind(X_5,"sys","orders","o_orderkey",1);
+ X_26:bat[:oid,:int] := sql.bind(X_5,"sys","orders","o_orderkey",1);
X_27 := sql.delta(X_22,X_24,r1_27,X_26);
X_28:bat[:oid,:int] := algebra.leftfetchjoin(X_119,X_27);
X_29 := bat.mirror(X_28);
X_30:bat[:oid,:oid] := sql.tid(X_5,"sys","lineitem");
- X_32 := sql.bind(X_5,"sys","lineitem","l_commitdate",0);
+ X_32:bat[:oid,:date] := sql.bind(X_5,"sys","lineitem","l_commitdate",0);
(X_34,r1_38) := sql.bind(X_5,"sys","lineitem","l_commitdate",2);
- X_37 := sql.bind(X_5,"sys","lineitem","l_commitdate",1);
+ X_37:bat[:oid,:date] := sql.bind(X_5,"sys","lineitem","l_commitdate",1);
X_38 := sql.delta(X_32,X_34,r1_38,X_37);
X_39 := algebra.leftfetchjoin(X_30,X_38);
- X_40 := sql.bind(X_5,"sys","lineitem","l_receiptdate",0);
+ X_40:bat[:oid,:date] := sql.bind(X_5,"sys","lineitem","l_receiptdate",0);
(X_43,r1_47) := sql.bind(X_5,"sys","lineitem","l_receiptdate",2);
- X_46 := sql.bind(X_5,"sys","lineitem","l_receiptdate",1);
+ X_46:bat[:oid,:date] := sql.bind(X_5,"sys","lineitem","l_receiptdate",1);
X_48 := sql.delta(X_40,X_43,r1_47,X_46);
X_49 := algebra.leftfetchjoin(X_30,X_48);
X_50:bat[:oid,:bit] := batcalc.<(X_39,X_49);
X_51 := algebra.subselect(X_50,true,true,true,true,false);
- X_54 := sql.bind(X_5,"sys","lineitem","l_orderkey",0);
+ X_54:bat[:oid,:int] := sql.bind(X_5,"sys","lineitem","l_orderkey",0);
(X_56,r1_62) := sql.bind(X_5,"sys","lineitem","l_orderkey",2);
- X_58 := sql.bind(X_5,"sys","lineitem","l_orderkey",1);
+ X_58:bat[:oid,:int] := sql.bind(X_5,"sys","lineitem","l_orderkey",1);
X_59 := sql.delta(X_54,X_56,r1_62,X_58);
X_60:bat[:oid,:int] := algebra.leftfetchjoinPath(X_51,X_30,X_59);
(X_61,r1_68) := algebra.join(X_28,X_60);
X_63 := algebra.tinter(X_29,X_61);
- X_64 := sql.bind(X_5,"sys","orders","o_orderpriority",0);
+ X_64:bat[:oid,:str] := sql.bind(X_5,"sys","orders","o_orderpriority",0);
(X_67,r1_74) := sql.bind(X_5,"sys","orders","o_orderpriority",2);
- X_70 := sql.bind(X_5,"sys","orders","o_orderpriority",1);
+ X_70:bat[:oid,:str] := sql.bind(X_5,"sys","orders","o_orderpriority",1);
X_71 := sql.delta(X_64,X_67,r1_74,X_70);
X_72:bat[:oid,:str] := algebra.leftfetchjoinPath(X_63,X_119,X_71);
(X_73,r1_82,r2_82) := group.subgroupdone(X_72);
diff --git a/sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
b/sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
@@ -62,21 +62,21 @@ function user.s2_1{autoCommit=true}(A0:s
X_21 := algebra.leftfetchjoin(X_10,X_20);
(X_22,r1_22) := algebra.join(X_7,X_21);
X_119 := algebra.leftfetchjoin(r1_22,X_10);
- X_24 := sql.bind(X_3,"sys","orders","o_comment",0);
+ X_24:bat[:oid,:str] := sql.bind(X_3,"sys","orders","o_comment",0);
(X_26,r1_26) := sql.bind(X_3,"sys","orders","o_comment",2);
- X_28 := sql.bind(X_3,"sys","orders","o_comment",1);
+ X_28:bat[:oid,:str] := sql.bind(X_3,"sys","orders","o_comment",1);
X_29 := sql.delta(X_24,X_26,r1_26,X_28);
X_30:bat[:oid,:str] := algebra.leftfetchjoin(X_119,X_29);
X_32 := algebra.likesubselect(X_30,A0,"",true);
- X_34 := sql.bind(X_3,"sys","orders","o_orderkey",0);
+ X_34:bat[:oid,:int] := sql.bind(X_3,"sys","orders","o_orderkey",0);
(X_36,r1_40) := sql.bind(X_3,"sys","orders","o_orderkey",2);
- X_39 := sql.bind(X_3,"sys","orders","o_orderkey",1);
+ X_39:bat[:oid,:int] := sql.bind(X_3,"sys","orders","o_orderkey",1);
X_41 := sql.delta(X_34,X_36,r1_40,X_39);
X_42:bat[:oid,:int] := algebra.leftfetchjoinPath(X_32,X_119,X_41);
X_43 := bat.append(X_4,X_42,true);
- X_44 := sql.bind(X_3,"sys","customer","c_custkey",0);
+ X_44:bat[:oid,:int] := sql.bind(X_3,"sys","customer","c_custkey",0);
(X_48,r1_53) := sql.bind(X_3,"sys","customer","c_custkey",2);
- X_51 := sql.bind(X_3,"sys","customer","c_custkey",1);
+ X_51:bat[:oid,:int] := sql.bind(X_3,"sys","customer","c_custkey",1);
X_53 := sql.delta(X_44,X_48,r1_53,X_51);
X_54 := algebra.leftfetchjoin(X_7,X_53);
X_55 := bat.mirror(X_54);
diff --git a/sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
b/sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
@@ -63,22 +63,22 @@ Ready.
function
user.s2_1{autoCommit=true}(A0:str,A1:str,A2:int,A3:int,A4:int,A5:int,A6:int,A7:int,A8:int,A9:int,A10:str):void;
X_13 := sql.mvc();
X_14:bat[:oid,:oid] := sql.tid(X_13,"sys","partsupp");
- X_17 := sql.bind(X_13,"sys","partsupp","ps_suppkey",0);
+ X_17:bat[:oid,:int] := sql.bind(X_13,"sys","partsupp","ps_suppkey",0);
(X_20,r1_20) := sql.bind(X_13,"sys","partsupp","ps_suppkey",2);
- X_23 := sql.bind(X_13,"sys","partsupp","ps_suppkey",1);
+ X_23:bat[:oid,:int] := sql.bind(X_13,"sys","partsupp","ps_suppkey",1);
X_25 := sql.delta(X_17,X_20,r1_20,X_23);
X_26 := algebra.leftfetchjoin(X_14,X_25);
X_27 := bat.mirror(X_26);
X_28:bat[:oid,:oid] := sql.tid(X_13,"sys","supplier");
- X_30 := sql.bind(X_13,"sys","supplier","s_comment",0);
+ X_30:bat[:oid,:str] := sql.bind(X_13,"sys","supplier","s_comment",0);
(X_32,r1_32) := sql.bind(X_13,"sys","supplier","s_comment",2);
- X_34 := sql.bind(X_13,"sys","supplier","s_comment",1);
+ X_34:bat[:oid,:str] := sql.bind(X_13,"sys","supplier","s_comment",1);
X_35 := sql.delta(X_30,X_32,r1_32,X_34);
X_36 := algebra.leftfetchjoin(X_28,X_35);
X_38 := algebra.likesubselect(X_36,A10,"",false);
- X_40 := sql.bind(X_13,"sys","supplier","s_suppkey",0);
+ X_40:bat[:oid,:int] := sql.bind(X_13,"sys","supplier","s_suppkey",0);
(X_42,r1_44) := sql.bind(X_13,"sys","supplier","s_suppkey",2);
- X_44 := sql.bind(X_13,"sys","supplier","s_suppkey",1);
+ X_44:bat[:oid,:int] := sql.bind(X_13,"sys","supplier","s_suppkey",1);
X_45 := sql.delta(X_40,X_42,r1_44,X_44);
X_46:bat[:oid,:int] := algebra.leftfetchjoinPath(X_38,X_28,X_45);
(X_47,r1_50) := algebra.join(X_26,X_46);
@@ -89,19 +89,19 @@ function user.s2_1{autoCommit=true}(A0:s
X_60 := sql.delta(X_50,X_55,r1_58,X_58);
X_61:bat[:oid,:oid] := algebra.leftfetchjoinPath(X_49,X_14,X_60);
X_62:bat[:oid,:oid] := sql.tid(X_13,"sys","part");
- X_64 := sql.bind(X_13,"sys","part","p_size",0);
+ X_64:bat[:oid,:int] := sql.bind(X_13,"sys","part","p_size",0);
(X_66,r1_70) := sql.bind(X_13,"sys","part","p_size",2);
- X_68 := sql.bind(X_13,"sys","part","p_size",1);
+ X_68:bat[:oid,:int] := sql.bind(X_13,"sys","part","p_size",1);
X_69 := sql.delta(X_64,X_66,r1_70,X_68);
X_70 := algebra.leftfetchjoin(X_62,X_69);
- X_71 := sql.bind(X_13,"sys","part","p_type",0);
+ X_71:bat[:oid,:str] := sql.bind(X_13,"sys","part","p_type",0);
(X_73,r1_78) := sql.bind(X_13,"sys","part","p_type",2);
- X_75 := sql.bind(X_13,"sys","part","p_type",1);
+ X_75:bat[:oid,:str] := sql.bind(X_13,"sys","part","p_type",1);
X_76 := sql.delta(X_71,X_73,r1_78,X_75);
X_77 := algebra.leftfetchjoin(X_62,X_76);
- X_79 := sql.bind(X_13,"sys","part","p_brand",0);
+ X_79:bat[:oid,:str] := sql.bind(X_13,"sys","part","p_brand",0);
(X_82,r1_89) := sql.bind(X_13,"sys","part","p_brand",2);
- X_84 := sql.bind(X_13,"sys","part","p_brand",1);
+ X_84:bat[:oid,:str] := sql.bind(X_13,"sys","part","p_brand",1);
X_85 := sql.delta(X_79,X_82,r1_89,X_84);
X_86 := algebra.leftfetchjoin(X_62,X_85);
X_87 := algebra.subselect(X_86,A0,A0,true,true,true);
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,139 +67,139 @@ Ready.
function
user.s2_1{autoCommit=true}(A0:str,A1:bte,A2:date,A3:date,A4:int,A5:str):void;
X_8 := sql.mvc();
X_9:bat[:oid,:oid] := sql.tid(X_8,"sys","supplier");
- X_12 := sql.bind(X_8,"sys","supplier","s_suppkey",0);
+ 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 := 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 := sql.bind(X_8,"sys","partsupp","ps_partkey",0);
+ 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 := 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 := sql.bind(X_8,"sys","part","p_name",0);
+ 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 := 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,A0,"",false);
- X_45 := sql.bind(X_8,"sys","part","p_partkey",0);
+ X_45:bat[:oid,:int] := sql.bind(X_8,"sys","part","p_partkey",0);
(X_49,r1_51) := sql.bind(X_8,"sys","part","p_partkey",2);
- X_52 := sql.bind(X_8,"sys","part","p_partkey",1);
+ X_52:bat[:oid,:int] := sql.bind(X_8,"sys","part","p_partkey",1);
X_54 := sql.delta(X_45,X_49,r1_51,X_52);
X_55:bat[:oid,:int] := algebra.leftfetchjoinPath(X_43,X_33,X_54);
(X_56,r1_59) := algebra.join(X_31,X_55);
X_58 := algebra.tinter(X_32,X_56);
- X_278 := algebra.leftfetchjoin(X_58,X_23);
+ X_275 := algebra.leftfetchjoin(X_58,X_23);
X_59 :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",0);
(X_62,r1_65) :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",2);
X_64 :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",1);
X_65 := sql.delta(X_59,X_62,r1_65,X_64);
- X_66:bat[:oid,:wrd] := algebra.leftfetchjoin(X_278,X_65);
+ X_66:bat[:oid,:wrd] := algebra.leftfetchjoin(X_275,X_65);
X_67:bat[:oid,:oid] := sql.tid(X_8,"sys","lineitem");
- X_69 := sql.bind(X_8,"sys","lineitem","l_shipdate",0);
+ X_69:bat[:oid,:date] := sql.bind(X_8,"sys","lineitem","l_shipdate",0);
(X_71,r1_75) := sql.bind(X_8,"sys","lineitem","l_shipdate",2);
- X_73 := sql.bind(X_8,"sys","lineitem","l_shipdate",1);
+ X_73:bat[:oid,:date] := sql.bind(X_8,"sys","lineitem","l_shipdate",1);
X_74 := sql.delta(X_69,X_71,r1_75,X_73);
X_75 := algebra.leftfetchjoin(X_67,X_74);
X_76 := mtime.addmonths(A3,A4);
X_77 := algebra.subselect(X_75,A2,X_76,true,false,false);
- X_279 := algebra.leftfetchjoin(X_77,X_67);
- X_80 := sql.bind(X_8,"sys","lineitem","l_suppkey",0);
- (X_84,r1_91) := sql.bind(X_8,"sys","lineitem","l_suppkey",2);
- X_87 := sql.bind(X_8,"sys","lineitem","l_suppkey",1);
+ X_276 := algebra.leftfetchjoin(X_77,X_67);
+ X_80:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_partkey",0);
+ (X_84,r1_91) := sql.bind(X_8,"sys","lineitem","l_partkey",2);
+ X_87:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_partkey",1);
X_89 := sql.delta(X_80,X_84,r1_91,X_87);
- X_90:bat[:oid,:int] := algebra.leftfetchjoin(X_279,X_89);
- X_91 := sql.bind(X_8,"sys","lineitem","l_partkey",0);
- (X_93,r1_101) := sql.bind(X_8,"sys","lineitem","l_partkey",2);
- X_95 := sql.bind(X_8,"sys","lineitem","l_partkey",1);
- X_96 := sql.delta(X_91,X_93,r1_101,X_95);
- X_97:bat[:oid,:int] := algebra.leftfetchjoin(X_279,X_96);
- (X_98,r1_107,r2_107) := group.subgroup(X_97);
- (X_101,r1_110,r2_110) := group.subgroupdone(X_90,X_98);
- X_104 := algebra.leftfetchjoin(r1_110,X_97);
- X_109 := algebra.leftfetchjoin(r1_110,X_90);
- X_149 := sql.bind(X_8,"sys","lineitem","l_quantity",0);
- (X_154,r1_176) := sql.bind(X_8,"sys","lineitem","l_quantity",2);
- X_157 := sql.bind(X_8,"sys","lineitem","l_quantity",1);
- X_159 := sql.delta(X_149,X_154,r1_176,X_157);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
