Changeset: 2febf6c62088 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2febf6c62088
Modified Files:
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
Branch: Oct2014
Log Message:
Approve output.
diffs (274 lines):
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
@@ -55,9 +55,9 @@ function user.s2_1{autoCommit=true}(A0:s
X_3 := sql.mvc();
X_7:bat[:oid,:oid] := sql.tid(X_3,"sys","customer");
X_10:bat[:oid,:oid] := sql.tid(X_3,"sys","orders");
- X_12 := sql.bind_idxbat(X_3,"sys","orders","orders_o_custkey_fkey",0);
+ X_12:bat[:oid,:oid] :=
sql.bind_idxbat(X_3,"sys","orders","orders_o_custkey_fkey",0);
(X_15,r1_15) :=
sql.bind_idxbat(X_3,"sys","orders","orders_o_custkey_fkey",2);
- X_18 := sql.bind_idxbat(X_3,"sys","orders","orders_o_custkey_fkey",1);
+ 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);
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
@@ -83,9 +83,9 @@ function user.s2_1{autoCommit=true}(A0:s
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 :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",0);
+ 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 :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",1);
+ 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");
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
@@ -94,12 +94,12 @@ function user.s2_1{autoCommit=true}(A0:s
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_275 := algebra.leftfetchjoin(X_58,X_23);
- X_59 :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",0);
+ X_273 := algebra.leftfetchjoin(X_58,X_23);
+ X_59:bat[:oid,:wrd] :=
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_64:bat[:oid,:wrd] :=
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_275,X_65);
+ X_66:bat[:oid,:wrd] := algebra.leftfetchjoin(X_273,X_65);
X_67:bat[:oid,:oid] := sql.tid(X_8,"sys","lineitem");
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);
@@ -108,98 +108,98 @@ function user.s2_1{autoCommit=true}(A0:s
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_276 := algebra.leftfetchjoin(X_77,X_67);
+ X_274 := 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_276,X_89);
- X_91:bat[:oid,:wrd] := mal.manifold("mkey","hash",X_90);
- X_95:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_suppkey",0);
- (X_98,r1_107) := sql.bind(X_8,"sys","lineitem","l_suppkey",2);
- X_100:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_suppkey",1);
- X_101 := sql.delta(X_95,X_98,r1_107,X_100);
- X_102:bat[:oid,:int] := algebra.leftfetchjoin(X_276,X_101);
- X_103:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_91,11,X_102);
- (X_104,r1_114) := algebra.join(X_66,X_103);
- X_106 := algebra.leftfetchjoin(X_58,X_31);
- X_107 := algebra.leftfetchjoin(X_104,X_106);
- X_108 := algebra.leftfetchjoin(r1_114,X_90);
- X_109:bat[:oid,:bit] := batcalc.==(X_107,X_108);
- X_111 := algebra.subselect(X_109,true,true,true,true,false);
- X_113 := algebra.leftfetchjoin(X_111,X_104);
- X_114:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
- (X_119,r1_132) := sql.bind(X_8,"sys","partsupp","ps_suppkey",2);
- X_122:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",1);
- X_124 := sql.delta(X_114,X_119,r1_132,X_122);
- X_125:bat[:oid,:int] := algebra.leftfetchjoin(X_275,X_124);
- X_126 := algebra.leftfetchjoin(X_113,X_125);
- X_127 := algebra.leftfetchjoin(X_111,r1_114);
- X_128 := algebra.leftfetchjoin(X_127,X_102);
- X_129:bat[:oid,:bit] := batcalc.==(X_126,X_128);
- X_130 := algebra.subselect(X_129,true,true,true,true,false);
- X_131 := algebra.leftfetchjoin(X_130,X_113);
- X_132:bat[:oid,:oid] := batcalc.identity(X_106);
- X_133 := algebra.leftfetchjoin(X_131,X_132);
- (X_134,r1_150,r2_150) := group.subgroupdone(X_133);
- X_277 := algebra.leftfetchjoin(r1_150,X_131);
- X_146:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_quantity",0);
- (X_151,r1_172) := sql.bind(X_8,"sys","lineitem","l_quantity",2);
- X_154:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_quantity",1);
- X_156 := sql.delta(X_146,X_151,r1_172,X_154);
- X_157:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_130,X_127,X_276,X_156);
- X_158:bat[:oid,:lng] := aggr.subsum(X_157,X_134,r1_150,true,true);
- X_137:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_availqty",0);
- (X_139,r1_155) := sql.bind(X_8,"sys","partsupp","ps_availqty",2);
- X_141:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_availqty",1);
- X_142 := sql.delta(X_137,X_139,r1_155,X_141);
- X_143:bat[:oid,:int] := algebra.leftfetchjoinPath(X_277,X_58,X_23,X_142);
- X_144 := calc.lng(1,A1,11,1);
- X_160:bat[:oid,:lng] := batcalc.lng(X_158,11,1);
- X_161:bat[:oid,:lng] := batcalc.*(X_144,X_160);
- X_162:bat[:oid,:int] := batcalc.int(2,X_161);
- X_163:bat[:oid,:bit] := batcalc.>(X_143,X_162);
- X_164 := algebra.subselect(X_163,true,true,true,true,false);
- X_166:bat[:oid,:int] := algebra.leftfetchjoinPath(X_164,X_277,X_125);
- (X_167,r1_197) := algebra.join(X_21,X_166);
- X_169 := algebra.tinter(X_22,X_167);
- X_278 := algebra.leftfetchjoin(X_169,X_9);
- X_170:bat[:oid,:int] := sql.bind(X_8,"sys","supplier","s_nationkey",0);
- (X_175,r1_205) := sql.bind(X_8,"sys","supplier","s_nationkey",2);
- X_178:bat[:oid,:int] := sql.bind(X_8,"sys","supplier","s_nationkey",1);
- X_180 := sql.delta(X_170,X_175,r1_205,X_178);
- X_181:bat[:oid,:int] := algebra.leftfetchjoin(X_278,X_180);
- X_182:bat[:oid,:oid] := sql.tid(X_8,"sys","nation");
- X_184:bat[:oid,:str] := sql.bind(X_8,"sys","nation","n_name",0);
- (X_186,r1_217) := sql.bind(X_8,"sys","nation","n_name",2);
- X_188:bat[:oid,:str] := sql.bind(X_8,"sys","nation","n_name",1);
- X_189 := sql.delta(X_184,X_186,r1_217,X_188);
- X_190 := algebra.leftfetchjoin(X_182,X_189);
- X_191 := algebra.subselect(X_190,A5,A5,true,true,false);
- X_193:bat[:oid,:int] := sql.bind(X_8,"sys","nation","n_nationkey",0);
- (X_195,r1_227) := sql.bind(X_8,"sys","nation","n_nationkey",2);
- X_197:bat[:oid,:int] := sql.bind(X_8,"sys","nation","n_nationkey",1);
- X_198 := sql.delta(X_193,X_195,r1_227,X_197);
- X_199:bat[:oid,:int] := algebra.leftfetchjoinPath(X_191,X_182,X_198);
- (X_200,r1_233) := algebra.join(X_181,X_199);
- X_279 := algebra.leftfetchjoin(X_200,X_169);
- X_202:bat[:oid,:str] := sql.bind(X_8,"sys","supplier","s_name",0);
- (X_207,r1_240) := sql.bind(X_8,"sys","supplier","s_name",2);
- X_210:bat[:oid,:str] := sql.bind(X_8,"sys","supplier","s_name",1);
- X_212 := sql.delta(X_202,X_207,r1_240,X_210);
- X_213:bat[:oid,:str] := algebra.leftfetchjoinPath(X_279,X_9,X_212);
- (X_214,r1_249,r2_249) := algebra.subsort(X_213,false,false);
- X_218 := algebra.leftfetchjoin(r1_249,X_213);
- X_219:bat[:oid,:str] := sql.bind(X_8,"sys","supplier","s_address",0);
- (X_221,r1_256) := sql.bind(X_8,"sys","supplier","s_address",2);
- X_223:bat[:oid,:str] := sql.bind(X_8,"sys","supplier","s_address",1);
- X_224 := sql.delta(X_219,X_221,r1_256,X_223);
- X_225:bat[:oid,:str] := algebra.leftfetchjoinPath(r1_249,X_279,X_9,X_224);
- X_226 := sql.resultSet(2,1,X_218);
- sql.rsColumn(X_226,"sys.supplier","s_name","varchar",25,0,X_218);
- sql.rsColumn(X_226,"sys.supplier","s_address","varchar",40,0,X_225);
- X_233 := io.stdout();
- sql.exportResult(X_233,X_226);
+ X_90:bat[:oid,:int] := algebra.leftfetchjoin(X_274,X_89);
+ X_91:bat[:oid,:wrd] := batmkey.hash(X_90);
+ X_93:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_suppkey",0);
+ (X_96,r1_107) := sql.bind(X_8,"sys","lineitem","l_suppkey",2);
+ X_98:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_suppkey",1);
+ X_99 := sql.delta(X_93,X_96,r1_107,X_98);
+ X_100:bat[:oid,:int] := algebra.leftfetchjoin(X_274,X_99);
+ X_101:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_91,11,X_100);
+ (X_102,r1_114) := algebra.join(X_66,X_101);
+ X_104 := algebra.leftfetchjoin(X_58,X_31);
+ X_105 := algebra.leftfetchjoin(X_102,X_104);
+ X_106 := algebra.leftfetchjoin(r1_114,X_90);
+ X_107:bat[:oid,:bit] := batcalc.==(X_105,X_106);
+ X_109 := algebra.subselect(X_107,true,true,true,true,false);
+ X_111 := algebra.leftfetchjoin(X_109,X_102);
+ X_112:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
+ (X_117,r1_132) := sql.bind(X_8,"sys","partsupp","ps_suppkey",2);
+ X_120:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",1);
+ X_122 := sql.delta(X_112,X_117,r1_132,X_120);
+ X_123:bat[:oid,:int] := algebra.leftfetchjoin(X_273,X_122);
+ X_124 := algebra.leftfetchjoin(X_111,X_123);
+ X_125 := algebra.leftfetchjoin(X_109,r1_114);
+ X_126 := algebra.leftfetchjoin(X_125,X_100);
+ X_127:bat[:oid,:bit] := batcalc.==(X_124,X_126);
+ X_128 := algebra.subselect(X_127,true,true,true,true,false);
+ X_129 := algebra.leftfetchjoin(X_128,X_111);
+ X_130:bat[:oid,:oid] := batcalc.identity(X_104);
+ X_131 := algebra.leftfetchjoin(X_129,X_130);
+ (X_132,r1_150,r2_150) := group.subgroupdone(X_131);
+ X_275 := algebra.leftfetchjoin(r1_150,X_129);
+ X_144:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_quantity",0);
+ (X_149,r1_172) := sql.bind(X_8,"sys","lineitem","l_quantity",2);
+ X_152:bat[:oid,:int] := sql.bind(X_8,"sys","lineitem","l_quantity",1);
+ X_154 := sql.delta(X_144,X_149,r1_172,X_152);
+ X_155:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_128,X_125,X_274,X_154);
+ X_156:bat[:oid,:lng] := aggr.subsum(X_155,X_132,r1_150,true,true);
+ X_135:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_availqty",0);
+ (X_137,r1_155) := sql.bind(X_8,"sys","partsupp","ps_availqty",2);
+ X_139:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_availqty",1);
+ X_140 := sql.delta(X_135,X_137,r1_155,X_139);
+ X_141:bat[:oid,:int] := algebra.leftfetchjoinPath(X_275,X_58,X_23,X_140);
+ X_142 := calc.lng(1,A1,11,1);
+ X_158:bat[:oid,:lng] := batcalc.lng(X_156,11,1);
+ X_159:bat[:oid,:lng] := batcalc.*(X_142,X_158);
+ X_160:bat[:oid,:int] := batcalc.int(2,X_159);
+ X_161:bat[:oid,:bit] := batcalc.>(X_141,X_160);
+ X_162 := algebra.subselect(X_161,true,true,true,true,false);
+ X_164:bat[:oid,:int] := algebra.leftfetchjoinPath(X_162,X_275,X_123);
+ (X_165,r1_197) := algebra.join(X_21,X_164);
+ X_167 := algebra.tinter(X_22,X_165);
+ X_276 := algebra.leftfetchjoin(X_167,X_9);
+ X_168:bat[:oid,:int] := sql.bind(X_8,"sys","supplier","s_nationkey",0);
+ (X_173,r1_205) := sql.bind(X_8,"sys","supplier","s_nationkey",2);
+ X_176:bat[:oid,:int] := sql.bind(X_8,"sys","supplier","s_nationkey",1);
+ X_178 := sql.delta(X_168,X_173,r1_205,X_176);
+ X_179:bat[:oid,:int] := algebra.leftfetchjoin(X_276,X_178);
+ X_180:bat[:oid,:oid] := sql.tid(X_8,"sys","nation");
+ X_182:bat[:oid,:str] := sql.bind(X_8,"sys","nation","n_name",0);
+ (X_184,r1_217) := sql.bind(X_8,"sys","nation","n_name",2);
+ X_186:bat[:oid,:str] := sql.bind(X_8,"sys","nation","n_name",1);
+ X_187 := sql.delta(X_182,X_184,r1_217,X_186);
+ X_188 := algebra.leftfetchjoin(X_180,X_187);
+ X_189 := algebra.subselect(X_188,A5,A5,true,true,false);
+ X_191:bat[:oid,:int] := sql.bind(X_8,"sys","nation","n_nationkey",0);
+ (X_193,r1_227) := sql.bind(X_8,"sys","nation","n_nationkey",2);
+ X_195:bat[:oid,:int] := sql.bind(X_8,"sys","nation","n_nationkey",1);
+ X_196 := sql.delta(X_191,X_193,r1_227,X_195);
+ X_197:bat[:oid,:int] := algebra.leftfetchjoinPath(X_189,X_180,X_196);
+ (X_198,r1_233) := algebra.join(X_179,X_197);
+ X_277 := algebra.leftfetchjoin(X_198,X_167);
+ X_200:bat[:oid,:str] := sql.bind(X_8,"sys","supplier","s_name",0);
+ (X_205,r1_240) := sql.bind(X_8,"sys","supplier","s_name",2);
+ X_208:bat[:oid,:str] := sql.bind(X_8,"sys","supplier","s_name",1);
+ X_210 := sql.delta(X_200,X_205,r1_240,X_208);
+ X_211:bat[:oid,:str] := algebra.leftfetchjoinPath(X_277,X_9,X_210);
+ (X_212,r1_249,r2_249) := algebra.subsort(X_211,false,false);
+ X_216 := algebra.leftfetchjoin(r1_249,X_211);
+ X_217:bat[:oid,:str] := sql.bind(X_8,"sys","supplier","s_address",0);
+ (X_219,r1_256) := sql.bind(X_8,"sys","supplier","s_address",2);
+ X_221:bat[:oid,:str] := sql.bind(X_8,"sys","supplier","s_address",1);
+ X_222 := sql.delta(X_217,X_219,r1_256,X_221);
+ X_223:bat[:oid,:str] := algebra.leftfetchjoinPath(r1_249,X_277,X_9,X_222);
+ X_224 := sql.resultSet(2,1,X_216);
+ sql.rsColumn(X_224,"sys.supplier","s_name","varchar",25,0,X_216);
+ sql.rsColumn(X_224,"sys.supplier","s_address","varchar",40,0,X_223);
+ X_231 := io.stdout();
+ sql.exportResult(X_231,X_224);
end s2_1;
# 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")
diff --git a/sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
b/sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
@@ -77,9 +77,9 @@ function user.s2_1{autoCommit=true}(A0:s
X_25:bat[:oid,:bit] := batcalc.>(X_17,X_24);
X_26 := algebra.subselect(X_25,true,true,true,true,false);
X_253 := algebra.leftfetchjoin(X_26,X_5);
- X_28 := sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_orderkey_fkey",0);
+ X_28:bat[:oid,:oid] :=
sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_orderkey_fkey",0);
(X_30,r1_32) :=
sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_orderkey_fkey",2);
- X_32 := sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_orderkey_fkey",1);
+ X_32:bat[:oid,:oid] :=
sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_orderkey_fkey",1);
X_33 := sql.delta(X_28,X_30,r1_32,X_32);
X_34:bat[:oid,:oid] := algebra.leftfetchjoin(X_253,X_33);
X_35:bat[:oid,:oid] := sql.tid(X_4,"sys","orders");
@@ -92,17 +92,17 @@ function user.s2_1{autoCommit=true}(A0:s
X_50 := algebra.leftfetchjoin(X_48,X_35);
(X_51,r1_55) := algebra.join(X_34,X_50);
X_254 := algebra.leftfetchjoin(X_51,X_26);
- X_53 := sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_suppkey_fkey",0);
+ X_53:bat[:oid,:oid] :=
sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_suppkey_fkey",0);
(X_56,r1_60) :=
sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_suppkey_fkey",2);
- X_58 := sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_suppkey_fkey",1);
+ X_58:bat[:oid,:oid] :=
sql.bind_idxbat(X_4,"sys","lineitem","lineitem_l_suppkey_fkey",1);
X_59 := sql.delta(X_53,X_56,r1_60,X_58);
X_60:bat[:oid,:oid] := algebra.leftfetchjoinPath(X_254,X_5,X_59);
X_61:bat[:oid,:oid] := sql.tid(X_4,"sys","supplier");
(X_63,r1_69) := algebra.join(X_60,X_61);
X_255 := algebra.leftfetchjoin(r1_69,X_61);
- X_65 :=
sql.bind_idxbat(X_4,"sys","supplier","supplier_s_nationkey_fkey",0);
+ X_65:bat[:oid,:oid] :=
sql.bind_idxbat(X_4,"sys","supplier","supplier_s_nationkey_fkey",0);
(X_68,r1_74) :=
sql.bind_idxbat(X_4,"sys","supplier","supplier_s_nationkey_fkey",2);
- X_70 :=
sql.bind_idxbat(X_4,"sys","supplier","supplier_s_nationkey_fkey",1);
+ X_70:bat[:oid,:oid] :=
sql.bind_idxbat(X_4,"sys","supplier","supplier_s_nationkey_fkey",1);
X_71 := sql.delta(X_65,X_68,r1_74,X_70);
X_72:bat[:oid,:oid] := algebra.leftfetchjoin(X_255,X_71);
X_73:bat[:oid,:oid] := sql.tid(X_4,"sys","nation");
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
