subject:"MonetDB\: newstorage \- approved output"

MonetDB: newstorage - approved output

2015-03-25 Thread Niels Nes

Changeset: 567f95a5e818 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=567f95a5e818
Modified Files:
clients/Tests/SQL-dump_all.stable.out.int128
sql/test/Dependencies/Tests/Dependencies_bam.stable.out.int128
Branch: newstorage
Log Message:

approved output


diffs (41 lines):

diff --git a/clients/Tests/SQL-dump_all.stable.out.int128 
b/clients/Tests/SQL-dump_all.stable.out.int128
--- a/clients/Tests/SQL-dump_all.stable.out.int128
+++ b/clients/Tests/SQL-dump_all.stable.out.int128
@@ -1620,10 +1620,10 @@ 6987"sorted""boolean"   1   0   
6988NULLtr
 6990   "schema""clob"  0   0   6998NULLtrue0   
NULL
 6991   "table" "clob"  0   0   6998NULLtrue1   NULL
 6992   "count" "bigint"64  0   6998NULLtrue2   
NULL
-6993   "columnsize""hugeint"   64  0   6998NULLtrue
3   NULL
-6994   "heapsize"  "hugeint"   64  0   6998NULLtrue
4   NULL
-6995   "hashes""hugeint"   64  0   6998NULLtrue
5   NULL
-6996   "imprints"  "hugeint"   64  0   6998NULLtrue
6   NULL
+6993   "columnsize""hugeint"   128 0   6998NULLtrue
3   NULL
+6994   "heapsize"  "hugeint"   128 0   6998NULLtrue
4   NULL
+6995   "hashes""hugeint"   128 0   6998NULLtrue
5   NULL
+6996   "imprints"  "hugeint"   128 0   6998NULLtrue
6   NULL
 6997   "auxiliary" "hugeint"   128 0   6998NULLtrue
7   NULL
 7000   "column_id" "int"   32  0   7011NULLtrue0   
NULL
 7001   "type"  "clob"  0   0   7011NULLtrue1   NULL
diff --git a/sql/test/Dependencies/Tests/Dependencies_bam.stable.out.int128 
b/sql/test/Dependencies/Tests/Dependencies_bam.stable.out.int128
--- a/sql/test/Dependencies/Tests/Dependencies_bam.stable.out.int128
+++ b/sql/test/Dependencies/Tests/Dependencies_bam.stable.out.int128
@@ -90,8 +90,8 @@ Dependencies between database objects
 [ "monetdb",   "sys",  "DEP_SCHEMA"]
 [ "monetdb",   "tmp",  "DEP_SCHEMA"]
 [ "monetdb",   "json", "DEP_SCHEMA"]
+[ "monetdb",   "bam",  "DEP_SCHEMA"]
 [ "monetdb",   "test", "DEP_SCHEMA"]
-[ "monetdb",   "bam",  "DEP_SCHEMA"]
 #SELECT t.name, v.name, 'DEP_VIEW' from tables as t, tables as v, dependencies 
as dep where t.id = dep.id AND v.id = dep.depend_id AND dep.depend_type = 5 AND 
v.type = 1;
 % .t,  .v, .L # table_name
 % name,name,   single_value # name
@@ -110,8 +110,8 @@ Dependencies between database objects
 % name,trigname,   L1 # name
 % varchar, varchar,char # type
 % 2,   14, 11 # length
+[ "t1","trigger_test", "DEP_TRIGGER"   ]
 [ "t1","trigger_test_4",   "DEP_TRIGGER"   ]
-[ "t1","trigger_test", "DEP_TRIGGER"   ]
 [ "t2","trigger_test", "DEP_TRIGGER"   ]
 [ "t3","trigger_test_4",   "DEP_TRIGGER"   ]
 #SELECT t.name, fk.name, 'DEP_FKEY' from tables as t, keys as k, keys as fk 
where fk.rkey = k.id and k.table_id = t.id;
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

MonetDB: newstorage - approved output

2015-03-25 Thread Niels Nes

Changeset: 9160b990bb20 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9160b990bb20
Modified Files:
sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
Branch: newstorage
Log Message:

approved output


diffs (truncated from 942 to 300 lines):

diff --git a/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128 
b/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
@@ -66,7 +66,7 @@ function user.s2_1{autoCommit=true}(A0:i
 X_47:bat[:oid,:int] := algebra.leftfetchjoin(X_77,X_16);
 X_48:bat[:oid,:lng] := batcalc.*(X_46,X_47);
 X_49:hge := aggr.sum(X_48);
-sql.exportValue(1,"sys.L1","revenue","hugeint",64,0,7,X_49,"");
+sql.exportValue(1,"sys.L1","revenue","hugeint",128,0,7,X_49,"");
 end user.s2_1;
 
 # 23:10:45 >  
diff --git a/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128 
b/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
@@ -66,7 +66,7 @@ function user.s2_1{autoCommit=true}(A0:i
 X_47:bat[:oid,:int] := algebra.leftfetchjoin(X_77,X_17);
 X_48:bat[:oid,:lng] := batcalc.*(X_46,X_47);
 X_49:hge := aggr.sum(X_48);
-sql.exportValue(1,"sys.L1","revenue","hugeint",64,0,7,X_49,"");
+sql.exportValue(1,"sys.L1","revenue","hugeint",128,0,7,X_49,"");
 end user.s2_1;
 
 # 23:10:45 >  
diff --git a/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128 
b/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
@@ -69,7 +69,7 @@ function user.s2_1{autoCommit=true}(A0:i
 X_53:bat[:oid,:int] := algebra.leftfetchjoin(X_84,X_18);
 X_54:bat[:oid,:lng] := batcalc.*(X_52,X_53);
 X_55:hge := aggr.sum(X_54);
-sql.exportValue(1,"sys.L1","revenue","hugeint",64,0,7,X_55,"");
+sql.exportValue(1,"sys.L1","revenue","hugeint",128,0,7,X_55,"");
 end user.s2_1;
 
 # 23:10:45 >  
diff --git a/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128 
b/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
@@ -41,7 +41,7 @@ Ready.
 % clob # type
 % 412 # length
 function user.s2_1{autoCommit=true}(A0:str,A1:str):void;
-X_110:void := querylog.define("explain\nselect sum(lo_revenue), d_year, 
p_brand1\n\tfrom lineorder, dwdate, part, supplier\n\twhere lo_orderdate = 
d_datekey\n\t\tand lo_partkey = p_partkey\n\t\tand lo_suppkey = 
s_suppkey\n\t\tand p_category = \\'MFGR#12\\' -- OK to add p_mfgr = 
’MFGR#1’\n\t\tand s_region = \\'AMERICA\\'\n\tgroup by d_year, 
p_brand1\n\torder by d_year, p_brand1;","sequential_pipe",57);
+X_111:void := querylog.define("explain\nselect sum(lo_revenue), d_year, 
p_brand1\n\tfrom lineorder, dwdate, part, supplier\n\twhere lo_orderdate = 
d_datekey\n\t\tand lo_partkey = p_partkey\n\t\tand lo_suppkey = 
s_suppkey\n\t\tand p_category = \\'MFGR#12\\' -- OK to add p_mfgr = 
’MFGR#1’\n\t\tand s_region = \\'AMERICA\\'\n\tgroup by d_year, 
p_brand1\n\torder by d_year, p_brand1;","sequential_pipe",57);
 X_4 := sql.mvc();
 X_5:bat[:oid,:oid]  := sql.tid(X_4,"sys","lineorder");
 X_8:bat[:oid,:int] := sql.bind(X_4,"sys","lineorder","lo_partkey",0);
@@ -54,9 +54,9 @@ function user.s2_1{autoCommit=true}(A0:s
 X_21 := X_19;
 X_22 := algebra.leftfetchjoin(X_17,X_21);
 (X_23,r1_24) := algebra.subjoin(X_11,X_22,nil:BAT,nil:BAT,false,nil:lng);
-X_138 := algebra.leftfetchjoin(X_23,X_5);
+X_139 := algebra.leftfetchjoin(X_23,X_5);
 X_27:bat[:oid,:int] := sql.bind(X_4,"sys","lineorder","lo_suppkey",0);
-X_29:bat[:oid,:int] := algebra.leftfetchjoin(

MonetDB: newstorage - approved output

MonetDB: newstorage - approved output

2 matches

Site Navigation

Mail list logo

Footer information