Changeset: eddfef69195a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eddfef69195a
Modified Files:
sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
Branch: default
Log Message:
Merge with Jan2014 branch.
diffs (75 lines):
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
@@ -123,36 +123,41 @@ function user.s2_1{autoCommit=true}(A0:s
X_105:bat[:oid,:int] := algebra.leftfetchjoinPath(X_97,X_87,X_104);
(X_106,r1_121) := algebra.join(X_85,X_105);
X_108 := algebra.tdiff(X_86,X_106);
- X_195 := algebra.leftfetchjoin(X_108,r1_83);
- X_109:bat[:oid,:str] := algebra.leftfetchjoinPath(X_195,X_70,X_42);
- X_110:bat[:oid,:str] := algebra.leftfetchjoinPath(X_195,X_70,X_51);
- X_111:bat[:oid,:int] := algebra.leftfetchjoinPath(X_195,X_70,X_35);
- (X_112,r1_133,r2_133) := group.subgroup(X_111);
- (X_115,r1_136,r2_136) := group.subgroup(X_110,X_112);
- (X_118,r1_139,r2_139) := group.subgroupdone(X_109,X_115);
- X_121 := algebra.leftfetchjoin(r1_139,X_111);
- X_122 := algebra.leftfetchjoin(r1_139,X_109);
- X_123 := algebra.leftfetchjoin(r1_139,X_110);
- X_124 := algebra.leftfetchjoin(X_108,X_85);
- (X_125,r1_146,r2_146) := group.subgroupdone(X_124,X_118);
- X_128 := algebra.leftfetchjoin(r1_146,X_124);
- X_129 := algebra.leftfetchjoin(r1_146,X_118);
- X_130:bat[:oid,:wrd] := aggr.subcount(X_128,X_129,r1_139,true);
- (X_132,r1_153,r2_153) := algebra.subsort(X_130,true,false);
- (X_136,r1_157,r2_157) := algebra.subsort(X_123,r1_153,r2_153,false,false);
- (X_139,r1_160,r2_160) := algebra.subsort(X_122,r1_157,r2_157,false,false);
- (X_142,r1_163,r2_163) := algebra.subsort(X_121,r1_160,r2_160,false,false);
- X_145 := algebra.leftfetchjoin(r1_163,X_123);
- X_148 := algebra.leftfetchjoin(r1_163,X_130);
- X_147 := algebra.leftfetchjoin(r1_163,X_121);
- X_146 := algebra.leftfetchjoin(r1_163,X_122);
- X_149 := sql.resultSet(4,1,X_145);
- sql.rsColumn(X_149,"sys.part","p_brand","varchar",10,0,X_145);
- sql.rsColumn(X_149,"sys.part","p_type","varchar",25,0,X_146);
- sql.rsColumn(X_149,"sys.part","p_size","int",32,0,X_147);
- sql.rsColumn(X_149,"sys.L4","supplier_cnt","wrd",32,0,X_148);
- X_169 := io.stdout();
- sql.exportResult(X_169,X_149);
+ X_206 := algebra.leftfetchjoin(X_108,r1_83);
+ X_109:bat[:oid,:str] := algebra.leftfetchjoinPath(X_206,X_70,X_42);
+ X_110:bat[:oid,:str] := algebra.leftfetchjoinPath(X_206,X_70,X_51);
+ X_111:bat[:oid,:int] := algebra.leftfetchjoinPath(X_206,X_70,X_35);
+ X_112 := algebra.leftfetchjoin(X_108,X_85);
+ (X_113,r1_134,r2_134) := group.subgroup(X_112);
+ (X_116,r1_137,r2_137) := group.subgroup(X_111,X_113);
+ (X_119,r1_140,r2_140) := group.subgroup(X_110,X_116);
+ (X_122,r1_143,r2_143) := group.subgroupdone(X_109,X_119);
+ X_125 := algebra.leftfetchjoin(r1_143,X_109);
+ X_126 := algebra.leftfetchjoin(r1_143,X_110);
+ X_127 := algebra.leftfetchjoin(r1_143,X_111);
+ X_140 := algebra.leftfetchjoin(r1_143,X_112);
+ (X_128,r1_149,r2_149) := group.subgroup(X_127);
+ (X_131,r1_152,r2_152) := group.subgroup(X_126,X_128);
+ (X_134,r1_155,r2_155) := group.subgroupdone(X_125,X_131);
+ X_137 := algebra.leftfetchjoin(r1_155,X_127);
+ X_138 := algebra.leftfetchjoin(r1_155,X_125);
+ X_139 := algebra.leftfetchjoin(r1_155,X_126);
+ X_141:bat[:oid,:wrd] := aggr.subcount(X_140,X_134,r1_155,true);
+ (X_143,r1_164,r2_164) := algebra.subsort(X_141,true,false);
+ (X_147,r1_168,r2_168) := algebra.subsort(X_139,r1_164,r2_164,false,false);
+ (X_150,r1_171,r2_171) := algebra.subsort(X_138,r1_168,r2_168,false,false);
+ (X_153,r1_174,r2_174) := algebra.subsort(X_137,r1_171,r2_171,false,false);
+ X_156 := algebra.leftfetchjoin(r1_174,X_139);
+ X_159 := algebra.leftfetchjoin(r1_174,X_141);
+ X_158 := algebra.leftfetchjoin(r1_174,X_137);
+ X_157 := algebra.leftfetchjoin(r1_174,X_138);
+ X_160 := sql.resultSet(4,1,X_156);
+ sql.rsColumn(X_160,"sys.part","p_brand","varchar",10,0,X_156);
+ sql.rsColumn(X_160,"sys.part","p_type","varchar",25,0,X_157);
+ sql.rsColumn(X_160,"sys.part","p_size","int",32,0,X_158);
+ sql.rsColumn(X_160,"sys.L4","supplier_cnt","wrd",32,0,X_159);
+ X_180 := io.stdout();
+ sql.exportResult(X_180,X_160);
end s2_1;
# 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")
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
