Changeset: 4180432386c4 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4180432386c4
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: default
Log Message:
propagated recent approvals of "int128" output to "32bit" output
diffs (truncated from 901 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
@@ -52,17 +52,17 @@ Ready.
% clob # type
% 620 # length
function user.s2_1{autoCommit=true}(A0:bte,A1:bte,A2:bte,A3:date,A4:lng):void;
- X_170: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");
+ 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");
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_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_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_186 := algebra.thetasubselect(X_17,X_8,X_19,"<=");
- X_20 := sql.subdelta(X_184,X_8,X_14,X_185,X_186);
+ 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_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);
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
@@ -62,12 +62,12 @@ function user.s2_1{autoCommit=true}(A0:d
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_122 := algebra.leftfetchjoin(X_20,X_6);
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: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_28:bat[:oid,:int] := algebra.leftfetchjoin(X_122,X_27);
X_29 := bat.mirror(X_28);
X_30:bat[:oid,:oid] := sql.tid(X_5,"sys","lineitem");
X_32:bat[:oid,:date] := sql.bind(X_5,"sys","lineitem","l_commitdate",0);
@@ -87,24 +87,24 @@ function user.s2_1{autoCommit=true}(A0:d
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: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: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);
- X_76 := algebra.leftfetchjoin(r1_82,X_72);
- X_81:bat[:oid,:wrd] := aggr.subcount(X_73,X_73,r1_82,false);
- (X_77,r1_86,r2_86) := algebra.subsort(X_76,false,false);
- X_80 := algebra.leftfetchjoin(r1_86,X_76);
- X_82 := algebra.leftfetchjoin(r1_86,X_81);
- X_83 := sql.resultSet(2,1,X_80);
- sql.rsColumn(X_83,"sys.orders","o_orderpriority","varchar",15,0,X_80);
- sql.rsColumn(X_83,"sys.L1","order_count","wrd",32,0,X_82);
- X_96 := io.stdout();
- sql.exportResult(X_96,X_83);
+ (X_61,r1_68) := algebra.subjoin(X_28,X_60,nil:BAT,nil:BAT,false,nil:lng);
+ X_65 := algebra.tinter(X_29,X_61);
+ X_66:bat[:oid,:str] := sql.bind(X_5,"sys","orders","o_orderpriority",0);
+ (X_70,r1_77) := sql.bind(X_5,"sys","orders","o_orderpriority",2);
+ X_72:bat[:oid,:str] := sql.bind(X_5,"sys","orders","o_orderpriority",1);
+ X_73 := sql.delta(X_66,X_70,r1_77,X_72);
+ X_74:bat[:oid,:str] := algebra.leftfetchjoinPath(X_65,X_122,X_73);
+ (X_75,r1_84,r2_84) := group.subgroupdone(X_74);
+ X_78 := algebra.leftfetchjoin(r1_84,X_74);
+ X_83:bat[:oid,:wrd] := aggr.subcount(X_75,X_75,r1_84,false);
+ (X_79,r1_88,r2_88) := algebra.subsort(X_78,false,false);
+ X_82 := algebra.leftfetchjoin(r1_88,X_78);
+ X_85 := algebra.leftfetchjoin(r1_88,X_83);
+ X_86 := sql.resultSet(2,1,X_82);
+ sql.rsColumn(X_86,"sys.orders","o_orderpriority","varchar",15,0,X_82);
+ sql.rsColumn(X_86,"sys.L1","order_count","wrd",32,0,X_85);
+ X_99 := io.stdout();
+ sql.exportResult(X_99,X_86);
end user.s2_1;
# 22:53:26 >
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
@@ -61,49 +61,49 @@ function user.s2_1{autoCommit=true}(A0:s
X_18:bat[:oid,:oid] :=
sql.bind_idxbat(X_3,"sys","orders","orders_o_custkey_fkey",1);
X_20 := sql.delta(X_12,X_15,r1_15,X_18);
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: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: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: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: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: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: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);
- X_56 := algebra.leftfetchjoin(X_32,X_22);
- X_57 := algebra.tdiff(X_55,X_56);
- X_59 := algebra.project(X_57,nil:int);
- X_60 := bat.append(X_43,X_59,true);
- X_61:bat[:oid,:int] := bat.new(nil:oid,nil:int);
- X_63 := algebra.leftfetchjoin(X_56,X_54);
- X_64 := bat.append(X_61,X_63,true);
- X_66 := algebra.leftfetchjoin(X_57,X_54);
+ (X_22,r1_22) := algebra.subjoin(X_7,X_21,nil:BAT,nil:BAT,false,nil:lng);
+ X_122 := algebra.leftfetchjoin(r1_22,X_10);
+ X_27:bat[:oid,:str] := sql.bind(X_3,"sys","orders","o_comment",0);
+ (X_29,r1_29) := sql.bind(X_3,"sys","orders","o_comment",2);
+ X_31:bat[:oid,:str] := sql.bind(X_3,"sys","orders","o_comment",1);
+ X_32 := sql.delta(X_27,X_29,r1_29,X_31);
+ X_33:bat[:oid,:str] := algebra.leftfetchjoin(X_122,X_32);
+ X_35 := algebra.likesubselect(X_33,nil:BAT,A0,"",true);
+ X_37:bat[:oid,:int] := sql.bind(X_3,"sys","orders","o_orderkey",0);
+ (X_40,r1_44) := sql.bind(X_3,"sys","orders","o_orderkey",2);
+ X_43:bat[:oid,:int] := sql.bind(X_3,"sys","orders","o_orderkey",1);
+ X_44 := sql.delta(X_37,X_40,r1_44,X_43);
+ X_45:bat[:oid,:int] := algebra.leftfetchjoinPath(X_35,X_122,X_44);
+ X_46 := bat.append(X_4,X_45,true);
+ X_47:bat[:oid,:int] := sql.bind(X_3,"sys","customer","c_custkey",0);
+ (X_51,r1_56) := sql.bind(X_3,"sys","customer","c_custkey",2);
+ X_54:bat[:oid,:int] := sql.bind(X_3,"sys","customer","c_custkey",1);
+ X_56 := sql.delta(X_47,X_51,r1_56,X_54);
+ X_57 := algebra.leftfetchjoin(X_7,X_56);
+ X_58 := bat.mirror(X_57);
+ X_59 := algebra.leftfetchjoin(X_35,X_22);
+ X_60 := algebra.tdiff(X_58,X_59);
+ X_62 := algebra.project(X_60,nil:int);
+ X_63 := bat.append(X_46,X_62,true);
+ X_64:bat[:oid,:int] := bat.new(nil:oid,nil:int);
+ X_66 := algebra.leftfetchjoin(X_59,X_57);
X_67 := bat.append(X_64,X_66,true);
- (X_68,r1_74,r2_74) := group.subgroupdone(X_67);
- X_71:bat[:oid,:wrd] := aggr.subcount(X_60,X_68,r1_74,true);
- (X_72,r1_78,r2_78) := group.subgroupdone(X_71);
- X_75 := algebra.leftfetchjoin(r1_78,X_71);
- X_76:bat[:oid,:wrd] := aggr.subcount(X_72,X_72,r1_78,false);
- (X_78,r1_84,r2_84) := algebra.subsort(X_76,true,false);
- (X_81,r1_87,r2_87) := algebra.subsort(X_75,r1_84,r2_84,true,false);
- X_84 := algebra.leftfetchjoin(r1_87,X_75);
- X_85 := algebra.leftfetchjoin(r1_87,X_76);
- X_86 := sql.resultSet(2,1,X_84);
- sql.rsColumn(X_86,".c_orders","c_count","wrd",32,0,X_84);
- sql.rsColumn(X_86,".L2","custdist","wrd",32,0,X_85);
- X_98 := io.stdout();
- sql.exportResult(X_98,X_86);
+ X_69 := algebra.leftfetchjoin(X_60,X_57);
+ X_70 := bat.append(X_67,X_69,true);
+ (X_71,r1_77,r2_77) := group.subgroupdone(X_70);
+ X_74:bat[:oid,:wrd] := aggr.subcount(X_63,X_71,r1_77,true);
+ (X_75,r1_81,r2_81) := group.subgroupdone(X_74);
+ X_78 := algebra.leftfetchjoin(r1_81,X_74);
+ X_79:bat[:oid,:wrd] := aggr.subcount(X_75,X_75,r1_81,false);
+ (X_81,r1_87,r2_87) := algebra.subsort(X_79,true,false);
+ (X_84,r1_90,r2_90) := algebra.subsort(X_78,r1_87,r2_87,true,false);
+ X_87 := algebra.leftfetchjoin(r1_90,X_78);
+ X_88 := algebra.leftfetchjoin(r1_90,X_79);
+ X_89 := sql.resultSet(2,1,X_87);
+ sql.rsColumn(X_89,".c_orders","c_count","wrd",32,0,X_87);
+ sql.rsColumn(X_89,".L2","custdist","wrd",32,0,X_88);
+ X_101 := io.stdout();
+ sql.exportResult(X_101,X_89);
end user.s2_1;
# 22:53:28 >
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
@@ -61,7 +61,7 @@ Ready.
% clob # type
% 595 # length
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_187:void := querylog.define("explain
select\n\tp_brand,\n\tp_type,\n\tp_size,\n\tcount(distinct ps_suppkey) as
supplier_cnt\nfrom\n\tpartsupp,\n\tpart\nwhere\n\tp_partkey = ps_partkey\n\tand
p_brand <> \\'Brand#45\\'\n\tand p_type not like \\'MEDIUM POLISHED%\\'\n\tand
p_size in (49, 14, 23, 45, 19, 3, 36, 9)\n\tand ps_suppkey not in
(\n\t\tselect\n\t\t\ts_suppkey\n\t\tfrom\n\t\t\tsupplier\n\t\twhere\n\t\t\ts_comment
like \\'%Customer%Complaints%\\'\n\t)\ngroup
by\n\tp_brand,\n\tp_type,\n\tp_size\norder by\n\tsupplier_cnt
desc,\n\tp_brand,\n\tp_type,\n\tp_size;","sequential_pipe");
+ X_186:void := querylog.define("explain
select\n\tp_brand,\n\tp_type,\n\tp_size,\n\tcount(distinct ps_suppkey) as
supplier_cnt\nfrom\n\tpartsupp,\n\tpart\nwhere\n\tp_partkey = ps_partkey\n\tand
p_brand <> \\'Brand#45\\'\n\tand p_type not like \\'MEDIUM POLISHED%\\'\n\tand
p_size in (49, 14, 23, 45, 19, 3, 36, 9)\n\tand ps_suppkey not in
(\n\t\tselect\n\t\t\ts_suppkey\n\t\tfrom\n\t\t\tsupplier\n\t\twhere\n\t\t\ts_comment
like \\'%Customer%Complaints%\\'\n\t)\ngroup
by\n\tp_brand,\n\tp_type,\n\tp_size\norder by\n\tsupplier_cnt
desc,\n\tp_brand,\n\tp_type,\n\tp_size;","sequential_pipe");
X_13 := sql.mvc();
X_14:bat[:oid,:oid] := sql.tid(X_13,"sys","partsupp");
X_17:bat[:oid,:int] := sql.bind(X_13,"sys","partsupp","ps_suppkey",0);
@@ -76,89 +76,89 @@ function user.s2_1{autoCommit=true}(A0:s
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: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: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);
- X_49 := algebra.tdiff(X_27,X_47);
- X_50:bat[:oid,:oid] :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",0);
- (X_55,r1_58) :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",2);
- X_58:bat[:oid,:oid] :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",1);
- 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: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: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: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: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: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: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);
- X_89 := algebra.likesubselect(X_77,X_87,A1,"",true);
- X_90 := algebra.subselect(X_70,X_89,A2,A2,true,true,false);
- X_92 := algebra.subselect(X_70,X_89,A3,A3,true,true,false);
- X_93 := bat.mergecand(X_90,X_92);
- X_94 := algebra.subselect(X_70,X_89,A4,A4,true,true,false);
- X_95 := bat.mergecand(X_93,X_94);
- X_96 := algebra.subselect(X_70,X_89,A5,A5,true,true,false);
+ X_38 := algebra.likesubselect(X_36,nil:BAT,A10,"",false);
+ X_41:bat[:oid,:int] := sql.bind(X_13,"sys","supplier","s_suppkey",0);
+ (X_43,r1_45) := sql.bind(X_13,"sys","supplier","s_suppkey",2);
+ X_45:bat[:oid,:int] := sql.bind(X_13,"sys","supplier","s_suppkey",1);
+ X_47 := sql.delta(X_41,X_43,r1_45,X_45);
+ X_48:bat[:oid,:int] := algebra.leftfetchjoinPath(X_38,X_28,X_47);
+ (X_49,r1_52) := algebra.subjoin(X_26,X_48,nil:BAT,nil:BAT,false,nil:lng);
+ X_52 := algebra.tdiff(X_27,X_49);
+ X_53:bat[:oid,:oid] :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",0);
+ (X_57,r1_60) :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",2);
+ X_60:bat[:oid,:oid] :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",1);
+ X_62 := sql.delta(X_53,X_57,r1_60,X_60);
+ X_63:bat[:oid,:oid] := algebra.leftfetchjoinPath(X_52,X_14,X_62);
+ X_64:bat[:oid,:oid] := sql.tid(X_13,"sys","part");
+ X_66:bat[:oid,:int] := sql.bind(X_13,"sys","part","p_size",0);
+ (X_68,r1_72) := sql.bind(X_13,"sys","part","p_size",2);
+ X_70:bat[:oid,:int] := sql.bind(X_13,"sys","part","p_size",1);
+ X_71 := sql.delta(X_66,X_68,r1_72,X_70);
+ X_72 := algebra.leftfetchjoin(X_64,X_71);
+ X_73:bat[:oid,:str] := sql.bind(X_13,"sys","part","p_type",0);
+ (X_75,r1_80) := sql.bind(X_13,"sys","part","p_type",2);
+ X_78:bat[:oid,:str] := sql.bind(X_13,"sys","part","p_type",1);
+ X_79 := sql.delta(X_73,X_75,r1_80,X_78);
+ X_80 := algebra.leftfetchjoin(X_64,X_79);
+ X_82:bat[:oid,:str] := sql.bind(X_13,"sys","part","p_brand",0);
+ (X_84,r1_91) := sql.bind(X_13,"sys","part","p_brand",2);
+ X_86:bat[:oid,:str] := sql.bind(X_13,"sys","part","p_brand",1);
+ X_87 := sql.delta(X_82,X_84,r1_91,X_86);
+ X_88 := algebra.leftfetchjoin(X_64,X_87);
+ X_89 := algebra.subselect(X_88,A0,A0,true,true,true);
+ X_91 := algebra.likesubselect(X_80,X_89,A1,"",true);
+ X_92 := algebra.subselect(X_72,X_91,A2,A2,true,true,false);
+ X_94 := algebra.subselect(X_72,X_91,A3,A3,true,true,false);
+ X_95 := bat.mergecand(X_92,X_94);
+ X_96 := algebra.subselect(X_72,X_91,A4,A4,true,true,false);
X_97 := bat.mergecand(X_95,X_96);
- X_98 := algebra.subselect(X_70,X_89,A6,A6,true,true,false);
+ X_98 := algebra.subselect(X_72,X_91,A5,A5,true,true,false);
X_99 := bat.mergecand(X_97,X_98);
- X_100 := algebra.subselect(X_70,X_89,A7,A7,true,true,false);
+ X_100 := algebra.subselect(X_72,X_91,A6,A6,true,true,false);
X_101 := bat.mergecand(X_99,X_100);
- X_102 := algebra.subselect(X_70,X_89,A8,A8,true,true,false);
+ X_102 := algebra.subselect(X_72,X_91,A7,A7,true,true,false);
X_103 := bat.mergecand(X_101,X_102);
- X_104 := algebra.subselect(X_70,X_89,A9,A9,true,true,false);
+ X_104 := algebra.subselect(X_72,X_91,A8,A8,true,true,false);
X_105 := bat.mergecand(X_103,X_104);
- X_106 := algebra.leftfetchjoin(X_105,X_62);
- (X_107,r1_122) := algebra.join(X_61,X_106);
- X_207 := algebra.leftfetchjoin(r1_122,X_105);
- X_109:bat[:oid,:str] := algebra.leftfetchjoin(X_207,X_77);
- X_110:bat[:oid,:str] := algebra.leftfetchjoin(X_207,X_86);
- X_111:bat[:oid,:int] := algebra.leftfetchjoin(X_207,X_70);
- X_112:bat[:oid,:int] := algebra.leftfetchjoinPath(X_107,X_49,X_26);
- (X_113,r1_132,r2_132) := group.subgroup(X_112);
- (X_116,r1_135,r2_135) := group.subgroup(X_111,X_113);
- (X_119,r1_138,r2_138) := group.subgroup(X_110,X_116);
- (X_122,r1_141,r2_141) := group.subgroupdone(X_109,X_119);
- X_125 := algebra.leftfetchjoin(r1_141,X_109);
- X_126 := algebra.leftfetchjoin(r1_141,X_110);
- X_127 := algebra.leftfetchjoin(r1_141,X_111);
- X_140 := algebra.leftfetchjoin(r1_141,X_112);
- (X_128,r1_147,r2_147) := group.subgroup(X_127);
- (X_131,r1_150,r2_150) := group.subgroup(X_126,X_128);
- (X_134,r1_153,r2_153) := group.subgroupdone(X_125,X_131);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
