Changeset: 0ecea60976da for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0ecea60976da
Modified Files:
sql/benchmarks/tpch/Tests/20-explain.stable.out
sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
Branch: default
Log Message:
Approved.
diffs (truncated from 388 to 300 lines):
diff --git a/sql/benchmarks/tpch/Tests/20-explain.stable.out
b/sql/benchmarks/tpch/Tests/20-explain.stable.out
--- a/sql/benchmarks/tpch/Tests/20-explain.stable.out
+++ b/sql/benchmarks/tpch/Tests/20-explain.stable.out
@@ -85,12 +85,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_38 := sql.delta(X_33,X_35,r1_36,X_37);
X_39:bat[:oid,:int] := algebra.leftfetchjoinPath(X_31,X_22,X_38);
(X_40,r1_42) := algebra.join(X_21,X_39);
- X_282 := algebra.leftfetchjoin(X_40,X_9);
+ X_284 := algebra.leftfetchjoin(X_40,X_9);
X_42 := sql.bind(X_8,"sys","supplier","s_suppkey",0);
(X_47,r1_49) := sql.bind(X_8,"sys","supplier","s_suppkey",2);
X_50 := sql.bind(X_8,"sys","supplier","s_suppkey",1);
X_52 := sql.delta(X_42,X_47,r1_49,X_50);
- X_53:bat[:oid,:int] := algebra.leftfetchjoin(X_282,X_52);
+ X_53:bat[:oid,:int] := algebra.leftfetchjoin(X_284,X_52);
X_54 := bat.mirror(X_53);
X_55:bat[:oid,:oid] := sql.tid(X_8,"sys","partsupp");
X_57 := sql.bind(X_8,"sys","partsupp","ps_partkey",0);
@@ -113,12 +113,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_87:bat[:oid,:int] := algebra.leftfetchjoinPath(X_75,X_65,X_86);
(X_88,r1_94) := algebra.join(X_63,X_87);
X_90 := algebra.tinter(X_64,X_88);
- X_283 := algebra.leftfetchjoin(X_90,X_55);
+ X_285 := algebra.leftfetchjoin(X_90,X_55);
X_91 :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",0);
(X_94,r1_100) :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",2);
X_96 :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",1);
X_97 := sql.delta(X_91,X_94,r1_100,X_96);
- X_98:bat[:oid,:wrd] := algebra.leftfetchjoin(X_283,X_97);
+ X_98:bat[:oid,:wrd] := algebra.leftfetchjoin(X_285,X_97);
X_99:bat[:oid,:oid] := sql.tid(X_8,"sys","lineitem");
X_101 := sql.bind(X_8,"sys","lineitem","l_shipdate",0);
(X_103,r1_110) := sql.bind(X_8,"sys","lineitem","l_shipdate",2);
@@ -127,85 +127,85 @@ function user.s2_1{autoCommit=true}(A0:s
X_107 := algebra.leftfetchjoin(X_99,X_106);
X_108 := mtime.addmonths(A3,A4);
X_109 := algebra.subselect(X_107,A2,X_108,true,false,false);
- X_284 := algebra.leftfetchjoin(X_109,X_99);
+ X_286 := algebra.leftfetchjoin(X_109,X_99);
X_112 := sql.bind(X_8,"sys","lineitem","l_partkey",0);
(X_116,r1_126) := sql.bind(X_8,"sys","lineitem","l_partkey",2);
X_119 := sql.bind(X_8,"sys","lineitem","l_partkey",1);
X_121 := sql.delta(X_112,X_116,r1_126,X_119);
- X_122:bat[:oid,:int] := algebra.leftfetchjoin(X_284,X_121);
- X_123:bat[:oid,:wrd] := batcalc.hash(X_122);
- X_125 := sql.bind(X_8,"sys","lineitem","l_suppkey",0);
- (X_128,r1_142) := sql.bind(X_8,"sys","lineitem","l_suppkey",2);
- X_130 := sql.bind(X_8,"sys","lineitem","l_suppkey",1);
- X_131 := sql.delta(X_125,X_128,r1_142,X_130);
- X_132:bat[:oid,:int] := algebra.leftfetchjoin(X_284,X_131);
- X_133:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_123,22,X_132);
- (X_134,r1_149) := algebra.join(X_98,X_133);
- X_136 := algebra.leftfetchjoin(X_90,X_63);
- X_137 := algebra.leftfetchjoin(X_134,X_136);
- X_138 := algebra.leftfetchjoin(r1_149,X_122);
- X_139:bat[:oid,:bit] := batcalc.==(X_137,X_138);
- X_141 := algebra.subselect(X_139,true,true,true,true,false);
- X_143 := algebra.leftfetchjoin(X_141,X_134);
- X_144 := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
- (X_149,r1_166) := sql.bind(X_8,"sys","partsupp","ps_suppkey",2);
- X_152 := sql.bind(X_8,"sys","partsupp","ps_suppkey",1);
- X_154 := sql.delta(X_144,X_149,r1_166,X_152);
- X_155:bat[:oid,:int] := algebra.leftfetchjoin(X_283,X_154);
- X_156 := algebra.leftfetchjoin(X_143,X_155);
- X_157 := algebra.leftfetchjoin(X_141,r1_149);
- X_158 := algebra.leftfetchjoin(X_157,X_132);
- X_159:bat[:oid,:bit] := batcalc.==(X_156,X_158);
- X_160 := algebra.subselect(X_159,true,true,true,true,false);
- X_161 := algebra.leftfetchjoin(X_160,X_143);
- X_162:bat[:oid,:oid] := batcalc.identity(X_136);
- X_163 := algebra.leftfetchjoin(X_161,X_162);
- (X_164,r1_185,r2_185) := group.subgroupdone(X_163);
- X_285 := algebra.leftfetchjoin(r1_185,X_161);
- X_180 := sql.bind(X_8,"sys","lineitem","l_quantity",0);
- (X_185,r1_212) := sql.bind(X_8,"sys","lineitem","l_quantity",2);
- X_187 := sql.bind(X_8,"sys","lineitem","l_quantity",1);
- X_188 := sql.delta(X_180,X_185,r1_212,X_187);
- X_189:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_160,X_157,X_284,X_188);
- X_190:bat[:oid,:lng] := aggr.subsum(X_189,X_164,r1_185,true,true);
- X_167 := sql.bind(X_8,"sys","partsupp","ps_availqty",0);
- (X_169,r1_190) := sql.bind(X_8,"sys","partsupp","ps_availqty",2);
- X_171 := sql.bind(X_8,"sys","partsupp","ps_availqty",1);
- X_172 := sql.delta(X_167,X_169,r1_190,X_171);
- X_173:bat[:oid,:int] := algebra.leftfetchjoinPath(X_285,X_90,X_55,X_172);
- X_174:bat[:oid,:lng] := batcalc.lng(X_173,19,2);
- X_177 := calc.lng(1,A1,11,1);
- X_192:bat[:oid,:lng] := batcalc.lng(X_190,11,1);
- X_193:bat[:oid,:lng] := batcalc.*(X_177,X_192);
- X_194:bat[:oid,:bit] := batcalc.>(X_174,X_193);
- X_195 := algebra.subselect(X_194,true,true,true,true,false);
- X_197:bat[:oid,:int] := algebra.leftfetchjoinPath(X_195,X_285,X_155);
- X_198 := bat.mirror(X_197);
- (X_199,r1_233) := algebra.join(X_197,X_53);
- X_201 := algebra.tinter(X_198,X_199);
- X_202 := algebra.leftfetchjoin(X_201,X_197);
- (X_203,r1_237,r2_237) := group.subgroupdone(X_202);
- X_206 := algebra.leftfetchjoin(r1_237,X_202);
- (X_207,r1_241) := algebra.join(X_53,X_206);
- X_209 := algebra.tinter(X_54,X_207);
- X_286 := algebra.leftfetchjoin(X_209,X_40);
- X_210 := sql.bind(X_8,"sys","supplier","s_name",0);
- (X_215,r1_249) := sql.bind(X_8,"sys","supplier","s_name",2);
- X_218 := sql.bind(X_8,"sys","supplier","s_name",1);
- X_220 := sql.delta(X_210,X_215,r1_249,X_218);
- X_221:bat[:oid,:str] := algebra.leftfetchjoinPath(X_286,X_9,X_220);
- (X_222,r1_258,r2_258) := algebra.subsort(X_221,false,false);
- X_226 := algebra.leftfetchjoin(r1_258,X_221);
- X_227 := sql.bind(X_8,"sys","supplier","s_address",0);
- (X_229,r1_265) := sql.bind(X_8,"sys","supplier","s_address",2);
- X_231 := sql.bind(X_8,"sys","supplier","s_address",1);
- X_232 := sql.delta(X_227,X_229,r1_265,X_231);
- X_233:bat[:oid,:str] := algebra.leftfetchjoinPath(r1_258,X_286,X_9,X_232);
- X_234 := sql.resultSet(2,1,X_226);
- sql.rsColumn(X_234,"sys.supplier","s_name","varchar",25,0,X_226);
- sql.rsColumn(X_234,"sys.supplier","s_address","varchar",40,0,X_233);
- X_241 := io.stdout();
- sql.exportResult(X_241,X_234);
+ X_122:bat[:oid,:int] := algebra.leftfetchjoin(X_286,X_121);
+ X_123:bat[:oid,:wrd] := mal.manifold("mkey","hash",X_122);
+ X_127 := sql.bind(X_8,"sys","lineitem","l_suppkey",0);
+ (X_130,r1_142) := sql.bind(X_8,"sys","lineitem","l_suppkey",2);
+ X_132 := sql.bind(X_8,"sys","lineitem","l_suppkey",1);
+ X_133 := sql.delta(X_127,X_130,r1_142,X_132);
+ X_134:bat[:oid,:int] := algebra.leftfetchjoin(X_286,X_133);
+ X_135:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_123,22,X_134);
+ (X_136,r1_149) := algebra.join(X_98,X_135);
+ X_138 := algebra.leftfetchjoin(X_90,X_63);
+ X_139 := algebra.leftfetchjoin(X_136,X_138);
+ X_140 := algebra.leftfetchjoin(r1_149,X_122);
+ X_141:bat[:oid,:bit] := batcalc.==(X_139,X_140);
+ X_143 := algebra.subselect(X_141,true,true,true,true,false);
+ X_145 := algebra.leftfetchjoin(X_143,X_136);
+ X_146 := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
+ (X_151,r1_167) := sql.bind(X_8,"sys","partsupp","ps_suppkey",2);
+ X_154 := sql.bind(X_8,"sys","partsupp","ps_suppkey",1);
+ X_156 := sql.delta(X_146,X_151,r1_167,X_154);
+ X_157:bat[:oid,:int] := algebra.leftfetchjoin(X_285,X_156);
+ X_158 := algebra.leftfetchjoin(X_145,X_157);
+ X_159 := algebra.leftfetchjoin(X_143,r1_149);
+ X_160 := algebra.leftfetchjoin(X_159,X_134);
+ X_161:bat[:oid,:bit] := batcalc.==(X_158,X_160);
+ X_162 := algebra.subselect(X_161,true,true,true,true,false);
+ X_163 := algebra.leftfetchjoin(X_162,X_145);
+ X_164:bat[:oid,:oid] := batcalc.identity(X_138);
+ X_165 := algebra.leftfetchjoin(X_163,X_164);
+ (X_166,r1_185,r2_185) := group.subgroupdone(X_165);
+ X_287 := algebra.leftfetchjoin(r1_185,X_163);
+ X_182 := sql.bind(X_8,"sys","lineitem","l_quantity",0);
+ (X_187,r1_213) := sql.bind(X_8,"sys","lineitem","l_quantity",2);
+ X_189 := sql.bind(X_8,"sys","lineitem","l_quantity",1);
+ X_190 := sql.delta(X_182,X_187,r1_213,X_189);
+ X_191:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_162,X_159,X_286,X_190);
+ X_192:bat[:oid,:lng] := aggr.subsum(X_191,X_166,r1_185,true,true);
+ X_169 := sql.bind(X_8,"sys","partsupp","ps_availqty",0);
+ (X_171,r1_190) := sql.bind(X_8,"sys","partsupp","ps_availqty",2);
+ X_173 := sql.bind(X_8,"sys","partsupp","ps_availqty",1);
+ X_174 := sql.delta(X_169,X_171,r1_190,X_173);
+ X_175:bat[:oid,:int] := algebra.leftfetchjoinPath(X_287,X_90,X_55,X_174);
+ X_176:bat[:oid,:lng] := batcalc.lng(X_175,19,2);
+ X_179 := calc.lng(1,A1,11,1);
+ X_194:bat[:oid,:lng] := batcalc.lng(X_192,11,1);
+ X_195:bat[:oid,:lng] := batcalc.*(X_179,X_194);
+ X_196:bat[:oid,:bit] := batcalc.>(X_176,X_195);
+ X_197 := algebra.subselect(X_196,true,true,true,true,false);
+ X_199:bat[:oid,:int] := algebra.leftfetchjoinPath(X_197,X_287,X_157);
+ X_200 := bat.mirror(X_199);
+ (X_201,r1_233) := algebra.join(X_199,X_53);
+ X_203 := algebra.tinter(X_200,X_201);
+ X_204 := algebra.leftfetchjoin(X_203,X_199);
+ (X_205,r1_237,r2_237) := group.subgroupdone(X_204);
+ X_208 := algebra.leftfetchjoin(r1_237,X_204);
+ (X_209,r1_241) := algebra.join(X_53,X_208);
+ X_211 := algebra.tinter(X_54,X_209);
+ X_288 := algebra.leftfetchjoin(X_211,X_40);
+ X_212 := sql.bind(X_8,"sys","supplier","s_name",0);
+ (X_217,r1_249) := sql.bind(X_8,"sys","supplier","s_name",2);
+ X_220 := sql.bind(X_8,"sys","supplier","s_name",1);
+ X_222 := sql.delta(X_212,X_217,r1_249,X_220);
+ X_223:bat[:oid,:str] := algebra.leftfetchjoinPath(X_288,X_9,X_222);
+ (X_224,r1_258,r2_258) := algebra.subsort(X_223,false,false);
+ X_228 := algebra.leftfetchjoin(r1_258,X_223);
+ X_229 := sql.bind(X_8,"sys","supplier","s_address",0);
+ (X_231,r1_265) := sql.bind(X_8,"sys","supplier","s_address",2);
+ X_233 := sql.bind(X_8,"sys","supplier","s_address",1);
+ X_234 := sql.delta(X_229,X_231,r1_265,X_233);
+ X_235:bat[:oid,:str] := algebra.leftfetchjoinPath(r1_258,X_288,X_9,X_234);
+ X_236 := sql.resultSet(2,1,X_228);
+ sql.rsColumn(X_236,"sys.supplier","s_name","varchar",25,0,X_228);
+ sql.rsColumn(X_236,"sys.supplier","s_address","varchar",40,0,X_235);
+ X_243 := io.stdout();
+ sql.exportResult(X_243,X_236);
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/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
@@ -85,12 +85,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_38 := sql.delta(X_33,X_35,r1_36,X_37);
X_39:bat[:oid,:int] := algebra.leftfetchjoinPath(X_31,X_22,X_38);
(X_40,r1_42) := algebra.join(X_21,X_39);
- X_282 := algebra.leftfetchjoin(X_40,X_9);
+ X_284 := algebra.leftfetchjoin(X_40,X_9);
X_42 := sql.bind(X_8,"sys","supplier","s_suppkey",0);
(X_47,r1_49) := sql.bind(X_8,"sys","supplier","s_suppkey",2);
X_50 := sql.bind(X_8,"sys","supplier","s_suppkey",1);
X_52 := sql.delta(X_42,X_47,r1_49,X_50);
- X_53:bat[:oid,:int] := algebra.leftfetchjoin(X_282,X_52);
+ X_53:bat[:oid,:int] := algebra.leftfetchjoin(X_284,X_52);
X_54 := bat.mirror(X_53);
X_55:bat[:oid,:oid] := sql.tid(X_8,"sys","partsupp");
X_57 := sql.bind(X_8,"sys","partsupp","ps_partkey",0);
@@ -113,12 +113,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_87:bat[:oid,:int] := algebra.leftfetchjoinPath(X_75,X_65,X_86);
(X_88,r1_94) := algebra.join(X_63,X_87);
X_90 := algebra.tinter(X_64,X_88);
- X_283 := algebra.leftfetchjoin(X_90,X_55);
+ X_285 := algebra.leftfetchjoin(X_90,X_55);
X_91 :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",0);
(X_94,r1_100) :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",2);
X_96 :=
sql.bind_idxbat(X_8,"sys","partsupp","partsupp_ps_partkey_ps_suppkey_pkey",1);
X_97 := sql.delta(X_91,X_94,r1_100,X_96);
- X_98:bat[:oid,:wrd] := algebra.leftfetchjoin(X_283,X_97);
+ X_98:bat[:oid,:wrd] := algebra.leftfetchjoin(X_285,X_97);
X_99:bat[:oid,:oid] := sql.tid(X_8,"sys","lineitem");
X_101 := sql.bind(X_8,"sys","lineitem","l_shipdate",0);
(X_103,r1_110) := sql.bind(X_8,"sys","lineitem","l_shipdate",2);
@@ -127,85 +127,85 @@ function user.s2_1{autoCommit=true}(A0:s
X_107 := algebra.leftfetchjoin(X_99,X_106);
X_108 := mtime.addmonths(A3,A4);
X_109 := algebra.subselect(X_107,A2,X_108,true,false,false);
- X_284 := algebra.leftfetchjoin(X_109,X_99);
+ X_286 := algebra.leftfetchjoin(X_109,X_99);
X_112 := sql.bind(X_8,"sys","lineitem","l_partkey",0);
(X_116,r1_126) := sql.bind(X_8,"sys","lineitem","l_partkey",2);
X_119 := sql.bind(X_8,"sys","lineitem","l_partkey",1);
X_121 := sql.delta(X_112,X_116,r1_126,X_119);
- X_122:bat[:oid,:int] := algebra.leftfetchjoin(X_284,X_121);
- X_123:bat[:oid,:wrd] := batcalc.hash(X_122);
- X_125 := sql.bind(X_8,"sys","lineitem","l_suppkey",0);
- (X_128,r1_142) := sql.bind(X_8,"sys","lineitem","l_suppkey",2);
- X_130 := sql.bind(X_8,"sys","lineitem","l_suppkey",1);
- X_131 := sql.delta(X_125,X_128,r1_142,X_130);
- X_132:bat[:oid,:int] := algebra.leftfetchjoin(X_284,X_131);
- X_133:bat[:oid,:wrd] := mkey.bulk_rotate_xor_hash(X_123,11,X_132);
- (X_134,r1_149) := algebra.join(X_98,X_133);
- X_136 := algebra.leftfetchjoin(X_90,X_63);
- X_137 := algebra.leftfetchjoin(X_134,X_136);
- X_138 := algebra.leftfetchjoin(r1_149,X_122);
- X_139:bat[:oid,:bit] := batcalc.==(X_137,X_138);
- X_141 := algebra.subselect(X_139,true,true,true,true,false);
- X_143 := algebra.leftfetchjoin(X_141,X_134);
- X_144 := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
- (X_149,r1_166) := sql.bind(X_8,"sys","partsupp","ps_suppkey",2);
- X_152 := sql.bind(X_8,"sys","partsupp","ps_suppkey",1);
- X_154 := sql.delta(X_144,X_149,r1_166,X_152);
- X_155:bat[:oid,:int] := algebra.leftfetchjoin(X_283,X_154);
- X_156 := algebra.leftfetchjoin(X_143,X_155);
- X_157 := algebra.leftfetchjoin(X_141,r1_149);
- X_158 := algebra.leftfetchjoin(X_157,X_132);
- X_159:bat[:oid,:bit] := batcalc.==(X_156,X_158);
- X_160 := algebra.subselect(X_159,true,true,true,true,false);
- X_161 := algebra.leftfetchjoin(X_160,X_143);
- X_162:bat[:oid,:oid] := batcalc.identity(X_136);
- X_163 := algebra.leftfetchjoin(X_161,X_162);
- (X_164,r1_185,r2_185) := group.subgroupdone(X_163);
- X_285 := algebra.leftfetchjoin(r1_185,X_161);
- X_180 := sql.bind(X_8,"sys","lineitem","l_quantity",0);
- (X_185,r1_212) := sql.bind(X_8,"sys","lineitem","l_quantity",2);
- X_187 := sql.bind(X_8,"sys","lineitem","l_quantity",1);
- X_188 := sql.delta(X_180,X_185,r1_212,X_187);
- X_189:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_160,X_157,X_284,X_188);
- X_190:bat[:oid,:lng] := aggr.subsum(X_189,X_164,r1_185,true,true);
- X_167 := sql.bind(X_8,"sys","partsupp","ps_availqty",0);
- (X_169,r1_190) := sql.bind(X_8,"sys","partsupp","ps_availqty",2);
- X_171 := sql.bind(X_8,"sys","partsupp","ps_availqty",1);
- X_172 := sql.delta(X_167,X_169,r1_190,X_171);
- X_173:bat[:oid,:int] := algebra.leftfetchjoinPath(X_285,X_90,X_55,X_172);
- X_174:bat[:oid,:lng] := batcalc.lng(X_173,19,2);
- X_177 := calc.lng(1,A1,11,1);
- X_192:bat[:oid,:lng] := batcalc.lng(X_190,11,1);
- X_193:bat[:oid,:lng] := batcalc.*(X_177,X_192);
- X_194:bat[:oid,:bit] := batcalc.>(X_174,X_193);
- X_195 := algebra.subselect(X_194,true,true,true,true,false);
- X_197:bat[:oid,:int] := algebra.leftfetchjoinPath(X_195,X_285,X_155);
- X_198 := bat.mirror(X_197);
- (X_199,r1_233) := algebra.join(X_197,X_53);
- X_201 := algebra.tinter(X_198,X_199);
- X_202 := algebra.leftfetchjoin(X_201,X_197);
- (X_203,r1_237,r2_237) := group.subgroupdone(X_202);
- X_206 := algebra.leftfetchjoin(r1_237,X_202);
- (X_207,r1_241) := algebra.join(X_53,X_206);
- X_209 := algebra.tinter(X_54,X_207);
- X_286 := algebra.leftfetchjoin(X_209,X_40);
- X_210 := sql.bind(X_8,"sys","supplier","s_name",0);
- (X_215,r1_249) := sql.bind(X_8,"sys","supplier","s_name",2);
- X_218 := sql.bind(X_8,"sys","supplier","s_name",1);
- X_220 := sql.delta(X_210,X_215,r1_249,X_218);
- X_221:bat[:oid,:str] := algebra.leftfetchjoinPath(X_286,X_9,X_220);
- (X_222,r1_258,r2_258) := algebra.subsort(X_221,false,false);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
