Changeset: 17d252bff566 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=17d252bff566
Modified Files:
sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
Branch: default
Log Message:
approved output
diffs (241 lines):
diff --git a/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
b/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
--- a/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
+++ b/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
@@ -43,7 +43,7 @@ end s2_1;
% .explain # table_name
% mal # name
% clob # type
-% 68 # length
+% 70 # length
function user.s3_1{autoCommit=true}(A0:sht,A1:sht):void;
X_4 := udf.fuse(A0,A1);
sql.exportValue(1,".L","fuse_single_value","int",32,0,6,X_4,"");
@@ -59,7 +59,7 @@ end s3_1;
% .explain # table_name
% mal # name
% clob # type
-% 73 # length
+% 76 # length
function user.s4_1{autoCommit=true}(A0:int,A1:int):void;
X_4 := udf.fuse(A0,A1);
sql.exportValue(1,".L","fuse_single_value","bigint",64,0,6,X_4,"");
@@ -93,7 +93,7 @@ end s4_1;
% .explain # table_name
% mal # name
% clob # type
-% 75 # length
+% 78 # length
function user.s8_1{autoCommit=true}():void;
X_2 := sql.mvc();
X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","udf_fuse");
@@ -118,7 +118,7 @@ end s8_1;
% .explain # table_name
% mal # name
% clob # type
-% 75 # length
+% 78 # length
function user.s9_1{autoCommit=true}():void;
X_2 := sql.mvc();
X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","udf_fuse");
@@ -143,7 +143,7 @@ end s9_1;
% .explain # table_name
% mal # name
% clob # type
-% 75 # length
+% 78 # length
function user.s10_1{autoCommit=true}():void;
X_2 := sql.mvc();
X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","udf_fuse");
diff --git a/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
b/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
--- a/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
+++ b/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
@@ -48,7 +48,7 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 74 # length
+% 77 # length
function user.s2_1{autoCommit=true}(A0:str):void;
X_3 := udf.reverse(A0);
sql.exportValue(1,".L","reverse_single_value","clob",0,0,4,X_3,"");
@@ -82,7 +82,7 @@ end s2_1;
% .explain # table_name
% mal # name
% clob # type
-% 79 # length
+% 82 # length
function user.s6_1{autoCommit=true}():void;
X_2 := sql.mvc();
X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","udf_reverse");
diff --git a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
b/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
--- a/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
+++ b/sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
@@ -27,7 +27,7 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 78 # length
+% 81 # length
function user.s3_1{autoCommit=true}(A0:dbl):void;
X_3 := sql.mvc();
X_4:bat[:oid,:oid] := sql.tid(X_3,"sys","sf_2596114");
@@ -47,7 +47,7 @@ end s3_1;
% .explain # table_name
% mal # name
% clob # type
-% 71 # length
+% 74 # length
function user.s4_1{autoCommit=true}():void;
X_2 := sql.mvc();
X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","sf_2596114");
diff --git
a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
--- a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
+++ b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
@@ -38,7 +38,7 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 91 # length
+% 94 # length
function user.s5_1{autoCommit=true}():void;
X_2 := sql.mvc();
X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","t2564");
diff --git
a/sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
b/sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
--- a/sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
+++ b/sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
@@ -33,7 +33,7 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 90 # length
+% 93 # length
function user.s5_1{autoCommit=true}(A0:flt):void;
X_3 := sql.mvc();
X_7 := sql.bind(X_3,"sys","tab_2826","d",0);
diff --git
a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
---
a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
+++
b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
@@ -29,7 +29,7 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 111 # length
+% 114 # length
function user.s2_1(A0:str):void;
X_2 := sql.mvc();
X_6 := sql.bind(X_2,"sys","functions","name",0);
@@ -56,7 +56,7 @@ end s2_1;
% .explain # table_name
% mal # name
% clob # type
-% 115 # length
+% 118 # length
function user.s3_1(A0:str):void;
X_2 := sql.mvc();
X_6 := sql.bind(X_2,"sys","functions","name",0);
@@ -83,7 +83,7 @@ end s3_1;
% .explain # table_name
% mal # name
% clob # type
-% 112 # length
+% 115 # length
function user.s4_1(A0:str):void;
X_2 := sql.mvc();
X_6 := sql.bind(X_2,"sys","functions","name",0);
@@ -110,7 +110,7 @@ end s4_1;
% .explain # table_name
% mal # name
% clob # type
-% 116 # length
+% 119 # length
function user.s5_1(A0:str):void;
X_2 := sql.mvc();
X_6 := sql.bind(X_2,"sys","functions","name",0);
@@ -157,7 +157,7 @@ end s5_1;
% .explain # table_name
% mal # name
% clob # type
-% 115 # length
+% 118 # length
function user.s10_1(A0:str):void;
X_2 := sql.mvc();
X_6 := sql.bind(X_2,"sys","functions","name",0);
@@ -186,7 +186,7 @@ end s10_1;
% .explain # table_name
% mal # name
% clob # type
-% 119 # length
+% 122 # length
function user.s11_1(A0:str):void;
X_2 := sql.mvc();
X_6 := sql.bind(X_2,"sys","functions","name",0);
@@ -215,7 +215,7 @@ end s11_1;
% .explain # table_name
% mal # name
% clob # type
-% 116 # length
+% 119 # length
function user.s12_1(A0:str):void;
X_2 := sql.mvc();
X_6 := sql.bind(X_2,"sys","functions","name",0);
@@ -244,7 +244,7 @@ end s12_1;
% .explain # table_name
% mal # name
% clob # type
-% 120 # length
+% 123 # length
function user.s13_1(A0:str):void;
X_2 := sql.mvc();
X_6 := sql.bind(X_2,"sys","functions","name",0);
diff --git a/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
b/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
--- a/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
+++ b/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
@@ -23,9 +23,9 @@ Ready.
Operation successful
-+------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------+
| mal |
-+==============================================================================+
++=================================================================================+
| function user.s2_1{autoCommit=true}():void;
|
| X_3:bat[:oid,:str] := bat.new(nil:oid,nil:str); |
| X_2 := sql.mvc(); |
@@ -55,8 +55,8 @@ Operation successful
| X_45 := io.stdout(); |
| sql.exportResult(X_45,X_39); |
| end s2_1;
|
-| # querylog.define("explain select \"name\" from \"tables\";","default_pipe")
|
-+------------------------------------------------------------------------------+
+| # querylog.define("explain select \"name\" from
\"tables\";","sequential_pipe") |
++---------------------------------------------------------------------------------+
30 rows
diff --git a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
--- a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
+++ b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
@@ -47,9 +47,9 @@ 20 rows
Operation successful
-+--------------------------------------------------------------------------+
++-----------------------------------------------------------------------------+
| mal |
-+==========================================================================+
++=============================================================================+
| function user.s3_1{autoCommit=true}():void; |
| X_3:bat[:oid,:wrd] := bat.new(nil:oid,nil:wrd); |
| X_2 := sql.mvc(); |
@@ -81,8 +81,8 @@ Operation successful
| X_44:wrd := aggr.sum(X_43); |
| sql.exportValue(1,".L1","L1","wrd",64,0,6,X_44,""); |
| end s3_1; |
-| # querylog.define("explain select count(*) from tables;","default_pipe") |
-+--------------------------------------------------------------------------+
+| # querylog.define("explain select count(*) from tables;","sequential_pipe") |
++-----------------------------------------------------------------------------+
32 rows
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
