Changeset: 2ec0be73a273 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2ec0be73a273
Modified Files:
sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit
sql/test/BugTracker-2009/Tests/error_while_drop_func_returns_table_type.SF-2604573.sql
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.stable.out.32bit
Branch: int128
Log Message:
Merge with default branch.
diffs (truncated from 361 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
@@ -56,84 +56,85 @@ function user.s2_1{autoCommit=true}(A0:b
X_11 := 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_180 := algebra.thetasubselect(X_11,X_8,X_19,"<=");
+ X_183 := algebra.thetasubselect(X_11,X_8,X_19,"<=");
(X_14,r1_14) := sql.bind(X_7,"sys","lineitem","l_shipdate",2);
- X_181 := algebra.thetasubselect(r1_14,X_19,"<=");
+ X_184 := algebra.thetasubselect(r1_14,X_19,"<=");
X_17 := sql.bind(X_7,"sys","lineitem","l_shipdate",1);
- X_182 := algebra.thetasubselect(X_17,X_8,X_19,"<=");
- X_20 := sql.subdelta(X_180,X_8,X_14,X_181,X_182);
- X_28 := sql.bind(X_7,"sys","lineitem","l_linestatus",0);
- (X_30,r1_36) := sql.bind(X_7,"sys","lineitem","l_linestatus",2);
- X_32 := sql.bind(X_7,"sys","lineitem","l_linestatus",1);
+ X_185 := algebra.thetasubselect(X_17,X_8,X_19,"<=");
+ X_20 := sql.subdelta(X_183,X_8,X_14,X_184,X_185);
+ X_22 := sql.bind(X_7,"sys","lineitem","l_linestatus",0);
+ (X_24,r1_28) := sql.bind(X_7,"sys","lineitem","l_linestatus",2);
+ X_26 := sql.bind(X_7,"sys","lineitem","l_linestatus",1);
+ X_27 := sql.projectdelta(X_20,X_22,X_24,r1_28,X_26);
+ X_28 := sql.bind(X_7,"sys","lineitem","l_returnflag",0);
+ (X_30,r1_36) := sql.bind(X_7,"sys","lineitem","l_returnflag",2);
+ X_32 := sql.bind(X_7,"sys","lineitem","l_returnflag",1);
X_33 := sql.projectdelta(X_20,X_28,X_30,r1_36,X_32);
- X_22 := sql.bind(X_7,"sys","lineitem","l_returnflag",0);
- (X_24,r1_28) := sql.bind(X_7,"sys","lineitem","l_returnflag",2);
- X_26 := sql.bind(X_7,"sys","lineitem","l_returnflag",1);
- X_27 := sql.projectdelta(X_20,X_22,X_24,r1_28,X_26);
- (X_34,r1_45,r2_45) := group.subgroup(X_33,X_27);
- X_37 := algebra.leftfetchjoin(r1_45,X_33);
- X_38 := algebra.leftfetchjoin(r1_45,X_27);
- X_48 := sql.bind(X_7,"sys","lineitem","l_quantity",0);
- (X_53,r1_64) := sql.bind(X_7,"sys","lineitem","l_quantity",2);
- X_56 := sql.bind(X_7,"sys","lineitem","l_quantity",1);
- X_58 := sql.projectdelta(X_20,X_48,X_53,r1_64,X_56);
- X_59:bat[:oid,:lng] := aggr.subsum(X_58,X_34,r1_45,true,true);
- X_62 := sql.bind(X_7,"sys","lineitem","l_extendedprice",0);
- (X_64,r1_77) := sql.bind(X_7,"sys","lineitem","l_extendedprice",2);
- X_66 := sql.bind(X_7,"sys","lineitem","l_extendedprice",1);
- X_67 := sql.projectdelta(X_20,X_62,X_64,r1_77,X_66);
- X_68:bat[:oid,:lng] := aggr.subsum(X_67,X_34,r1_45,true,true);
- X_70 := calc.lng(A0,15,2);
- X_72 := sql.bind(X_7,"sys","lineitem","l_discount",0);
- (X_74,r1_90) := sql.bind(X_7,"sys","lineitem","l_discount",2);
- X_76 := sql.bind(X_7,"sys","lineitem","l_discount",1);
- X_79 := sql.projectdelta(X_20,X_72,X_74,r1_90,X_76);
- X_80:bat[:oid,:lng] := batcalc.-(X_70,X_79);
- X_81:bat[:oid,:lng] := batcalc.*(X_67,X_80);
- X_82:bat[:oid,:lng] := aggr.subsum(X_81,X_34,r1_45,true,true);
- X_84 := calc.lng(A1,15,2);
- X_86:bat[:oid,:lng] := batcalc.-(X_84,X_79);
- X_87:bat[:oid,:lng] := batcalc.*(X_67,X_86);
- X_88 := calc.lng(A2,15,2);
- X_89 := sql.bind(X_7,"sys","lineitem","l_tax",0);
- (X_92,r1_115) := sql.bind(X_7,"sys","lineitem","l_tax",2);
- X_94 := sql.bind(X_7,"sys","lineitem","l_tax",1);
- X_96 := sql.projectdelta(X_20,X_89,X_92,r1_115,X_94);
- X_97:bat[:oid,:lng] := batcalc.+(X_88,X_96);
- X_98:bat[:oid,:lng] := batcalc.*(X_87,X_97);
- X_99:bat[:oid,:lng] := aggr.subsum(X_98,X_34,r1_45,true,true);
- X_102 := batcalc.dbl(X_58);
- X_103:bat[:oid,:dbl] := aggr.subavg(X_102,X_34,r1_45,true,true);
- X_105:bat[:oid,:dbl] := batcalc.dbl(2,X_67);
- X_106:bat[:oid,:dbl] := aggr.subavg(X_105,X_34,r1_45,true,true);
- X_108:bat[:oid,:dbl] := batcalc.dbl(2,X_79);
- X_109:bat[:oid,:dbl] := aggr.subavg(X_108,X_34,r1_45,true,true);
- X_111:bat[:oid,:wrd] := aggr.subcount(X_34,X_34,r1_45,false);
- (X_39,r1_50,r2_50) := algebra.subsort(X_38,false,false);
- (X_43,r1_54,r2_54) := algebra.subsort(X_37,r1_50,r2_50,false,false);
- X_46 := algebra.leftfetchjoin(r1_54,X_38);
- X_113 := algebra.leftfetchjoin(r1_54,X_111);
+ (X_34,r1_42,r2_42) := group.subgroup(X_33);
+ (X_37,r1_45,r2_45) := group.subgroupdone(X_27,X_34);
+ X_40 := algebra.leftfetchjoin(r1_45,X_27);
+ X_41 := algebra.leftfetchjoin(r1_45,X_33);
+ X_51 := sql.bind(X_7,"sys","lineitem","l_quantity",0);
+ (X_56,r1_64) := sql.bind(X_7,"sys","lineitem","l_quantity",2);
+ X_59 := sql.bind(X_7,"sys","lineitem","l_quantity",1);
+ X_61 := sql.projectdelta(X_20,X_51,X_56,r1_64,X_59);
+ X_62:bat[:oid,:lng] := aggr.subsum(X_61,X_37,r1_45,true,true);
+ X_65 := sql.bind(X_7,"sys","lineitem","l_extendedprice",0);
+ (X_67,r1_77) := sql.bind(X_7,"sys","lineitem","l_extendedprice",2);
+ X_69 := sql.bind(X_7,"sys","lineitem","l_extendedprice",1);
+ X_70 := sql.projectdelta(X_20,X_65,X_67,r1_77,X_69);
+ X_71:bat[:oid,:lng] := aggr.subsum(X_70,X_37,r1_45,true,true);
+ X_73 := calc.lng(A0,15,2);
+ X_75 := sql.bind(X_7,"sys","lineitem","l_discount",0);
+ (X_77,r1_90) := sql.bind(X_7,"sys","lineitem","l_discount",2);
+ X_79 := sql.bind(X_7,"sys","lineitem","l_discount",1);
+ X_82 := sql.projectdelta(X_20,X_75,X_77,r1_90,X_79);
+ X_83:bat[:oid,:lng] := batcalc.-(X_73,X_82);
+ X_84:bat[:oid,:lng] := batcalc.*(X_70,X_83);
+ X_85:bat[:oid,:lng] := aggr.subsum(X_84,X_37,r1_45,true,true);
+ X_87 := calc.lng(A1,15,2);
+ X_89:bat[:oid,:lng] := batcalc.-(X_87,X_82);
+ X_90:bat[:oid,:lng] := batcalc.*(X_70,X_89);
+ X_91 := calc.lng(A2,15,2);
+ X_92 := sql.bind(X_7,"sys","lineitem","l_tax",0);
+ (X_95,r1_115) := sql.bind(X_7,"sys","lineitem","l_tax",2);
+ X_97 := sql.bind(X_7,"sys","lineitem","l_tax",1);
+ X_99 := sql.projectdelta(X_20,X_92,X_95,r1_115,X_97);
+ X_100:bat[:oid,:lng] := batcalc.+(X_91,X_99);
+ X_101:bat[:oid,:lng] := batcalc.*(X_90,X_100);
+ X_102:bat[:oid,:lng] := aggr.subsum(X_101,X_37,r1_45,true,true);
+ X_105 := batcalc.dbl(X_61);
+ X_106:bat[:oid,:dbl] := aggr.subavg(X_105,X_37,r1_45,true,true);
+ X_108:bat[:oid,:dbl] := batcalc.dbl(2,X_70);
+ X_109:bat[:oid,:dbl] := aggr.subavg(X_108,X_37,r1_45,true,true);
+ X_111:bat[:oid,:dbl] := batcalc.dbl(2,X_82);
+ X_112:bat[:oid,:dbl] := aggr.subavg(X_111,X_37,r1_45,true,true);
+ X_114:bat[:oid,:wrd] := aggr.subcount(X_37,X_37,r1_45,false);
+ (X_42,r1_50,r2_50) := algebra.subsort(X_41,false,false);
+ (X_46,r1_54,r2_54) := algebra.subsort(X_40,r1_50,r2_50,false,false);
+ X_49 := algebra.leftfetchjoin(r1_54,X_41);
+ X_116 := algebra.leftfetchjoin(r1_54,X_114);
+ X_113 := algebra.leftfetchjoin(r1_54,X_112);
X_110 := algebra.leftfetchjoin(r1_54,X_109);
X_107 := algebra.leftfetchjoin(r1_54,X_106);
- X_104 := algebra.leftfetchjoin(r1_54,X_103);
- X_101 := algebra.leftfetchjoin(r1_54,X_99);
- X_83 := algebra.leftfetchjoin(r1_54,X_82);
- X_69 := algebra.leftfetchjoin(r1_54,X_68);
- X_61 := algebra.leftfetchjoin(r1_54,X_59);
- X_47 := algebra.leftfetchjoin(r1_54,X_37);
- X_114 := sql.resultSet(10,1,X_46);
- sql.rsColumn(X_114,"sys.lineitem","l_returnflag","varchar",1,0,X_46);
- sql.rsColumn(X_114,"sys.lineitem","l_linestatus","varchar",1,0,X_47);
- sql.rsColumn(X_114,"sys.L1","sum_qty","bigint",32,0,X_61);
- sql.rsColumn(X_114,"sys.L2","sum_base_price","decimal",15,2,X_69);
- sql.rsColumn(X_114,"sys.L3","sum_disc_price","decimal",19,4,X_83);
- sql.rsColumn(X_114,"sys.L4","sum_charge","decimal",19,6,X_101);
- sql.rsColumn(X_114,"sys.L5","avg_qty","double",53,0,X_104);
- sql.rsColumn(X_114,"sys.L6","avg_price","double",53,0,X_107);
- sql.rsColumn(X_114,"sys.L7","avg_disc","double",53,0,X_110);
- sql.rsColumn(X_114,"sys.L10","count_order","wrd",32,0,X_113);
- X_160 := io.stdout();
- sql.exportResult(X_160,X_114);
+ X_104 := algebra.leftfetchjoin(r1_54,X_102);
+ X_86 := algebra.leftfetchjoin(r1_54,X_85);
+ X_72 := algebra.leftfetchjoin(r1_54,X_71);
+ X_64 := algebra.leftfetchjoin(r1_54,X_62);
+ X_50 := algebra.leftfetchjoin(r1_54,X_40);
+ X_117 := sql.resultSet(10,1,X_49);
+ sql.rsColumn(X_117,"sys.lineitem","l_returnflag","varchar",1,0,X_49);
+ sql.rsColumn(X_117,"sys.lineitem","l_linestatus","varchar",1,0,X_50);
+ sql.rsColumn(X_117,"sys.L1","sum_qty","bigint",32,0,X_64);
+ sql.rsColumn(X_117,"sys.L2","sum_base_price","decimal",15,2,X_72);
+ sql.rsColumn(X_117,"sys.L3","sum_disc_price","decimal",19,4,X_86);
+ sql.rsColumn(X_117,"sys.L4","sum_charge","decimal",19,6,X_104);
+ sql.rsColumn(X_117,"sys.L5","avg_qty","double",53,0,X_107);
+ sql.rsColumn(X_117,"sys.L6","avg_price","double",53,0,X_110);
+ sql.rsColumn(X_117,"sys.L7","avg_disc","double",53,0,X_113);
+ sql.rsColumn(X_117,"sys.L10","count_order","wrd",32,0,X_116);
+ X_163 := io.stdout();
+ sql.exportResult(X_163,X_117);
end s2_1;
# 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")
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
@@ -76,12 +76,12 @@ function user.s2_1{autoCommit=true}(A0:s
X_24 := algebra.leftfetchjoin(X_5,X_23);
X_25:bat[:oid,:bit] := batcalc.>(X_17,X_24);
X_26 := algebra.subselect(X_25,true,true,true,true,false);
- X_246 := algebra.leftfetchjoin(X_26,X_5);
+ X_252 := algebra.leftfetchjoin(X_26,X_5);
X_28 := 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_33 := sql.delta(X_28,X_30,r1_32,X_32);
- X_34:bat[:oid,:oid] := algebra.leftfetchjoin(X_246,X_33);
+ X_34:bat[:oid,:oid] := algebra.leftfetchjoin(X_252,X_33);
X_35:bat[:oid,:oid] := sql.tid(X_4,"sys","orders");
X_38 := sql.bind(X_4,"sys","orders","o_orderstatus",0);
(X_41,r1_44) := sql.bind(X_4,"sys","orders","o_orderstatus",2);
@@ -91,20 +91,20 @@ function user.s2_1{autoCommit=true}(A0:s
X_48 := algebra.subselect(X_47,A0,A0,true,true,false);
X_50 := algebra.leftfetchjoin(X_48,X_35);
(X_51,r1_55) := algebra.join(X_34,X_50);
- X_247 := algebra.leftfetchjoin(X_51,X_26);
+ X_253 := algebra.leftfetchjoin(X_51,X_26);
X_53 := 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_59 := sql.delta(X_53,X_56,r1_60,X_58);
- X_60:bat[:oid,:oid] := algebra.leftfetchjoinPath(X_247,X_5,X_59);
+ X_60:bat[:oid,:oid] := algebra.leftfetchjoinPath(X_253,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_248 := algebra.leftfetchjoin(r1_69,X_61);
+ X_254 := algebra.leftfetchjoin(r1_69,X_61);
X_65 :=
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_71 := sql.delta(X_65,X_68,r1_74,X_70);
- X_72:bat[:oid,:oid] := algebra.leftfetchjoin(X_248,X_71);
+ X_72:bat[:oid,:oid] := algebra.leftfetchjoin(X_254,X_71);
X_73:bat[:oid,:oid] := sql.tid(X_4,"sys","nation");
X_75 := sql.bind(X_4,"sys","nation","n_name",0);
(X_78,r1_85) := sql.bind(X_4,"sys","nation","n_name",2);
@@ -114,19 +114,19 @@ function user.s2_1{autoCommit=true}(A0:s
X_85 := algebra.subselect(X_84,A1,A1,true,true,false);
X_88 := algebra.leftfetchjoin(X_85,X_73);
(X_89,r1_97) := algebra.join(X_72,X_88);
- X_249 := algebra.leftfetchjoin(X_89,r1_69);
+ X_255 := algebra.leftfetchjoin(X_89,r1_69);
X_91 := sql.bind(X_4,"sys","supplier","s_suppkey",0);
(X_93,r1_101) := sql.bind(X_4,"sys","supplier","s_suppkey",2);
X_96 := sql.bind(X_4,"sys","supplier","s_suppkey",1);
X_98 := sql.delta(X_91,X_93,r1_101,X_96);
- X_99:bat[:oid,:int] := algebra.leftfetchjoinPath(X_249,X_61,X_98);
+ X_99:bat[:oid,:int] := algebra.leftfetchjoinPath(X_255,X_61,X_98);
X_100 := bat.mirror(X_99);
- X_250 := algebra.leftfetchjoin(X_89,X_63);
+ X_256 := algebra.leftfetchjoin(X_89,X_63);
X_101 := sql.bind(X_4,"sys","lineitem","l_orderkey",0);
(X_104,r1_114) := sql.bind(X_4,"sys","lineitem","l_orderkey",2);
X_106 := sql.bind(X_4,"sys","lineitem","l_orderkey",1);
X_107 := sql.delta(X_101,X_104,r1_114,X_106);
- X_108:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_250,X_51,X_26,X_5,X_107);
+ X_108:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_256,X_51,X_26,X_5,X_107);
X_109:bat[:oid,:oid] := sql.tid(X_4,"sys","lineitem");
X_113 := algebra.leftfetchjoin(X_109,X_107);
(X_114,r1_133) := algebra.join(X_108,X_113);
@@ -136,7 +136,7 @@ function user.s2_1{autoCommit=true}(A0:s
X_122 := sql.delta(X_116,X_118,r1_137,X_121);
X_123 := algebra.leftfetchjoin(X_109,X_122);
X_124 := algebra.leftfetchjoin(r1_133,X_123);
- X_126:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_250,X_51,X_26,X_5,X_122);
+ X_126:bat[:oid,:int] :=
algebra.leftfetchjoinPath(X_256,X_51,X_26,X_5,X_122);
X_127 := algebra.leftfetchjoin(X_114,X_126);
X_128:bat[:oid,:bit] := batcalc.!=(X_124,X_127);
X_129 := algebra.subselect(X_128,true,true,true,true,false);
@@ -165,30 +165,30 @@ function user.s2_1{autoCommit=true}(A0:s
X_164 := algebra.subselect(X_163,true,true,true,true,false);
X_167 := algebra.leftfetchjoin(X_164,X_159);
X_168 := algebra.tdiff(X_135,X_167);
- X_251 := algebra.leftfetchjoin(X_133,X_89);
+ X_257 := algebra.leftfetchjoin(X_133,X_89);
X_169 := sql.bind(X_4,"sys","supplier","s_name",0);
(X_174,r1_224) := sql.bind(X_4,"sys","supplier","s_name",2);
X_177 := sql.bind(X_4,"sys","supplier","s_name",1);
X_179 := sql.delta(X_169,X_174,r1_224,X_177);
- X_180:bat[:oid,:str] :=
algebra.leftfetchjoinPath(X_168,X_251,r1_69,X_61,X_179);
+ X_180:bat[:oid,:str] :=
algebra.leftfetchjoinPath(X_168,X_257,r1_69,X_61,X_179);
(X_181,r1_235,r2_235) := group.subgroupdone(X_180);
- X_184:bat[:oid,:wrd] := aggr.subcount(X_181,X_181,r1_235,false);
- X_188 := algebra.leftfetchjoin(r1_235,X_180);
- X_186 := pqueue.utopn_min(X_184,100:wrd);
- X_187 := bat.mirror(X_186);
- X_189 := algebra.leftjoin(X_187,X_188);
- X_190 := pqueue.topn_max(X_186,X_189,100:wrd);
- X_192 := algebra.markT(X_190,0@0);
- X_193 := bat.reverse(X_192);
- X_194 := algebra.leftfetchjoin(X_193,X_188);
- X_195 := algebra.subslice(X_194,0:wrd,99:wrd);
- X_196 := algebra.leftfetchjoin(X_195,X_194);
- X_197:bat[:oid,:wrd] := algebra.leftfetchjoinPath(X_195,X_193,X_184);
- X_198 := sql.resultSet(2,1,X_196);
- sql.rsColumn(X_198,"sys.supplier","s_name","varchar",25,0,X_196);
- sql.rsColumn(X_198,"sys.L1","numwait","wrd",32,0,X_197);
- X_212 := io.stdout();
- sql.exportResult(X_212,X_198);
+ r1_249 := algebra.leftfetchjoin(r1_235,X_180);
+ X_185:bat[:oid,:wrd] := aggr.subcount(X_181,X_181,r1_235,false);
+ (X_187,r1_245) := pqueue.topn_min(X_185,100:wrd);
+ X_189 := pqueue.topn_max(r1_249,X_187,r1_245,100:wrd);
+ X_190 := algebra.leftfetchjoin(X_189,r1_249);
+ X_191 := algebra.leftfetchjoin(X_189,X_185);
+ (X_192,r1_252,r2_252) := algebra.subsort(X_191,true,false);
+ (X_197,r1_257,r2_257) := algebra.subsort(X_190,r1_252,r2_252,false,false);
+ X_200 := algebra.leftfetchjoin(r1_257,X_190);
+ X_202 := algebra.subslice(X_200,0:wrd,99:wrd);
+ X_203 := algebra.leftfetchjoin(X_202,X_200);
+ X_204:bat[:oid,:wrd] := algebra.leftfetchjoinPath(X_202,r1_257,X_191);
+ X_205 := sql.resultSet(2,1,X_203);
+ sql.rsColumn(X_205,"sys.supplier","s_name","varchar",25,0,X_203);
+ sql.rsColumn(X_205,"sys.L1","numwait","wrd",32,0,X_204);
+ X_218 := io.stdout();
+ sql.exportResult(X_218,X_205);
end s2_1;
# querylog.define("explain select\n\ts_name,\n\tcount(*) as
numwait\nfrom\n\tsupplier,\n\tlineitem
l1,\n\torders,\n\tnation\nwhere\n\ts_suppkey = l1.l_suppkey\n\tand o_orderkey =
l1.l_orderkey\n\tand o_orderstatus = \\'F\\'\n\tand l1.l_receiptdate >
l1.l_commitdate\n\tand exists (\n\t\tselect\n\t\t\t*\n\t\tfrom\n\t\t\tlineitem
l2\n\t\twhere\n\t\t\tl2.l_orderkey = l1.l_orderkey\n\t\t\tand l2.l_suppkey <>
l1.l_suppkey\n\t)\n\tand not exists
(\n\t\tselect\n\t\t\t*\n\t\tfrom\n\t\t\tlineitem
l3\n\t\twhere\n\t\t\tl3.l_orderkey = l1.l_orderkey\n\t\t\tand l3.l_suppkey <>
l1.l_suppkey\n\t\t\tand l3.l_receiptdate > l3.l_commitdate\n\t)\n\tand
s_nationkey = n_nationkey\n\tand n_name = \\'SAUDI ARABIA\\'\ngroup
by\n\ts_name\norder by\n\tnumwait desc,\n\ts_name\nlimit
100;","sequential_pipe")
diff --git
a/sql/test/BugTracker-2009/Tests/error_while_drop_func_returns_table_type.SF-2604573.sql
b/sql/test/BugTracker-2009/Tests/error_while_drop_func_returns_table_type.SF-2604573.sql
---
a/sql/test/BugTracker-2009/Tests/error_while_drop_func_returns_table_type.SF-2604573.sql
+++
b/sql/test/BugTracker-2009/Tests/error_while_drop_func_returns_table_type.SF-2604573.sql
@@ -1,3 +1,5 @@
+start transaction;
+
create function test_002() returns table(i int)
begin
declare table tbl(i int);
diff --git
a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
---
a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
+++
b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
