Changeset: da1d205c1055 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=da1d205c1055
Modified Files:
sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out
sql/benchmarks/tpch/LOCKED/Tests/14.stable.out
sql/benchmarks/tpch/Tests/08-explain.stable.out
sql/benchmarks/tpch/Tests/17-explain.stable.out
sql/benchmarks/tpch/Tests/20-explain.stable.out
sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
Branch: Jul2015
Log Message:
Approve non-128 bit output.
diffs (111 lines):
diff --git a/sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out
b/sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out
--- a/sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out
+++ b/sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out
@@ -779,7 +779,7 @@ Ready.
% promo_revenue # name
% decimal # type
% 21 # length
-[ 15.48 ]
+[ 15.48654 ]
#select * from optimizer_stats() stats;
% .stats, .stats # table_name
% rewrite, count # name
diff --git a/sql/benchmarks/tpch/LOCKED/Tests/14.stable.out
b/sql/benchmarks/tpch/LOCKED/Tests/14.stable.out
--- a/sql/benchmarks/tpch/LOCKED/Tests/14.stable.out
+++ b/sql/benchmarks/tpch/LOCKED/Tests/14.stable.out
@@ -34,7 +34,7 @@ Ready.
% promo_revenue # name
% decimal # type
% 21 # length
-[ 15.48 ]
+[ 15.48654 ]
#select * from optimizer_stats() stats;
% .stats, .stats # table_name
% rewrite, count # name
diff --git a/sql/benchmarks/tpch/Tests/08-explain.stable.out
b/sql/benchmarks/tpch/Tests/08-explain.stable.out
--- a/sql/benchmarks/tpch/Tests/08-explain.stable.out
+++ b/sql/benchmarks/tpch/Tests/08-explain.stable.out
@@ -98,11 +98,11 @@ function user.s2_1{autoCommit=true}(A0:s
X_44 := algebra.leftfetchjoin(X_32,X_43);
X_47:bat[:oid,:str] := sql.bind(X_9,"sys","part","p_type",0);
X_45:bat[:oid,:oid] := sql.tid(X_9,"sys","part");
- X_295 := algebra.subselect(X_47,X_45,A6,A6,true,true,false);
+ X_295 := algebra.subselect(X_47,X_45,A6,A6,true,false,false);
(X_50,r1_56) := sql.bind(X_9,"sys","part","p_type",2);
- X_296 := algebra.subselect(r1_56,nil:bat[:oid,:oid],A6,A6,true,true,false);
+ X_296 :=
algebra.subselect(r1_56,nil:bat[:oid,:oid],A6,A6,true,false,false);
X_53:bat[:oid,:str] := sql.bind(X_9,"sys","part","p_type",1);
- X_298 := algebra.subselect(X_53,X_45,A6,A6,true,true,false);
+ X_298 := algebra.subselect(X_53,X_45,A6,A6,true,false,false);
X_55 := sql.subdelta(X_295,X_45,X_50,X_296,X_298);
X_57:bat[:oid,:int] := sql.bind(X_9,"sys","part","p_partkey",0);
(X_59,r1_68) := sql.bind(X_9,"sys","part","p_partkey",2);
diff --git a/sql/benchmarks/tpch/Tests/17-explain.stable.out
b/sql/benchmarks/tpch/Tests/17-explain.stable.out
--- a/sql/benchmarks/tpch/Tests/17-explain.stable.out
+++ b/sql/benchmarks/tpch/Tests/17-explain.stable.out
@@ -58,17 +58,17 @@ function user.s2_1{autoCommit=true}(A0:b
X_21:bat[:oid,:str] := sql.bind(X_6,"sys","part","p_container",0);
X_26:bat[:oid,:str] := sql.bind(X_6,"sys","part","p_brand",0);
X_19:bat[:oid,:oid] := sql.tid(X_6,"sys","part");
- X_132 := algebra.subselect(X_26,X_19,A1,A1,true,true,false);
+ X_132 := algebra.subselect(X_26,X_19,A1,A1,true,false,false);
(X_28,r1_32) := sql.bind(X_6,"sys","part","p_brand",2);
- X_133 := algebra.subselect(r1_32,nil:bat[:oid,:oid],A1,A1,true,true,false);
+ X_133 :=
algebra.subselect(r1_32,nil:bat[:oid,:oid],A1,A1,true,false,false);
X_30:bat[:oid,:str] := sql.bind(X_6,"sys","part","p_brand",1);
- X_135 := algebra.subselect(X_30,X_19,A1,A1,true,true,false);
+ X_135 := algebra.subselect(X_30,X_19,A1,A1,true,false,false);
X_31 := sql.subdelta(X_132,X_19,X_28,X_133,X_135);
- X_136 := algebra.subselect(X_21,X_31,A2,A2,true,true,false);
+ X_136 := algebra.subselect(X_21,X_31,A2,A2,true,false,false);
(X_23,r1_24) := sql.bind(X_6,"sys","part","p_container",2);
- X_137 := algebra.subselect(r1_24,nil:bat[:oid,:oid],A2,A2,true,true,false);
+ X_137 :=
algebra.subselect(r1_24,nil:bat[:oid,:oid],A2,A2,true,false,false);
X_25:bat[:oid,:str] := sql.bind(X_6,"sys","part","p_container",1);
- X_139 := algebra.subselect(X_25,X_31,A2,A2,true,true,false);
+ X_139 := algebra.subselect(X_25,X_31,A2,A2,true,false,false);
X_34 := sql.subdelta(X_136,X_31,X_23,X_137,X_139);
X_35:bat[:oid,:int] := sql.bind(X_6,"sys","part","p_partkey",0);
(X_39,r1_46) := sql.bind(X_6,"sys","part","p_partkey",2);
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
@@ -140,7 +140,7 @@ function user.s2_1{autoCommit=true}(A0:s
X_109 := algebra.leftfetchjoin(X_104,X_108);
X_110 := algebra.leftfetchjoin(r1_116,X_92);
X_111:bat[:oid,:bit] := batcalc.==(X_109,X_110);
- X_113 := algebra.subselect(X_111,true,true,true,true,false);
+ X_113 := algebra.subselect(X_111,true,true,true,false,false);
X_115 := algebra.leftfetchjoin(X_113,X_104);
X_116:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
(X_121,r1_136) := sql.bind(X_8,"sys","partsupp","ps_suppkey",2);
@@ -151,7 +151,7 @@ function user.s2_1{autoCommit=true}(A0:s
X_129 := algebra.leftfetchjoin(X_113,r1_116);
X_130 := algebra.leftfetchjoin(X_129,X_102);
X_131:bat[:oid,:bit] := batcalc.==(X_128,X_130);
- X_132 := algebra.subselect(X_131,true,true,true,true,false);
+ X_132 := algebra.subselect(X_131,true,true,true,false,false);
X_133 := algebra.leftfetchjoin(X_132,X_115);
X_134:bat[:oid,:oid] := batcalc.identity(X_108);
X_135 := algebra.leftfetchjoin(X_133,X_134);
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
@@ -140,7 +140,7 @@ function user.s2_1{autoCommit=true}(A0:s
X_109 := algebra.leftfetchjoin(X_104,X_108);
X_110 := algebra.leftfetchjoin(r1_116,X_92);
X_111:bat[:oid,:bit] := batcalc.==(X_109,X_110);
- X_113 := algebra.subselect(X_111,true,true,true,true,false);
+ X_113 := algebra.subselect(X_111,true,true,true,false,false);
X_115 := algebra.leftfetchjoin(X_113,X_104);
X_116:bat[:oid,:int] := sql.bind(X_8,"sys","partsupp","ps_suppkey",0);
(X_121,r1_136) := sql.bind(X_8,"sys","partsupp","ps_suppkey",2);
@@ -151,7 +151,7 @@ function user.s2_1{autoCommit=true}(A0:s
X_129 := algebra.leftfetchjoin(X_113,r1_116);
X_130 := algebra.leftfetchjoin(X_129,X_102);
X_131:bat[:oid,:bit] := batcalc.==(X_128,X_130);
- X_132 := algebra.subselect(X_131,true,true,true,true,false);
+ X_132 := algebra.subselect(X_131,true,true,true,false,false);
X_133 := algebra.leftfetchjoin(X_132,X_115);
X_134:bat[:oid,:oid] := batcalc.identity(X_108);
X_135 := algebra.leftfetchjoin(X_133,X_134);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
