Changeset: 269ebc371345 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=269ebc371345
Modified Files:
sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
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
sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit
Branch: default
Log Message:
approve 32-bit output
diffs (truncated from 832 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
@@ -50,30 +50,30 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 78 # length
-function user.s0_1{autoCommit=true}(A0:bte,A1:bte,A2:bte,A3:date,A4:lng):void;
+% 602 # length
+function user.s2_1{autoCommit=true}(A0:bte,A1:bte,A2:bte,A3:date,A4:lng):void;
X_7 := sql.mvc();
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_199 := 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_200 := 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_201 := algebra.thetasubselect(X_17,X_8,X_19,"<=");
- X_20 := sql.subdelta(X_199,X_8,X_14,X_200,X_201);
- 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_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_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_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_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_33 := sql.projectdelta(X_20,X_28,X_30,r1_36,X_32);
(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_40 := algebra.leftfetchjoin(r1_45,X_33);
+ X_41 := algebra.leftfetchjoin(r1_45,X_27);
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);
@@ -104,53 +104,39 @@ function user.s0_1{autoCommit=true}(A0:b
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.subsum(X_105,X_37,r1_45,true,true);
- X_107:bat[:oid,:wrd] := aggr.subcount(X_105,X_37,r1_45,true);
- X_115:bat[:oid,:dbl] := batcalc.dbl(2,X_70);
- X_117:bat[:oid,:dbl] := aggr.subsum(X_115,X_37,r1_45,true,true);
- X_118:bat[:oid,:wrd] := aggr.subcount(X_115,X_37,r1_45,true);
- X_124:bat[:oid,:dbl] := batcalc.dbl(2,X_82);
- X_125:bat[:oid,:dbl] := aggr.subsum(X_124,X_37,r1_45,true,true);
- X_127:bat[:oid,:wrd] := aggr.subcount(X_124,X_37,r1_45,true);
- X_133:bat[:oid,:wrd] := aggr.subcount(X_37,X_37,r1_45,false);
+ 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_135 := algebra.leftfetchjoin(r1_54,X_133);
- X_128:bat[:oid,:bit] := batcalc.==(X_127,0:wrd);
- X_129 := batcalc.dbl(X_127);
- X_130:bat[:oid,:dbl] := batcalc.ifthenelse(X_128,nil:dbl,X_129);
- X_131:bat[:oid,:dbl] := batcalc./(X_125,X_130);
- X_132 := algebra.leftfetchjoin(r1_54,X_131);
- X_119:bat[:oid,:bit] := batcalc.==(X_118,0:wrd);
- X_120 := batcalc.dbl(X_118);
- X_121:bat[:oid,:dbl] := batcalc.ifthenelse(X_119,nil:dbl,X_120);
- X_122:bat[:oid,:dbl] := batcalc./(X_117,X_121);
- X_123 := algebra.leftfetchjoin(r1_54,X_122);
- X_109:bat[:oid,:bit] := batcalc.==(X_107,0:wrd);
- X_111 := batcalc.dbl(X_107);
- X_112:bat[:oid,:dbl] := batcalc.ifthenelse(X_109,nil:dbl,X_111);
- X_113:bat[:oid,:dbl] := batcalc./(X_106,X_112);
- X_114 := algebra.leftfetchjoin(r1_54,X_113);
+ 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_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_136 := sql.resultSet(10,1,X_49);
- sql.rsColumn(X_136,"sys.lineitem","l_returnflag","varchar",1,0,X_49);
- sql.rsColumn(X_136,"sys.lineitem","l_linestatus","varchar",1,0,X_50);
- sql.rsColumn(X_136,"sys.L1","sum_qty","bigint",32,0,X_64);
- sql.rsColumn(X_136,"sys.L2","sum_base_price","decimal",15,2,X_72);
- sql.rsColumn(X_136,"sys.L3","sum_disc_price","decimal",18,4,X_86);
- sql.rsColumn(X_136,"sys.L4","sum_charge","decimal",18,6,X_104);
- sql.rsColumn(X_136,"sys.L5","avg_qty","double",53,0,X_114);
- sql.rsColumn(X_136,"sys.L6","avg_price","double",53,0,X_123);
- sql.rsColumn(X_136,"sys.L7","avg_disc","double",53,0,X_132);
- sql.rsColumn(X_136,"sys.L10","count_order","wrd",32,0,X_135);
- X_182 := io.stdout();
- sql.exportResult(X_182,X_136);
-end s0_1;
+ 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",18,4,X_86);
+ sql.rsColumn(X_117,"sys.L4","sum_charge","decimal",18,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")
# 22:53:25 >
# 22:53:25 > "Done."
diff --git a/sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
b/sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
--- a/sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
+++ b/sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit
@@ -50,8 +50,8 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 74 # length
-function user.s0_1{autoCommit=true}(A0:date,A1:date,A2:int):void;
+% 440 # length
+function user.s2_1{autoCommit=true}(A0:date,A1:date,A2:int):void;
X_5 := sql.mvc();
X_6:bat[:oid,:oid] := sql.tid(X_5,"sys","orders");
X_9 := sql.bind(X_5,"sys","orders","o_orderdate",0);
@@ -61,12 +61,12 @@ function user.s0_1{autoCommit=true}(A0:d
X_18 := algebra.leftfetchjoin(X_6,X_17);
X_19 := mtime.addmonths(A1,A2);
X_20 := algebra.subselect(X_18,A0,X_19,true,false,false);
- X_115 := algebra.leftfetchjoin(X_20,X_6);
+ X_118 := algebra.leftfetchjoin(X_20,X_6);
X_22 := sql.bind(X_5,"sys","orders","o_orderkey",0);
(X_24,r1_27) := sql.bind(X_5,"sys","orders","o_orderkey",2);
X_26 := sql.bind(X_5,"sys","orders","o_orderkey",1);
X_27 := sql.delta(X_22,X_24,r1_27,X_26);
- X_28:bat[:oid,:int] := algebra.leftfetchjoin(X_115,X_27);
+ X_28:bat[:oid,:int] := algebra.leftfetchjoin(X_118,X_27);
X_29 := bat.mirror(X_28);
X_30:bat[:oid,:oid] := sql.tid(X_5,"sys","lineitem");
X_32 := sql.bind(X_5,"sys","lineitem","l_commitdate",0);
@@ -92,7 +92,7 @@ function user.s0_1{autoCommit=true}(A0:d
(X_67,r1_74) := sql.bind(X_5,"sys","orders","o_orderpriority",2);
X_70 := sql.bind(X_5,"sys","orders","o_orderpriority",1);
X_71 := sql.delta(X_64,X_67,r1_74,X_70);
- X_72:bat[:oid,:str] := algebra.leftfetchjoinPath(X_63,X_115,X_71);
+ X_72:bat[:oid,:str] := algebra.leftfetchjoinPath(X_63,X_118,X_71);
(X_73,r1_82,r2_82) := group.subgroupdone(X_72);
X_76 := algebra.leftfetchjoin(r1_82,X_72);
X_81:bat[:oid,:wrd] := aggr.subcount(X_73,X_73,r1_82,false);
@@ -104,7 +104,8 @@ function user.s0_1{autoCommit=true}(A0:d
sql.rsColumn(X_83,"sys.L1","order_count","wrd",32,0,X_82);
X_96 := io.stdout();
sql.exportResult(X_96,X_83);
-end s0_1;
+end s2_1;
+# querylog.define("explain select\n\to_orderpriority,\n\tcount(*) as
order_count\nfrom\n\torders\nwhere\n\to_orderdate >= date
\\'1993-07-01\\'\n\tand o_orderdate < date \\'1993-07-01\\' + interval \\'3\\'
month\n\tand exists
(\n\t\tselect\n\t\t\t*\n\t\tfrom\n\t\t\tlineitem\n\t\twhere\n\t\t\tl_orderkey =
o_orderkey\n\t\t\tand l_commitdate < l_receiptdate\n\t)\ngroup
by\n\to_orderpriority\norder by\n\to_orderpriority;","sequential_pipe")
# 22:53:26 >
# 22:53:26 > "Done."
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
@@ -49,8 +49,8 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 82 # length
-function user.s0_1{autoCommit=true}(A0:str):void;
+% 430 # length
+function user.s2_1{autoCommit=true}(A0:str):void;
X_4:bat[:oid,:int] := bat.new(nil:oid,nil:int);
X_3 := sql.mvc();
X_7:bat[:oid,:oid] := sql.tid(X_3,"sys","customer");
@@ -61,18 +61,18 @@ function user.s0_1{autoCommit=true}(A0:s
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);
- X_115 := algebra.leftfetchjoin(r1_22,X_10);
+ X_118 := algebra.leftfetchjoin(r1_22,X_10);
X_24 := sql.bind(X_3,"sys","orders","o_comment",0);
(X_26,r1_26) := sql.bind(X_3,"sys","orders","o_comment",2);
X_28 := sql.bind(X_3,"sys","orders","o_comment",1);
X_29 := sql.delta(X_24,X_26,r1_26,X_28);
- X_30:bat[:oid,:str] := algebra.leftfetchjoin(X_115,X_29);
+ X_30:bat[:oid,:str] := algebra.leftfetchjoin(X_118,X_29);
X_32 := algebra.likesubselect(X_30,A0,"",true);
X_34 := sql.bind(X_3,"sys","orders","o_orderkey",0);
(X_36,r1_40) := sql.bind(X_3,"sys","orders","o_orderkey",2);
X_39 := sql.bind(X_3,"sys","orders","o_orderkey",1);
X_41 := sql.delta(X_34,X_36,r1_40,X_39);
- X_42:bat[:oid,:int] := algebra.leftfetchjoinPath(X_32,X_115,X_41);
+ X_42:bat[:oid,:int] := algebra.leftfetchjoinPath(X_32,X_118,X_41);
X_43 := bat.append(X_4,X_42,true);
X_44 := sql.bind(X_3,"sys","customer","c_custkey",0);
(X_48,r1_53) := sql.bind(X_3,"sys","customer","c_custkey",2);
@@ -103,7 +103,8 @@ function user.s0_1{autoCommit=true}(A0:s
sql.rsColumn(X_86,".L2","custdist","wrd",32,0,X_85);
X_98 := io.stdout();
sql.exportResult(X_98,X_86);
-end s0_1;
+end s2_1;
+# querylog.define("explain select\n\tc_count,\n\tcount(*) as
custdist\nfrom\n\t(\n\t\tselect\n\t\t\tc_custkey,\n\t\t\tcount(o_orderkey)\n\t\tfrom\n\t\t\tcustomer
left outer join orders on\n\t\t\t\tc_custkey = o_custkey\n\t\t\t\tand
o_comment not like \\'%special%requests%\\'\n\t\tgroup by\n\t\t\tc_custkey\n\t)
as c_orders (c_custkey, c_count)\ngroup by\n\tc_count\norder by\n\tcustdist
desc,\n\tc_count desc;","sequential_pipe")
# 22:53:28 >
# 22:53:28 > "Done."
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
@@ -59,8 +59,8 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 120 # length
-function
user.s0_1{autoCommit=true}(A0:str,A1:str,A2:int,A3:int,A4:int,A5:int,A6:int,A7:int,A8:int,A9:int,A10:str):void;
+% 577 # length
+function
user.s2_1{autoCommit=true}(A0:str,A1:str,A2:int,A3:int,A4:int,A5:int,A6:int,A7:int,A8:int,A9:int,A10:str):void;
X_13 := sql.mvc();
X_14:bat[:oid,:oid] := sql.tid(X_13,"sys","partsupp");
X_17 :=
sql.bind_idxbat(X_13,"sys","partsupp","partsupp_ps_partkey_fkey",0);
@@ -103,63 +103,58 @@ function user.s0_1{autoCommit=true}(A0:s
X_70 := bat.mergecand(X_68,X_69);
X_71 := algebra.leftfetchjoin(X_70,X_27);
(X_72,r1_83) := algebra.join(X_26,X_71);
- X_204 := algebra.leftfetchjoin(X_72,X_14);
- X_74 := sql.bind(X_13,"sys","partsupp","ps_partkey",0);
- (X_79,r1_90) := sql.bind(X_13,"sys","partsupp","ps_partkey",2);
- X_82 := sql.bind(X_13,"sys","partsupp","ps_partkey",1);
+ X_74 := sql.bind(X_13,"sys","partsupp","ps_suppkey",0);
+ (X_79,r1_90) := sql.bind(X_13,"sys","partsupp","ps_suppkey",2);
+ X_82 := sql.bind(X_13,"sys","partsupp","ps_suppkey",1);
X_84 := sql.delta(X_74,X_79,r1_90,X_82);
- X_85:bat[:oid,:int] := algebra.leftfetchjoin(X_204,X_84);
+ X_85:bat[:oid,:int] := algebra.leftfetchjoinPath(X_72,X_14,X_84);
X_86 := bat.mirror(X_85);
- X_87 := sql.bind(X_13,"sys","partsupp","ps_suppkey",0);
- (X_89,r1_101) := sql.bind(X_13,"sys","partsupp","ps_suppkey",2);
- X_91 := sql.bind(X_13,"sys","partsupp","ps_suppkey",1);
- X_92 := sql.delta(X_87,X_89,r1_101,X_91);
- X_93:bat[:oid,:int] := algebra.leftfetchjoin(X_204,X_92);
- X_94:bat[:oid,:oid] := sql.tid(X_13,"sys","supplier");
- X_96 := sql.bind(X_13,"sys","supplier","s_comment",0);
- (X_98,r1_111) := sql.bind(X_13,"sys","supplier","s_comment",2);
- X_100 := sql.bind(X_13,"sys","supplier","s_comment",1);
- X_101 := sql.delta(X_96,X_98,r1_111,X_100);
- X_102 := algebra.leftfetchjoin(X_94,X_101);
- X_104 := algebra.likesubselect(X_102,A10,"",false);
- X_106 := sql.bind(X_13,"sys","supplier","s_suppkey",0);
- (X_110,r1_125) := sql.bind(X_13,"sys","supplier","s_suppkey",2);
- X_113 := sql.bind(X_13,"sys","supplier","s_suppkey",1);
- X_115 := sql.delta(X_106,X_110,r1_125,X_113);
- X_116:bat[:oid,:int] := algebra.leftfetchjoinPath(X_104,X_94,X_115);
- (X_117,r1_133) := algebra.join(X_93,X_116);
- X_119 := algebra.tdiff(X_86,X_117);
- X_205 := algebra.leftfetchjoin(X_119,r1_83);
- X_120:bat[:oid,:str] := algebra.leftfetchjoinPath(X_205,X_70,X_42);
- X_121:bat[:oid,:str] := algebra.leftfetchjoinPath(X_205,X_70,X_51);
- X_122:bat[:oid,:int] := algebra.leftfetchjoinPath(X_205,X_70,X_35);
- (X_123,r1_145,r2_145) := group.subgroup(X_122);
- (X_126,r1_148,r2_148) := group.subgroup(X_121,X_123);
- (X_129,r1_151,r2_151) := group.subgroupdone(X_120,X_126);
- X_132 := algebra.leftfetchjoin(r1_151,X_122);
- X_133 := algebra.leftfetchjoin(r1_151,X_120);
- X_134 := algebra.leftfetchjoin(r1_151,X_121);
- X_135 := algebra.leftfetchjoin(X_119,X_93);
- (X_136,r1_158,r2_158) := group.subgroupdone(X_135,X_129);
- X_139 := algebra.leftfetchjoin(r1_158,X_135);
- X_140 := algebra.leftfetchjoin(r1_158,X_129);
- X_141:bat[:oid,:wrd] := aggr.subcount(X_139,X_140,r1_151,true);
- (X_143,r1_165,r2_165) := algebra.subsort(X_141,true,false);
- (X_147,r1_169,r2_169) := algebra.subsort(X_134,r1_165,r2_165,false,false);
- (X_150,r1_172,r2_172) := algebra.subsort(X_133,r1_169,r2_169,false,false);
- (X_153,r1_175,r2_175) := algebra.subsort(X_132,r1_172,r2_172,false,false);
- X_156 := algebra.leftfetchjoin(r1_175,X_134);
- X_159 := algebra.leftfetchjoin(r1_175,X_141);
- X_158 := algebra.leftfetchjoin(r1_175,X_132);
- X_157 := algebra.leftfetchjoin(r1_175,X_133);
- 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 s0_1;
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
