Changeset: 181f419a2a06 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=181f419a2a06
Modified Files:
sql/benchmarks/tpch/Tests/11-explain.stable.out
sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
Branch: default
Log Message:
approve output
diffs (30 lines):
diff --git a/sql/benchmarks/tpch/Tests/11-explain.stable.out
b/sql/benchmarks/tpch/Tests/11-explain.stable.out
--- a/sql/benchmarks/tpch/Tests/11-explain.stable.out
+++ b/sql/benchmarks/tpch/Tests/11-explain.stable.out
@@ -56,9 +56,9 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 633 # length
+% 812 # length
function user.s2_1{autoCommit=true}(A0:str,A1:sht,A2:str):void;
- X_132:void := querylog.define("explain
select\n\tps_partkey,\n\tsum(ps_supplycost * ps_availqty) as
value\nfrom\n\tpartsupp,\n\tsupplier,\n\tnation\nwhere\n\tps_suppkey =
s_suppkey\n\tand s_nationkey = n_nationkey\n\tand n_name = \\'GERMANY\\'\ngroup
by\n\tps_partkey having\n\t\tsum(ps_supplycost * ps_availqty) >
(\n\t\t\tselect\n\t\t\t\tsum(ps_supplycost * ps_availqty) *
0.0100000000\n\t\t\tfrom\n\t\t\t\tpartsupp,\n\t\t\t\tsupplier,\n\t\t\t\tnation\n\t\t\twhere\n\t\t\t\tps_suppkey
= s_suppkey\n\t\t\t\tand s_nationkey = n_nationkey\n\t\t\t\tand n_name =
\\'GERMANY\\'\n\t\t)\norder by\n\tvalue desc;","sequential_pipe",72);
+ X_132:void := querylog.define("explain
select\n\tps_partkey,\n\tsum(ps_supplycost * ps_availqty) as
value\nfrom\n\tpartsupp,\n\tsupplier,\n\tnation\nwhere\n\tps_suppkey =
s_suppkey\n\tand s_nationkey = n_nationkey\n\tand n_name = \\'GERMANY\\'\ngroup
by\n\tps_partkey having\n\t\tsum(ps_supplycost * ps_availqty) >
(\n\t\t\tselect\n\t\t\t\tsum(ps_supplycost * ps_availqty) *
0.0100000000\n\t\t\t--\t
^^^^^^^^^^^^\n\t\t\t-- The above constant needs to be adjusted
according\n\t\t\t-- to the scale factor (SF): constant = 0.0001 /
SF.\n\t\t\tfrom\n\t\t\t\tpartsupp,\n\t\t\t\tsupplier,\n\t\t\t\tnation\n\t\t\twhere\n\t\t\t\tps_suppkey
= s_suppkey\n\t\t\t\tand s_nationkey = n_nationkey\n\t\t\t\tand n_name =
\\'GERMANY\\'\n\t\t)\norder by\n\tvalue desc;","sequential_pipe",72);
X_5 := sql.mvc();
X_6:bat[:oid,:oid] := sql.tid(X_5,"sys","supplier");
X_9:bat[:oid,:oid] :=
sql.bind_idxbat(X_5,"sys","supplier","supplier_s_nationkey_fkey",0);
diff --git a/sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
b/sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
--- a/sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
+++ b/sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
@@ -56,9 +56,9 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 633 # length
+% 812 # length
function user.s2_1{autoCommit=true}(A0:str,A1:sht,A2:str):void;
- X_132:void := querylog.define("explain
select\n\tps_partkey,\n\tsum(ps_supplycost * ps_availqty) as
value\nfrom\n\tpartsupp,\n\tsupplier,\n\tnation\nwhere\n\tps_suppkey =
s_suppkey\n\tand s_nationkey = n_nationkey\n\tand n_name = \\'GERMANY\\'\ngroup
by\n\tps_partkey having\n\t\tsum(ps_supplycost * ps_availqty) >
(\n\t\t\tselect\n\t\t\t\tsum(ps_supplycost * ps_availqty) *
0.0100000000\n\t\t\tfrom\n\t\t\t\tpartsupp,\n\t\t\t\tsupplier,\n\t\t\t\tnation\n\t\t\twhere\n\t\t\t\tps_suppkey
= s_suppkey\n\t\t\t\tand s_nationkey = n_nationkey\n\t\t\t\tand n_name =
\\'GERMANY\\'\n\t\t)\norder by\n\tvalue desc;","sequential_pipe",72);
+ X_132:void := querylog.define("explain
select\n\tps_partkey,\n\tsum(ps_supplycost * ps_availqty) as
value\nfrom\n\tpartsupp,\n\tsupplier,\n\tnation\nwhere\n\tps_suppkey =
s_suppkey\n\tand s_nationkey = n_nationkey\n\tand n_name = \\'GERMANY\\'\ngroup
by\n\tps_partkey having\n\t\tsum(ps_supplycost * ps_availqty) >
(\n\t\t\tselect\n\t\t\t\tsum(ps_supplycost * ps_availqty) *
0.0100000000\n\t\t\t--\t
^^^^^^^^^^^^\n\t\t\t-- The above constant needs to be adjusted
according\n\t\t\t-- to the scale factor (SF): constant = 0.0001 /
SF.\n\t\t\tfrom\n\t\t\t\tpartsupp,\n\t\t\t\tsupplier,\n\t\t\t\tnation\n\t\t\twhere\n\t\t\t\tps_suppkey
= s_suppkey\n\t\t\t\tand s_nationkey = n_nationkey\n\t\t\t\tand n_name =
\\'GERMANY\\'\n\t\t)\norder by\n\tvalue desc;","sequential_pipe",72);
X_5 := sql.mvc();
X_6:bat[:oid,:oid] := sql.tid(X_5,"sys","supplier");
X_9:bat[:oid,:oid] :=
sql.bind_idxbat(X_5,"sys","supplier","supplier_s_nationkey_fkey",0);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
