Changeset: 06987ac64fc9 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=06987ac64fc9
Modified Files:
sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
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/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
sql/benchmarks/tpch/Tests/15-explain.stable.out.int128
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/22-explain.stable.out.int128
Branch: default
Log Message:
ssbm & tpch: approved int128 MAL plans (explain)
diffs (truncated from 2083 to 300 lines):
diff --git a/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
@@ -42,30 +42,30 @@ function user.s2_1{autoCommit=true}(A0:i
X_10 := sql.bind(X_6,"sys","lineorder","lo_quantity",0);
X_18 := sql.bind(X_6,"sys","lineorder","lo_discount",0);
X_7:bat[:oid,:oid] := sql.tid(X_6,"sys","lineorder");
- X_90 := algebra.subselect(X_18,X_7,A1,A2,true,true,false);
+ X_91 := algebra.subselect(X_18,X_7,A1,A2,true,true,false);
(X_20,r1_23) := sql.bind(X_6,"sys","lineorder","lo_discount",2);
- X_91 := algebra.subselect(r1_23,A1,A2,true,true,false);
+ X_92 := algebra.subselect(r1_23,A1,A2,true,true,false);
X_22 := sql.bind(X_6,"sys","lineorder","lo_discount",1);
- X_92 := algebra.subselect(X_22,X_7,A1,A2,true,true,false);
- X_23 := sql.subdelta(X_90,X_7,X_20,X_91,X_92);
- X_93 := algebra.thetasubselect(X_10,X_23,A3,"<");
+ X_93 := algebra.subselect(X_22,X_7,A1,A2,true,true,false);
+ X_23 := sql.subdelta(X_91,X_7,X_20,X_92,X_93);
+ X_94 := algebra.thetasubselect(X_10,X_23,A3,"<");
(X_13,r1_13) := sql.bind(X_6,"sys","lineorder","lo_quantity",2);
- X_94 := algebra.thetasubselect(r1_13,A3,"<");
+ X_95 := algebra.thetasubselect(r1_13,A3,"<");
X_16 := sql.bind(X_6,"sys","lineorder","lo_quantity",1);
- X_95 := algebra.thetasubselect(X_16,X_23,A3,"<");
- X_25 := sql.subdelta(X_93,X_23,X_13,X_94,X_95);
+ X_96 := algebra.thetasubselect(X_16,X_23,A3,"<");
+ X_25 := sql.subdelta(X_94,X_23,X_13,X_95,X_96);
X_27 :=
sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",0);
(X_29,r1_36) :=
sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",2);
X_31 :=
sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",1);
X_32 := sql.projectdelta(X_25,X_27,X_29,r1_36,X_31);
X_36 := sql.bind(X_6,"sys","dwdate","d_year",0);
X_33:bat[:oid,:oid] := sql.tid(X_6,"sys","dwdate");
- X_96 := algebra.subselect(X_36,X_33,A0,A0,true,true,false);
+ X_97 := algebra.subselect(X_36,X_33,A0,A0,true,true,false);
(X_39,r1_48) := sql.bind(X_6,"sys","dwdate","d_year",2);
- X_97 := algebra.subselect(r1_48,A0,A0,true,true,false);
+ X_98 := algebra.subselect(r1_48,A0,A0,true,true,false);
X_42 := sql.bind(X_6,"sys","dwdate","d_year",1);
- X_98 := algebra.subselect(X_42,X_33,A0,A0,true,true,false);
- X_44 := sql.subdelta(X_96,X_33,X_39,X_97,X_98);
+ X_99 := algebra.subselect(X_42,X_33,A0,A0,true,true,false);
+ X_44 := sql.subdelta(X_97,X_33,X_39,X_98,X_99);
X_46 := X_44;
(X_47,r1_59) := algebra.join(X_32,X_46);
X_49 := sql.bind(X_6,"sys","lineorder","lo_extendedprice",0);
diff --git a/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
@@ -42,30 +42,30 @@ function user.s2_1{autoCommit=true}(A0:i
X_11 := sql.bind(X_7,"sys","lineorder","lo_quantity",0);
X_19 := sql.bind(X_7,"sys","lineorder","lo_discount",0);
X_8:bat[:oid,:oid] := sql.tid(X_7,"sys","lineorder");
- X_90 := algebra.subselect(X_19,X_8,A1,A2,true,true,false);
+ X_91 := algebra.subselect(X_19,X_8,A1,A2,true,true,false);
(X_21,r1_25) := sql.bind(X_7,"sys","lineorder","lo_discount",2);
- X_91 := algebra.subselect(r1_25,A1,A2,true,true,false);
+ X_92 := algebra.subselect(r1_25,A1,A2,true,true,false);
X_23 := sql.bind(X_7,"sys","lineorder","lo_discount",1);
- X_92 := algebra.subselect(X_23,X_8,A1,A2,true,true,false);
- X_24 := sql.subdelta(X_90,X_8,X_21,X_91,X_92);
- X_93 := algebra.subselect(X_11,X_24,A3,A4,true,true,false);
+ X_93 := algebra.subselect(X_23,X_8,A1,A2,true,true,false);
+ X_24 := sql.subdelta(X_91,X_8,X_21,X_92,X_93);
+ X_94 := algebra.subselect(X_11,X_24,A3,A4,true,true,false);
(X_14,r1_14) := sql.bind(X_7,"sys","lineorder","lo_quantity",2);
- X_94 := algebra.subselect(r1_14,A3,A4,true,true,false);
+ X_95 := algebra.subselect(r1_14,A3,A4,true,true,false);
X_17 := sql.bind(X_7,"sys","lineorder","lo_quantity",1);
- X_95 := algebra.subselect(X_17,X_24,A3,A4,true,true,false);
- X_26 := sql.subdelta(X_93,X_24,X_14,X_94,X_95);
+ X_96 := algebra.subselect(X_17,X_24,A3,A4,true,true,false);
+ X_26 := sql.subdelta(X_94,X_24,X_14,X_95,X_96);
X_27 :=
sql.bind_idxbat(X_7,"sys","lineorder","lineorder_lo_orderdate_fkey",0);
(X_29,r1_37) :=
sql.bind_idxbat(X_7,"sys","lineorder","lineorder_lo_orderdate_fkey",2);
X_31 :=
sql.bind_idxbat(X_7,"sys","lineorder","lineorder_lo_orderdate_fkey",1);
X_32 := sql.projectdelta(X_26,X_27,X_29,r1_37,X_31);
X_36 := sql.bind(X_7,"sys","dwdate","d_yearmonthnum",0);
X_33:bat[:oid,:oid] := sql.tid(X_7,"sys","dwdate");
- X_96 := algebra.subselect(X_36,X_33,A0,A0,true,true,false);
+ X_97 := algebra.subselect(X_36,X_33,A0,A0,true,true,false);
(X_39,r1_49) := sql.bind(X_7,"sys","dwdate","d_yearmonthnum",2);
- X_97 := algebra.subselect(r1_49,A0,A0,true,true,false);
+ X_98 := algebra.subselect(r1_49,A0,A0,true,true,false);
X_42 := sql.bind(X_7,"sys","dwdate","d_yearmonthnum",1);
- X_98 := algebra.subselect(X_42,X_33,A0,A0,true,true,false);
- X_44 := sql.subdelta(X_96,X_33,X_39,X_97,X_98);
+ X_99 := algebra.subselect(X_42,X_33,A0,A0,true,true,false);
+ X_44 := sql.subdelta(X_97,X_33,X_39,X_98,X_99);
X_46 := X_44;
(X_47,r1_60) := algebra.join(X_32,X_46);
X_49 := sql.bind(X_7,"sys","lineorder","lo_extendedprice",0);
diff --git a/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
@@ -42,18 +42,18 @@ function user.s2_1{autoCommit=true}(A0:i
X_12 := sql.bind(X_8,"sys","lineorder","lo_quantity",0);
X_20 := sql.bind(X_8,"sys","lineorder","lo_discount",0);
X_9:bat[:oid,:oid] := sql.tid(X_8,"sys","lineorder");
- X_101 := algebra.subselect(X_20,X_9,A2,A3,true,true,false);
+ X_102 := algebra.subselect(X_20,X_9,A2,A3,true,true,false);
(X_22,r1_26) := sql.bind(X_8,"sys","lineorder","lo_discount",2);
- X_102 := algebra.subselect(r1_26,A2,A3,true,true,false);
+ X_103 := algebra.subselect(r1_26,A2,A3,true,true,false);
X_24 := sql.bind(X_8,"sys","lineorder","lo_discount",1);
- X_103 := algebra.subselect(X_24,X_9,A2,A3,true,true,false);
- X_25 := sql.subdelta(X_101,X_9,X_22,X_102,X_103);
- X_104 := algebra.subselect(X_12,X_25,A4,A5,true,true,false);
+ X_104 := algebra.subselect(X_24,X_9,A2,A3,true,true,false);
+ X_25 := sql.subdelta(X_102,X_9,X_22,X_103,X_104);
+ X_105 := algebra.subselect(X_12,X_25,A4,A5,true,true,false);
(X_15,r1_15) := sql.bind(X_8,"sys","lineorder","lo_quantity",2);
- X_105 := algebra.subselect(r1_15,A4,A5,true,true,false);
+ X_106 := algebra.subselect(r1_15,A4,A5,true,true,false);
X_18 := sql.bind(X_8,"sys","lineorder","lo_quantity",1);
- X_106 := algebra.subselect(X_18,X_25,A4,A5,true,true,false);
- X_27 := sql.subdelta(X_104,X_25,X_15,X_105,X_106);
+ X_107 := algebra.subselect(X_18,X_25,A4,A5,true,true,false);
+ X_27 := sql.subdelta(X_105,X_25,X_15,X_106,X_107);
X_28 :=
sql.bind_idxbat(X_8,"sys","lineorder","lineorder_lo_orderdate_fkey",0);
(X_30,r1_38) :=
sql.bind_idxbat(X_8,"sys","lineorder","lineorder_lo_orderdate_fkey",2);
X_32 :=
sql.bind_idxbat(X_8,"sys","lineorder","lineorder_lo_orderdate_fkey",1);
@@ -61,18 +61,18 @@ function user.s2_1{autoCommit=true}(A0:i
X_37 := sql.bind(X_8,"sys","dwdate","d_weeknuminyear",0);
X_45 := sql.bind(X_8,"sys","dwdate","d_year",0);
X_34:bat[:oid,:oid] := sql.tid(X_8,"sys","dwdate");
- X_107 := algebra.subselect(X_45,X_34,A1,A1,true,true,false);
+ X_108 := algebra.subselect(X_45,X_34,A1,A1,true,true,false);
(X_47,r1_60) := sql.bind(X_8,"sys","dwdate","d_year",2);
- X_108 := algebra.subselect(r1_60,A1,A1,true,true,false);
+ X_109 := algebra.subselect(r1_60,A1,A1,true,true,false);
X_49 := sql.bind(X_8,"sys","dwdate","d_year",1);
- X_109 := algebra.subselect(X_49,X_34,A1,A1,true,true,false);
- X_50 := sql.subdelta(X_107,X_34,X_47,X_108,X_109);
- X_110 := algebra.subselect(X_37,X_50,A0,A0,true,true,false);
+ X_110 := algebra.subselect(X_49,X_34,A1,A1,true,true,false);
+ X_50 := sql.subdelta(X_108,X_34,X_47,X_109,X_110);
+ X_111 := algebra.subselect(X_37,X_50,A0,A0,true,true,false);
(X_40,r1_50) := sql.bind(X_8,"sys","dwdate","d_weeknuminyear",2);
- X_111 := algebra.subselect(r1_50,A0,A0,true,true,false);
+ X_112 := algebra.subselect(r1_50,A0,A0,true,true,false);
X_43 := sql.bind(X_8,"sys","dwdate","d_weeknuminyear",1);
- X_112 := algebra.subselect(X_43,X_50,A0,A0,true,true,false);
- X_53 := sql.subdelta(X_110,X_50,X_40,X_111,X_112);
+ X_113 := algebra.subselect(X_43,X_50,A0,A0,true,true,false);
+ X_53 := sql.subdelta(X_111,X_50,X_40,X_112,X_113);
X_54 := X_53;
(X_55,r1_71) := algebra.join(X_33,X_54);
X_57 := sql.bind(X_8,"sys","lineorder","lo_extendedprice",0);
diff --git a/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
@@ -49,12 +49,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_16 := sql.projectdelta(X_5,X_8,X_11,r1_11,X_14);
X_19 := sql.bind(X_4,"sys","part","p_category",0);
X_17:bat[:oid,:oid] := sql.tid(X_4,"sys","part");
- X_159 := algebra.subselect(X_19,X_17,A0,A0,true,true,false);
+ X_160 := algebra.subselect(X_19,X_17,A0,A0,true,true,false);
(X_21,r1_22) := sql.bind(X_4,"sys","part","p_category",2);
- X_160 := algebra.subselect(r1_22,A0,A0,true,true,false);
+ X_161 := algebra.subselect(r1_22,A0,A0,true,true,false);
X_23 := sql.bind(X_4,"sys","part","p_category",1);
- X_161 := algebra.subselect(X_23,X_17,A0,A0,true,true,false);
- X_24 := sql.subdelta(X_159,X_17,X_21,X_160,X_161);
+ X_162 := algebra.subselect(X_23,X_17,A0,A0,true,true,false);
+ X_24 := sql.subdelta(X_160,X_17,X_21,X_161,X_162);
X_26 := X_24;
(X_27,r1_31) := algebra.join(X_16,X_26);
X_29 :=
sql.bind_idxbat(X_4,"sys","lineorder","lineorder_lo_suppkey_fkey",0);
@@ -64,28 +64,28 @@ function user.s2_1{autoCommit=true}(A0:s
X_35 := algebra.leftfetchjoin(X_27,X_34);
X_39 := sql.bind(X_4,"sys","supplier","s_region",0);
X_36:bat[:oid,:oid] := sql.tid(X_4,"sys","supplier");
- X_162 := algebra.subselect(X_39,X_36,A1,A1,true,true,false);
+ X_163 := algebra.subselect(X_39,X_36,A1,A1,true,true,false);
(X_42,r1_47) := sql.bind(X_4,"sys","supplier","s_region",2);
- X_163 := algebra.subselect(r1_47,A1,A1,true,true,false);
+ X_164 := algebra.subselect(r1_47,A1,A1,true,true,false);
X_45 := sql.bind(X_4,"sys","supplier","s_region",1);
- X_164 := algebra.subselect(X_45,X_36,A1,A1,true,true,false);
- X_47 := sql.subdelta(X_162,X_36,X_42,X_163,X_164);
+ X_165 := algebra.subselect(X_45,X_36,A1,A1,true,true,false);
+ X_47 := sql.subdelta(X_163,X_36,X_42,X_164,X_165);
X_49 := X_47;
(X_50,r1_58) := algebra.join(X_35,X_49);
- X_165 := algebra.leftfetchjoin(X_50,X_27);
+ X_166 := algebra.leftfetchjoin(X_50,X_27);
X_52 :=
sql.bind_idxbat(X_4,"sys","lineorder","lineorder_lo_orderdate_fkey",0);
(X_55,r1_63) :=
sql.bind_idxbat(X_4,"sys","lineorder","lineorder_lo_orderdate_fkey",2);
X_57 :=
sql.bind_idxbat(X_4,"sys","lineorder","lineorder_lo_orderdate_fkey",1);
X_58 := sql.projectdelta(X_5,X_52,X_55,r1_63,X_57);
- X_59:bat[:oid,:oid] := algebra.leftfetchjoin(X_165,X_58);
+ X_59:bat[:oid,:oid] := algebra.leftfetchjoin(X_166,X_58);
X_60:bat[:oid,:oid] := sql.tid(X_4,"sys","dwdate");
(X_62,r1_72) := algebra.join(X_59,X_60);
- X_166 := algebra.leftfetchjoin(X_62,X_50);
+ X_167 := algebra.leftfetchjoin(X_62,X_50);
X_64 := sql.bind(X_4,"sys","part","p_brand1",0);
(X_68,r1_78) := sql.bind(X_4,"sys","part","p_brand1",2);
X_70 := sql.bind(X_4,"sys","part","p_brand1",1);
X_71 := sql.projectdelta(X_24,X_64,X_68,r1_78,X_70);
- X_72:bat[:oid,:str] := algebra.leftfetchjoinPath(X_166,r1_31,X_71);
+ X_72:bat[:oid,:str] := algebra.leftfetchjoinPath(X_167,r1_31,X_71);
X_73 := sql.bind(X_4,"sys","dwdate","d_year",0);
(X_76,r1_90) := sql.bind(X_4,"sys","dwdate","d_year",2);
X_79 := sql.bind(X_4,"sys","dwdate","d_year",1);
@@ -99,7 +99,7 @@ function user.s2_1{autoCommit=true}(A0:s
(X_102,r1_117) := sql.bind(X_4,"sys","lineorder","lo_revenue",2);
X_104 := sql.bind(X_4,"sys","lineorder","lo_revenue",1);
X_105 := sql.projectdelta(X_5,X_98,X_102,r1_117,X_104);
- X_106:bat[:oid,:int] := algebra.leftfetchjoinPath(X_166,X_27,X_105);
+ X_106:bat[:oid,:int] := algebra.leftfetchjoinPath(X_167,X_27,X_105);
X_107:bat[:oid,:hge] := aggr.subsum(X_106,X_86,r1_101,true,true);
(X_91,r1_106,r2_106) := algebra.subsort(X_90,false,false);
(X_95,r1_110,r2_110) := algebra.subsort(X_89,r1_106,r2_106,false,false);
diff --git a/sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
@@ -51,12 +51,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_17 := sql.projectdelta(X_6,X_9,X_12,r1_12,X_15);
X_20 := sql.bind(X_5,"sys","part","p_brand1",0);
X_18:bat[:oid,:oid] := sql.tid(X_5,"sys","part");
- X_153 := algebra.subselect(X_20,X_18,A0,A1,true,true,false);
+ X_154 := algebra.subselect(X_20,X_18,A0,A1,true,true,false);
(X_22,r1_23) := sql.bind(X_5,"sys","part","p_brand1",2);
- X_154 := algebra.subselect(r1_23,A0,A1,true,true,false);
+ X_155 := algebra.subselect(r1_23,A0,A1,true,true,false);
X_24 := sql.bind(X_5,"sys","part","p_brand1",1);
- X_155 := algebra.subselect(X_24,X_18,A0,A1,true,true,false);
- X_25 := sql.subdelta(X_153,X_18,X_22,X_154,X_155);
+ X_156 := algebra.subselect(X_24,X_18,A0,A1,true,true,false);
+ X_25 := sql.subdelta(X_154,X_18,X_22,X_155,X_156);
X_27 := X_25;
(X_28,r1_33) := algebra.join(X_17,X_27);
X_30 :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_suppkey_fkey",0);
@@ -66,25 +66,25 @@ function user.s2_1{autoCommit=true}(A0:s
X_38 := algebra.leftfetchjoin(X_28,X_37);
X_41 := sql.bind(X_5,"sys","supplier","s_region",0);
X_39:bat[:oid,:oid] := sql.tid(X_5,"sys","supplier");
- X_156 := algebra.subselect(X_41,X_39,A2,A2,true,true,false);
+ X_157 := algebra.subselect(X_41,X_39,A2,A2,true,true,false);
(X_44,r1_50) := sql.bind(X_5,"sys","supplier","s_region",2);
- X_157 := algebra.subselect(r1_50,A2,A2,true,true,false);
+ X_158 := algebra.subselect(r1_50,A2,A2,true,true,false);
X_47 := sql.bind(X_5,"sys","supplier","s_region",1);
- X_158 := algebra.subselect(X_47,X_39,A2,A2,true,true,false);
- X_49 := sql.subdelta(X_156,X_39,X_44,X_157,X_158);
+ X_159 := algebra.subselect(X_47,X_39,A2,A2,true,true,false);
+ X_49 := sql.subdelta(X_157,X_39,X_44,X_158,X_159);
X_51 := X_49;
(X_52,r1_61) := algebra.join(X_38,X_51);
- X_159 := algebra.leftfetchjoin(X_52,X_28);
+ X_160 := algebra.leftfetchjoin(X_52,X_28);
X_54 :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",0);
(X_56,r1_65) :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",2);
X_58 :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",1);
X_59 := sql.projectdelta(X_6,X_54,X_56,r1_65,X_58);
- X_60:bat[:oid,:oid] := algebra.leftfetchjoin(X_159,X_59);
+ X_60:bat[:oid,:oid] := algebra.leftfetchjoin(X_160,X_59);
X_61:bat[:oid,:oid] := sql.tid(X_5,"sys","dwdate");
(X_64,r1_75) := algebra.join(X_60,X_61);
- X_160 := algebra.leftfetchjoin(X_64,X_52);
+ X_161 := algebra.leftfetchjoin(X_64,X_52);
X_66 := sql.projectdelta(X_25,X_20,X_22,r1_23,X_24);
- X_67:bat[:oid,:str] := algebra.leftfetchjoinPath(X_160,r1_33,X_66);
+ X_67:bat[:oid,:str] := algebra.leftfetchjoinPath(X_161,r1_33,X_66);
X_68 := sql.bind(X_5,"sys","dwdate","d_year",0);
(X_71,r1_84) := sql.bind(X_5,"sys","dwdate","d_year",2);
X_74 := sql.bind(X_5,"sys","dwdate","d_year",1);
@@ -98,7 +98,7 @@ function user.s2_1{autoCommit=true}(A0:s
(X_97,r1_111) := sql.bind(X_5,"sys","lineorder","lo_revenue",2);
X_99 := sql.bind(X_5,"sys","lineorder","lo_revenue",1);
X_100 := sql.projectdelta(X_6,X_93,X_97,r1_111,X_99);
- X_101:bat[:oid,:int] := algebra.leftfetchjoinPath(X_160,X_28,X_100);
+ X_101:bat[:oid,:int] := algebra.leftfetchjoinPath(X_161,X_28,X_100);
X_102:bat[:oid,:hge] := aggr.subsum(X_101,X_81,r1_95,true,true);
(X_86,r1_100,r2_100) := algebra.subsort(X_85,false,false);
(X_90,r1_104,r2_104) := algebra.subsort(X_84,r1_100,r2_100,false,false);
diff --git a/sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
@@ -51,12 +51,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_16 := sql.projectdelta(X_5,X_8,X_11,r1_11,X_14);
X_19 := sql.bind(X_4,"sys","part","p_brand1",0);
X_17:bat[:oid,:oid] := sql.tid(X_4,"sys","part");
- X_151 := algebra.subselect(X_19,X_17,A0,A0,true,true,false);
+ X_152 := algebra.subselect(X_19,X_17,A0,A0,true,true,false);
(X_21,r1_22) := sql.bind(X_4,"sys","part","p_brand1",2);
- X_152 := algebra.subselect(r1_22,A0,A0,true,true,false);
+ X_153 := algebra.subselect(r1_22,A0,A0,true,true,false);
X_23 := sql.bind(X_4,"sys","part","p_brand1",1);
- X_153 := algebra.subselect(X_23,X_17,A0,A0,true,true,false);
- X_24 := sql.subdelta(X_151,X_17,X_21,X_152,X_153);
+ X_154 := algebra.subselect(X_23,X_17,A0,A0,true,true,false);
+ X_24 := sql.subdelta(X_152,X_17,X_21,X_153,X_154);
X_26 := X_24;
(X_27,r1_31) := algebra.join(X_16,X_26);
X_29 :=
sql.bind_idxbat(X_4,"sys","lineorder","lineorder_lo_suppkey_fkey",0);
@@ -66,25 +66,25 @@ function user.s2_1{autoCommit=true}(A0:s
X_35 := algebra.leftfetchjoin(X_27,X_34);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
