MonetDB: unlock - approved output
Changeset: 9d41c1ef5c73 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9d41c1ef5c73 Modified Files: sql/test/mapi/Tests/sql_int128.test Branch: unlock Log Message: approved output diffs (86 lines): diff --git a/sql/test/mapi/Tests/sql_int128.test b/sql/test/mapi/Tests/sql_int128.test --- a/sql/test/mapi/Tests/sql_int128.test +++ b/sql/test/mapi/Tests/sql_int128.test @@ -20,7 +20,11 @@ sql.tid 1 algebra.project 1 -sql.update +sql.update_prep +1 +sql.update_exec +1 +sql.append_finish 1 aggr.count 1 @@ -40,7 +44,11 @@ sql.tid 1 algebra.project 1 -sql.update +sql.update_prep +1 +sql.update_exec +1 +sql.append_finish 1 aggr.count 1 @@ -62,7 +70,11 @@ sql.bind 2 algebra.projection 2 -sql.update +sql.update_prep +1 +sql.update_exec +1 +sql.append_finish 1 aggr.count 1 @@ -84,7 +96,11 @@ sql.bind 2 algebra.projection 2 -sql.update +sql.update_prep +1 +sql.update_exec +1 +sql.append_finish 1 aggr.count 1 @@ -106,7 +122,11 @@ sql.bind 2 algebra.projection 2 -sql.update +sql.update_prep +1 +sql.update_exec +1 +sql.append_finish 1 aggr.count 1 @@ -162,7 +182,11 @@ sql.mvc 1 sql.claim 1 -sql.append +sql.append_prep +1 +sql.append_exec +1 +sql.append_finish 1 sql.affectedRows 1 @@ -180,3 +204,4 @@ ROLLBACK statement ok set optimizer = 'default_pipe' + ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: 7211baefb707 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7211baefb707 Modified Files: sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test sql/test/BugTracker/Tests/explain.SF-1739353.test Branch: unlock Log Message: approved output diffs (164 lines): diff --git a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test --- a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test +++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test @@ -113,9 +113,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -137,9 +137,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -163,9 +163,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -189,9 +189,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -215,9 +215,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -241,9 +241,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -267,9 +267,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -295,9 +295,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -325,9 +325,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -355,9 +355,9 @@ sql.mvc 1 sql.tid 1 +sql.bind +1 sql.emptybind -2 -sql.bind 1 sql.delta 1 @@ -374,7 +374,6 @@ 5 sql.resultSet 1 - query I rowsort select * from oblo @@ -440,4 +439,3 @@ 3 statement ok drop table oblo - diff --git a/sql/test/BugTracker/Tests/explain.SF-1739353.test b/sql/test/BugTracker/Tests/explain.SF-1739353.test --- a/sql/test/BugTracker/Tests/explain.SF-1739353.test +++ b/sql/test/BugTracker/Tests/explain.SF-1739353.test @@ -13,7 +13,7 @@ 1 sql.mvc 1 sql.bind -5 +6 sql.tid 2 algebra.thetaselect @@ -21,9 +21,7 @@ 2 sql.subdelta 1 sql.projectdelta -1 -algebra.projection -1 +2 bat.append 2 bat.pack @@ -34,4 +32,3 @@ 1 statement ok set optimizer='default_pipe' - ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: 1bf76ab25848 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1bf76ab25848
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
Branch: unlock
Log Message:
approved output
diffs (68 lines):
diff --git
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
--- a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
+++ b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
@@ -9,22 +9,24 @@
% .%1 # table_name
% def # name
% clob # type
-% 580 # length
-[
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.aliases();optimizer.evaluate();optimizer.emptybind();optimizer.pushselect();optimizer.aliases();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.matpack();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.deadcode();optimizer.postfix();optimizer.wlc();optimizer.garbageCollector();"
]
+% 626 # length
+[
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.aliases();optimizer.evaluate();optimizer.emptybind();optimizer.pushselect();optimizer.aliases();optimizer.mergetable();optimizer.bincopyfrom();optimizer.parappend();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.matpack();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.deadcode();optimizer.postfix();optimizer.wlc();optimizer.garbageCollector();"
]
#explain copy into ttt from '/tmp/xyz';
% .explain # table_name
% mal # name
% clob # type
-% 245 # length
+% 274 # length
function user.main():void;
querylog.define("explain copy into ttt from \\'/tmp/xyz\\';":str,
"sequential_pipe":str, 22:int);
X_4:int := sql.mvc();
-(X_27:bat[:int], X_28:bat[:int], X_29:bat[:int]) :=
sql.copy_from(0x7f85501da060:ptr, "|":str, "\n":str, nil:str, "null":str,
"/tmp/xyz":str, -1:lng, 0:lng, 0:int, nil:str, 0:int, 1:int);
+(X_27:bat[:int], X_28:bat[:int], X_29:bat[:int]) :=
sql.copy_from(0x7ffb40161430:ptr, "|":str, "\n":str, nil:str, "null":str,
"/tmp/xyz":str, -1:lng, 0:lng, 0:int, nil:str, 0:int, 1:int);
X_30:lng := aggr.count(X_27:bat[:int]);
X_31:lng := sql.claim(X_4:int, "sys":str, "ttt":str, X_30:lng);
-X_35:int := sql.append(X_4:int, "sys":str, "ttt":str,
"averylongcolumnnametomakeitlargee":str,
X_31:lng, X_27:bat[:int]);
-X_38:int := sql.append(X_35:int, "sys":str, "ttt":str, "b":str, X_31:lng,
X_28:bat[:int]);
-X_41:int := sql.append(X_38:int, "sys":str, "ttt":str, "c":str, X_31:lng,
X_29:bat[:int]);
+(X_86:int, X_85:ptr, X_90:ptr, X_93:ptr) := sql.append_prep(X_4:int,
"sys":str, "ttt":str,
"averylongcolumnnametomakeitlargee":str,
"b":str, "c":str);
+X_88:ptr := sql.append_exec(X_85:ptr, X_31:lng, X_27:bat[:int]);
+X_91:ptr := sql.append_exec(X_90:ptr, X_31:lng, X_28:bat[:int]);
+X_94:ptr := sql.append_exec(X_93:ptr, X_31:lng, X_29:bat[:int]);
+X_41:int := sql.append_finish(X_86:int, X_88:ptr, X_91:ptr, X_94:ptr);
sql.affectedRows(X_41:int, X_30:lng);
end user.main;
#inline actions= 0 time=0 usec
@@ -66,23 +68,25 @@ end user.main;
% .%1 # table_name
% def # name
% clob # type
-% 603 # length
-[
"optimizer.inline();optimizer.remap();optimizer.costModel();optimizer.coercions();optimizer.aliases();optimizer.evaluate();optimizer.emptybind();optimizer.pushselect();optimizer.aliases();optimizer.mergetable();optimizer.deadcode();optimizer.aliases();optimizer.constants();optimizer.commonTerms();optimizer.projectionpath();optimizer.deadcode();optimizer.reorder();optimizer.matpack();optimizer.querylog();optimizer.multiplex();optimizer.generator();optimizer.profiler();optimizer.candidates();optimizer.deadcode();optimizer.postfix();optimizer.wlc();optimizer.sql_append();optimizer.garbageCollector();"
]
+% 649 # length
+[
MonetDB: unlock - approved output
Changeset: a012d4d677e0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a012d4d677e0 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/exports.stable.out Branch: unlock Log Message: approved output diffs (truncated from 1554 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -627,47 +627,31 @@ stdout of test 'MAL-signatures` in direc [ "algebra", "crossproduct", "command algebra.crossproduct(X_1:bat[:any_1], X_2:bat[:any_2], X_3:bit):bat[:oid] ", "ALGcrossproduct1;","" ] [ "algebra", "crossproduct", "command algebra.crossproduct(X_2:bat[:any_1], X_3:bat[:any_2], X_4:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGcrossproduct2;","" ] [ "algebra", "difference", "command algebra.difference(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, X_7:lng):bat[:oid] ", "ALGdifference;", "" ] -[ "algebra", "difference", "command algebra.difference(X_1:bat[:any_1], X_2:bat[:msk], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, X_7:lng):bat[:oid] ", "ALGdifference;", "" ] -[ "algebra", "difference", "command algebra.difference(X_1:bat[:msk], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:bit, X_7:lng):bat[:oid] ", "ALGdifference;", "" ] [ "algebra", "exist","command algebra.exist(X_1:bat[:any_1], X_2:any_1):bit ", "ALGexist;","" ] [ "algebra", "fetch","command algebra.fetch(X_1:bat[:any_1], X_2:oid):any_1 ", "ALGfetchoid;", "" ] [ "algebra", "find", "command algebra.find(X_1:bat[:any_1], X_2:any_1):oid ","ALGfind;", "" ] [ "algebra", "firstn", "pattern algebra.firstn(X_1:bat[:any], X_2:bat[:oid], X_3:bat[:oid], X_4:lng, X_5:bit, X_6:bit, X_7:bit):bat[:oid] ", "ALGfirstn;", "" ] -[ "algebra", "firstn", "pattern algebra.firstn(X_1:bat[:any], X_2:bat[:oid], X_3:lng, X_4:bit, X_5:bit, X_6:bit):bat[:oid] ", "ALGfirstn;", "" ] -[ "algebra", "firstn", "pattern algebra.firstn(X_1:bat[:any], X_2:lng, X_3:bit, X_4:bit, X_5:bit):bat[:oid] ", "ALGfirstn;", "" ] [ "algebra", "firstn", "pattern algebra.firstn(X_2:bat[:any], X_3:bat[:oid], X_4:bat[:oid], X_5:lng, X_6:bit, X_7:bit, X_8:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGfirstn;", "" ] -[ "algebra", "firstn", "pattern algebra.firstn(X_2:bat[:any], X_3:bat[:oid], X_4:lng, X_5:bit, X_6:bit, X_7:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGfirstn;", "" ] -[ "algebra", "firstn", "pattern algebra.firstn(X_2:bat[:any], X_3:lng, X_4:bit, X_5:bit, X_6:bit) (X_0:bat[:oid], X_1:bat[:oid]) ","ALGfirstn;", "" ] [ "algebra", "groupby", "command algebra.groupby(X_1:bat[:oid], X_2:bat[:lng]):bat[:oid] ", "ALGgroupby;", "" ] [ "algebra", "ilike","command algebra.ilike(X_1:str, X_2:str):bit ", "PCREilike2;", "" ] [ "algebra", "ilike","command algebra.ilike(X_1:str, X_2:str, X_3:str):bit ","PCREilike3;", "" ] [ "algebra", "ilikejoin","command algebra.ilikejoin(X_1:bat[:str], X_2:bat[:str], X_3:bat[:oid], X_4:bat[:oid], X_5:bit, X_6:lng, X_7:bit):bat[:oid] ", "ILIKEjoin1;", "" ] [ "algebra", "ilikejoin","command algebra.ilikejoin(X_2:bat[:str], X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, X_8:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ILIKEjoin;", "" ] -[ "algebra", "ilikejoin","command algebra.ilikejoin(X_1:bat[:str], X_2:bat[:str], X_3:str, X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, X_8:bit):bat[:oid] ", "ILIKEjoin_esc1;", "" ] -[ "algebra", "ilikejoin","command algebra.ilikejoin(X_2:bat[:str], X_3:bat[:str], X_4:str, X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ","ILIKEjoin_esc;", "" ] +[ "algebra", "ilikejoin","command algebra.ilikejoin(X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:oid], X_5:bat[:oid], X_6:bit, X_7:lng, X_8:bit):bat[:oid] ", "ILIKEjoin_esc1;", "" ] +[ "algebra", "ilikejoin","command algebra.ilikejoin(X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:oid], X_6:bat[:oid], X_7:bit, X_8:lng, X_9:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ILIKEjoin_esc;", "" ] [ "algebra", "ilikeselect", "command algebra.ilikeselect(X_1:bat[:str], X_2:bat[:oid], X_3:str, X_4:str, X_5:bit):bat[:oid] ", "PCRElikeselect1;", "" ] [ "algebra", "ilikeselect", "command algebra.ilikeselect(X_1:bat[:str], X_2:bat[:oid], X_3:str, X_4:bit):bat[:oid] ", "PCRElikeselect4;", "" ] [ "algebra", "intersect","command
MonetDB: unlock - approved output
Changeset: 930e19729f79 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=930e19729f79
Modified Files:
sql/test/miscellaneous/Tests/groupby_error.test
Branch: unlock
Log Message:
approved output
diffs (12 lines):
diff --git a/sql/test/miscellaneous/Tests/groupby_error.test
b/sql/test/miscellaneous/Tests/groupby_error.test
--- a/sql/test/miscellaneous/Tests/groupby_error.test
+++ b/sql/test/miscellaneous/Tests/groupby_error.test
@@ -405,7 +405,7 @@ project (
| | | table("sys"."tab1") [ "tab1"."part" as "myalias0"."part", "tab1"."tet"
as "myalias0"."tet" ] COUNT ,
| | | table("sys"."tab2") [ "tab2"."myk" as "myalias1"."myk", "tab2"."ups" as
"myalias1"."ups" ] COUNT
| | ) [ "myalias0"."part" = "myalias1"."myk" ]
-| ) [ "myalias0"."part", "myalias0"."tet" as "track", "myalias1"."ups" ] [
"myalias0"."part", "track", "sys"."count"() NOT NULL as "%1"."%1" ]
+| ) [ "myalias1"."ups", "myalias0"."part", "myalias0"."tet" as "track" ] [
"myalias0"."part", "track", "sys"."count"() NOT NULL as "%1"."%1" ]
) [ "myalias0"."part", "track" as "tet", "%1"."%1" NOT NULL as "mycount",
"track" ]
query rowsort
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: 3c9572faf534 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3c9572faf534 Modified Files: sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 Branch: unlock Log Message: approved output diffs (truncated from 697 to 300 lines): diff --git a/sql/test/emptydb/Tests/check.stable.out b/sql/test/emptydb/Tests/check.stable.out --- a/sql/test/emptydb/Tests/check.stable.out +++ b/sql/test/emptydb/Tests/check.stable.out @@ -136,7 +136,6 @@ \dSf sys."evalalgebra" \dSf sys."fitsattach" \dSf sys."fitsload" -\dSf sys."flush_log" \dSf sys."fuse" \dSf sys."generate_series" \dSf sys."geometrytype" @@ -2159,7 +2158,7 @@ drop function pcre_replace(string, strin % .%1, .s, .f, ., ., .f, .fl,., .f, .f, .f, .f, ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., . # table_name % %1, name, name, system, query, mod,language_name, func_type, side_effect,varres, vararg, semantics, name0, type0, type_digits0, type_scale0,inout0, name1, type1, type_digits1, type_scale1,inout1, name2, type2, type_digits2, type_scale2,inout2, name3, type3, type_digits3, type_scale3,inout3, name4, type4, type_digits4, type_scale4,inout4, name5, type5, type_digits5, type_scale5,inout5, name6, type6, type_digits6, type_scale6,inout6, name7, type7, type_digits7, type_scale7,inout7, name8, type8, type_digits8, type_scale8,inout8, name9, type9, type_digits9, type_scale9,inout9, name10, type10, type_digits10, type_scale10, inout10,name11, type11, type_digits11, type_scale11, inout11,name12, type12, type_digits12, type_scale12, inout12,name13, type13, type_digits13, type_scale13, inout13,name14, type14, type_digits14, type_scale14, inout14, name15, type15, type_digits15, type_scale15, inout15 # name % char,varchar,varchar,char, varchar, varchar,varchar,varchar,boolean,boolean, boolean,boolean,varchar,varchar,int,int, char, varchar,varchar,int,int,char, varchar, varchar,int,int,char, varchar,varchar,int, int,char, varchar,varchar,int,int,char, varchar,varchar,int,int,char, varchar, varchar,int,int,char, varchar,varchar,int, int,char, varchar,varchar,int,int,char, varchar,varchar,int,int,char, varchar, varchar,int,int,char, varchar,varchar,int, int,char, varchar,varchar,int,int,char, varchar,varchar,int,int,char, varchar, varchar,int,int,char, varchar,varchar,int, int,char # type -% 13, 8, 24, 6, 3342, 9, 10, 26, 5, 5, 5, 5, 11, 14, 4, 1, 3, 16, 14, 4, 1, 3, 16, 14, 4, 1, 3, 27, 12, 4, 1, 3, 9, 9, 2, 1, 3, 14, 14, 4, 1, 3, 12, 14, 2, 1, 3, 11, 7, 2, 1, 3, 11, 7, 2, 1, 3, 10, 6, 2, 1, 3, 9, 6, 2, 1, 3, 6, 7, 2, 1, 3, 8, 7, 2, 1, 3, 6, 7, 2, 1, 3, 9, 7, 1, 1, 3, 6, 7, 1, 1, 3 # length +% 13, 8, 24, 6, 3342, 9, 10, 26, 5, 5, 5, 5, 11, 14, 4, 1, 3, 16, 14, 4, 1, 3, 16, 14, 4, 1, 3, 27, 12, 4, 1, 3, 9, 9, 2, 1, 3, 14, 14, 4, 1, 3, 12, 14, 3, 1, 3, 11, 7, 2, 1, 3, 11, 7, 2, 1, 3, 10, 6, 2, 1, 3, 9, 7,
MonetDB: unlock - approved output
Changeset: d4bbfda2f724 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d4bbfda2f724 Modified Files: sql/test/mapi/Tests/sql_int128.test Branch: unlock Log Message: approved output diffs (12 lines): diff --git a/sql/test/mapi/Tests/sql_int128.test b/sql/test/mapi/Tests/sql_int128.test --- a/sql/test/mapi/Tests/sql_int128.test +++ b/sql/test/mapi/Tests/sql_int128.test @@ -168,6 +168,8 @@ querylog.define 1 sql.mvc 1 +sql.claim +1 sql.append 1 sql.affectedRows ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: 691a5c06388d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=691a5c06388d Modified Files: sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test Branch: unlock Log Message: approved output diffs (66 lines): diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test --- a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test @@ -53,7 +53,7 @@ 1 sql.tid 2 sql.bind_idxbat -3 +2 sql.delta 1 algebra.projection @@ -93,7 +93,7 @@ 1 sql.tid 2 sql.bind_idxbat -3 +2 sql.delta 1 algebra.projection diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test --- a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test @@ -53,7 +53,7 @@ 1 sql.tid 2 sql.bind_idxbat -3 +2 sql.delta 1 algebra.projection diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test --- a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test @@ -53,7 +53,7 @@ 1 sql.tid 2 sql.bind_idxbat -3 +2 sql.delta 1 algebra.projection @@ -93,7 +93,7 @@ 1 sql.tid 3 sql.bind_idxbat -6 +4 sql.delta 2 algebra.projection diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test --- a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test @@ -53,7 +53,7 @@ 1 sql.tid 3 sql.bind_idxbat -6 +4 sql.delta 2 algebra.projection ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: b76ccef3e1d8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b76ccef3e1d8 Modified Files: sql/test/BugTracker-2015/Tests/readonly.Bug-3709.test Branch: unlock Log Message: approved output diffs (20 lines): diff --git a/sql/test/BugTracker-2015/Tests/readonly.Bug-3709.test b/sql/test/BugTracker-2015/Tests/readonly.Bug-3709.test --- a/sql/test/BugTracker-2015/Tests/readonly.Bug-3709.test +++ b/sql/test/BugTracker-2015/Tests/readonly.Bug-3709.test @@ -7,11 +7,13 @@ start transaction statement ok insert into s10 values (8) -statement error +statement ok alter table s10 set read only -statement error -trace select * from s10 +query I rowsort +select count(*) from s10 + +1 statement ok rollback ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: 32275b9b7eda for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=32275b9b7eda
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.test
Branch: unlock
Log Message:
approved output
diffs (truncated from 359 to 300 lines):
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.test
b/sql/test/BugTracker-2016/Tests/storagemodel.test
--- a/sql/test/BugTracker-2016/Tests/storagemodel.test
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.test
@@ -4,10 +4,154 @@ create table bug3923(i integer)
query TIITI rowsort
select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes, phash, imprints from
storage('sys','_tables')
-72 values hashing to 4c5e9b1e4afb42c5e62c76d7b0862af9
+sys
+_tables
+access
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+commit_action
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+name
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+query
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+schema_id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+system
+boolean
+writable
+1
+0
+False
+0
+sys
+_tables
+type
+smallint
+writable
+2
+0
+False
+0
-statement ok
+query TIITI rowsort
call storagemodelinit()
+
+sys
+_tables
+access
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+commit_action
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+name
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+query
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+schema_id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+system
+boolean
+writable
+1
+0
+False
+0
+sys
+_tables
+type
+smallint
+writable
+2
+0
+False
+0
statement ok
update storagemodelinput set "count" =1 where "table" ='bug3923'
@@ -18,7 +162,19 @@ update storagemodelinput set "distinct"
query IITTT rowsort
select * from storagemodel where "table" = 'bug3923'
-13 values hashing to c499d6faa21698d5f67e25ef85e898e1
+sys
+bug3923
+i
+int
+1
+1
+8312
+0
+2000
+0
+True
+True
+True
statement ok
drop table bug3923
@@ -35,10 +191,154 @@ create table bug3923(i integer)
query TIITI rowsort
select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes, phash, imprints from
sys.storage('sys','_tables')
-72 values hashing to 4c5e9b1e4afb42c5e62c76d7b0862af9
+sys
+_tables
+access
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+commit_action
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+name
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+query
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+schema_id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+system
+boolean
+writable
+1
+0
+False
+0
+sys
+_tables
+type
+smallint
+writable
+2
+0
+False
+0
-statement ok
+query TIITI rowsort
call sys.storagemodelinit()
+
+sys
+_tables
+access
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+commit_action
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+name
+varchar
+writable
+99
+0
+False
+0
+sys
___
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: 6c7fc4f97150 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6c7fc4f97150 Modified Files: sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test Branch: unlock Log Message: approved output diffs (208 lines): diff --git a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test --- a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test +++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test @@ -114,7 +114,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -138,7 +138,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -164,7 +164,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -190,7 +190,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -216,7 +216,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -242,7 +242,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -268,7 +268,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -296,7 +296,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -326,7 +326,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta @@ -356,7 +356,7 @@ 1 sql.tid 1 sql.emptybind -4 +2 sql.bind 1 sql.delta diff --git a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test --- a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test +++ b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test @@ -16,11 +16,11 @@ 5 sql.mvc 1 sql.bind -6 +4 sql.tid 1 algebra.likeselect -3 +2 sql.subdelta 1 sql.projectdelta @@ -40,11 +40,11 @@ 5 sql.mvc 1 sql.bind -6 +4 sql.tid 1 algebra.likeselect -3 +2 sql.subdelta 1 sql.projectdelta @@ -64,11 +64,11 @@ 5 sql.mvc 1 sql.bind -6 +4 sql.tid 1 algebra.ilikeselect -3 +2 sql.subdelta 1 sql.projectdelta @@ -88,11 +88,11 @@ 5 sql.mvc 1 sql.bind -6 +4 sql.tid 1 algebra.ilikeselect -3 +2 sql.subdelta 1 sql.projectdelta @@ -140,11 +140,11 @@ 5 sql.mvc 1 sql.bind -6 +4 sql.tid 1 algebra.likeselect -3 +2 sql.subdelta 1 sql.projectdelta @@ -164,11 +164,11 @@ 5 sql.mvc 1 sql.bind -6 +4 sql.tid 1 algebra.likeselect -3 +2 sql.subdelta 1 sql.projectdelta @@ -188,11 +188,11 @@ 5 sql.mvc 1 sql.bind -6 +4 sql.tid 1 algebra.likeselect -3 +2 sql.subdelta 1 sql.projectdelta @@ -212,11 +212,11 @@ 5 sql.mvc 1 sql.bind -6 +4 sql.tid 1 algebra.likeselect -3 +2 sql.subdelta 1 sql.projectdelta ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: 9f7563da0caa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9f7563da0caa Modified Files: sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.test sql/test/BugTracker/Tests/explain.SF-1739353.test sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test Branch: unlock Log Message: approved output diffs (61 lines): diff --git a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test --- a/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test +++ b/sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test @@ -7,9 +7,9 @@ PLAN copy into cm_tmp from '/file1','/fi insert( | table(sys.cm_tmp) [ "cm_tmp"."i", "cm_tmp"."%TID%" NOT NULL ] COUNT | union ( -| | table (sys.copyfrom(table(cm_tmp), varchar "|", varchar "\n", varchar "NULL", varchar "null", varchar "/file1", bigint "-1", bigint "0", int "0", int "0", varchar "NULL", int "0", int "1"), +| | table (sys.copyfrom(table(cm_tmp), varchar "|", varchar "\n", varchar "NULL", varchar "null", varchar "/file1", bigint "-1", bigint "0", int "0", varchar "NULL", int "0", int "1"), | | ) [ "cm_tmp"."i" ] COUNT , -| | table (sys.copyfrom(table(cm_tmp), varchar "|", varchar "\n", varchar "NULL", varchar "null", varchar "/file2", bigint "-1", bigint "0", int "0", int "0", varchar "NULL", int "0", int "1"), +| | table (sys.copyfrom(table(cm_tmp), varchar "|", varchar "\n", varchar "NULL", varchar "null", varchar "/file2", bigint "-1", bigint "0", int "0", varchar "NULL", int "0", int "1"), | | ) [ "cm_tmp"."i" ] COUNT | ) [ int "NULL" ] ) diff --git a/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.test b/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.test --- a/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.test +++ b/sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.test @@ -13,7 +13,7 @@ insert into x (n,s) values (3, 'three') query ITITITT rowsort select * from tables, x limit 10 -110 values hashing to c3f43cf8d27b7912a24b1c87a5eee1c1 +110 values hashing to b6759b8f71ff5e5676c80d2568f19463 statement ok drop table x cascade diff --git a/sql/test/BugTracker/Tests/explain.SF-1739353.test b/sql/test/BugTracker/Tests/explain.SF-1739353.test --- a/sql/test/BugTracker/Tests/explain.SF-1739353.test +++ b/sql/test/BugTracker/Tests/explain.SF-1739353.test @@ -13,11 +13,11 @@ 1 sql.mvc 1 sql.bind -7 +5 sql.tid 2 algebra.thetaselect -3 +2 sql.subdelta 1 sql.projectdelta diff --git a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test --- a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test +++ b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.test @@ -35,11 +35,11 @@ 1 sql.mvc 1 sql.bind -3 +2 sql.tid 2 algebra.thetaselect -3 +2 sql.subdelta 1 aggr.count ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: ac86389e4b3c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ac86389e4b3c Modified Files: sql/test/mergetables/Tests/mergequery.stable.out Branch: unlock Log Message: approved output diffs (truncated from 417 to 300 lines): diff --git a/sql/test/mergetables/Tests/mergequery.stable.out b/sql/test/mergetables/Tests/mergequery.stable.out --- a/sql/test/mergetables/Tests/mergequery.stable.out +++ b/sql/test/mergetables/Tests/mergequery.stable.out @@ -55,7 +55,7 @@ stdout of test 'mergequery` in directory [ 2, 1, 0 ] [ 3, 1, 0 ] #SELECT * FROM complete where x>=0.0 AND x <=1.0; -% .complete, .complete, .complete # table_name +% sys.complete,sys.complete, sys.complete # table_name % x, y, z # name % double, double, double # type % 24, 24, 24 # length @@ -64,7 +64,7 @@ stdout of test 'mergequery` in directory [ 0, 1, 0 ] [ 1, 1, 0 ] #SELECT * FROM complete where x>=2.0 AND x <=3.0; -% .complete, .complete, .complete # table_name +% sys.complete,sys.complete, sys.complete # table_name % x, y, z # name % double, double, double # type % 24, 24, 24 # length @@ -72,7 +72,107 @@ stdout of test 'mergequery` in directory [ 3, 0, 0 ] [ 2, 1, 0 ] [ 3, 1, 0 ] -#SELECT * FROM complete where x>=1.0 AND x <=2.0; +#PLAN SELECT * FROM complete where x = 0.0; --only part1 passes +% .plan # table_name +% rel # name +% clob # type +% 78 # length +project ( +| select ( +| | table(sys.part1) [ "complete"."x", "complete"."y", "complete"."z" ] COUNT +| ) [ "complete"."x" = double(53,1) "0" ] +) [ "complete"."x", "complete"."y", "complete"."z" ] +#SELECT * FROM complete where x = 0.0; +% sys.complete,sys.complete, sys.complete # table_name +% x, y, z # name +% double, double, double # type +% 24, 24, 24 # length +[ 0, 0, 0 ] +[ 0, 1, 0 ] +#PLAN SELECT * FROM complete where x = 3.0; --only part2 passes +% .plan # table_name +% rel # name +% clob # type +% 78 # length +project ( +| select ( +| | table(sys.part2) [ "complete"."x", "complete"."y", "complete"."z" ] COUNT +| ) [ "complete"."x" = double(53,1) "3" ] +) [ "complete"."x", "complete"."y", "complete"."z" ] +#SELECT * FROM complete where x = 3.0; +% sys.complete,sys.complete, sys.complete # table_name +% x, y, z # name +% double, double, double # type +% 24, 24, 24 # length +[ 3, 0, 0 ] +[ 3, 1, 0 ] +#PLAN SELECT * FROM complete where x >= 1.0 AND x < 2.0; --only part1 passes +% .plan # table_name +% rel # name +% clob # type +% 78 # length +project ( +| select ( +| | table(sys.part1) [ "complete"."x", "complete"."y", "complete"."z" ] COUNT +| ) [ double(53,1) "1" <= "complete"."x" < double(53,1) "2" BETWEEN ] +) [ "complete"."x", "complete"."y", "complete"."z" ] +#SELECT * FROM complete where x >= 1.0 AND x < 2.0; +% sys.complete,sys.complete, sys.complete # table_name +% x, y, z # name +% double, double, double # type +% 24, 24, 24 # length +[ 1, 0, 0 ] +[ 1, 1, 0 ] +#PLAN SELECT * FROM complete where x > 1.0 AND x <= 2.0; --only part2 passes +% .plan # table_name +% rel # name +% clob # type +% 78 # length +project ( +| select ( +| | table(sys.part2) [ "complete"."x", "complete"."y", "complete"."z" ] COUNT +| ) [ double(53,1) "1" < "complete"."x" <= double(53,1) "2" BETWEEN ] +) [ "complete"."x", "complete"."y", "complete"."z" ] +#SELECT * FROM complete where x > 1.0 AND x <= 2.0; +% sys.complete,sys.complete, sys.complete # table_name +% x, y, z # name +% double, double, double # type +% 24, 24, 24 # length +[ 2, 0, 0 ] +[ 2, 1, 0 ] +#PLAN SELECT * FROM complete where x > 1.0 AND x < 2.0; --no part passes +% .plan # table_name +% rel # name +% clob # type +% 103 # length +project ( +| select ( +| | [ boolean "true" ] +| ) [ boolean "false" ] +) [ double "NULL" as "complete"."x", double "NULL" as "complete"."y", double "NULL" as "complete"."z" ] +#SELECT * FROM complete where x > 1.0 AND x < 2.0; +% .complete, .complete, .complete # table_name +% x, y, z # name +% double, double, double # type +% 24, 24, 24 # length +#PLAN SELECT * FROM complete where x >= 1.0 AND x <= 2.0; +% .plan # table_name +% rel # name +% clob # type +% 125 # length +union ( +| project ( +| | select ( +| | | table(sys.part1) [ "part1"."x" as "complete"."x", "part1"."y" as "complete"."y", "part1"."z" as "complete"."z" ] COUNT +| | ) [ double(53,1) "1" <= "complete"."x" <= double(53,1) "2" BETWEEN ] +| ) [ "complete"."x", "complete"."y", "complete"."z" ], +| project ( +| | select ( +| | | table(sys.part2) [ "part2"."x" as "complete"."x", "part2"."y" as "complete"."y", "part2"."z" as "complete"."z" ] COUNT +| | ) [ double(53,1) "1" <=
MonetDB: unlock - approved output
Changeset: 360f9a6b8ede for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=360f9a6b8ede
Modified Files:
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: unlock
Log Message:
approved output
diffs (89 lines):
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -1341,6 +1341,7 @@ create function timestamp_to_str(d times
create function sys.tracelog() returns table (ticks bigint, stmt string)
external name sql.dump_trace;
create function sys.user_statistics() returns table(username string,
querycount bigint, totalticks bigint, started timestamp, finished timestamp,
maxticks bigint, maxquery string) external name sysmon.user_statistics;
create function sys.uuid() returns uuid external name uuid."new";
+create function sys.uuid(d int) returns uuid external name uuid."new";
create function "sys"."var"() returns table("schema" string, "name" string,
"type" string, "value" string) external name "sql"."sql_variables";
create aggregate var_pop(val bigint) returns double external name
"aggr"."variancep";
create aggregate var_pop(val double) returns double external name
"aggr"."variancep";
@@ -3482,6 +3483,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "upper","SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0","varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL]
[ "sys.functions", "sys", "user_statistics", "SYSTEM", "create
function sys.user_statistics() returns table(username string, querycount
bigint, totalticks bigint, started timestamp, finished timestamp, maxticks
bigint, maxquery string) external name sysmon.user_statistics;","sysmon",
"MAL", "Function returning a table", true, false, false, true,
"username", "clob", 0, 0, "out", "querycount", "bigint",
64, 0, "out", "totalticks", "bigint", 64, 0, "out",
"started", "timestamp",7, 0, "out", "finished",
"timestamp",7, 0, "out", "maxticks", "bigint", 64,
0, "out", "maxquery", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL]
[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, "result", "uuid", 0,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL]
+[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, "result", "uuid",
0, 0, "out", "d","int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
MonetDB: unlock - approved output
Changeset: ce9eb53feb59 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ce9eb53feb59 Modified Files: sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out.Windows Branch: unlock Log Message: approved output diffs (24 lines): diff --git a/sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out b/sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out --- a/sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out +++ b/sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out @@ -24,7 +24,7 @@ Checking 13 foreign keys in schema t Checking 35 columns in schema tmp for Not Null violations. Checking 14 columns in schema tmp for Max Character Length violations. \vsi sys -Checking 10 keys in schema sys for Primary Key uniqueness violations. +Checking 11 keys in schema sys for Primary Key uniqueness violations. Checking 7 keys in schema sys for Unique Constraint violations. Checking 0 foreign keys in schema sys for Foreign Key referential integrity violations. Checking 29 columns in schema sys for Not Null violations. diff --git a/sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out.Windows b/sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out.Windows --- a/sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out.Windows +++ b/sql/jdbc/tests/Tests/ValidateSystemCatalogTables.stable.out.Windows @@ -24,7 +24,7 @@ Checking 13 foreign keys in schema t Checking 35 columns in schema tmp for Not Null violations. Checking 14 columns in schema tmp for Max Character Length violations. \vsi sys -Checking 10 keys in schema sys for Primary Key uniqueness violations. +Checking 11 keys in schema sys for Primary Key uniqueness violations. Checking 7 keys in schema sys for Unique Constraint violations. Checking 0 foreign keys in schema sys for Foreign Key referential integrity violations. Checking 29 columns in schema sys for Not Null violations. ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: unlock - approved output
Changeset: 87d83f555791 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=87d83f555791
Modified Files:
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
Branch: unlock
Log Message:
approved output
diffs (100 lines):
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
@@ -71,19 +71,19 @@ end user.main;
% clob # type
% 189 # length
function user.main():void;
-X_1:void := querylog.define("explain select id from fk left outer join pk1
on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by id;":str,
"sequential_pipe":str, 19:int);
-X_27:bat[:str] := bat.pack("sys.fk":str);
-X_28:bat[:str] := bat.pack("id":str);
-X_29:bat[:str] := bat.pack("int":str);
-X_30:bat[:int] := bat.pack(32:int);
-X_31:bat[:int] := bat.pack(0:int);
+X_1:void := querylog.define("explain select id from fk left outer join pk1
on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by id;":str,
"sequential_pipe":str, 27:int);
+X_39:bat[:str] := bat.pack("sys.fk":str);
+X_40:bat[:str] := bat.pack("id":str);
+X_41:bat[:str] := bat.pack("int":str);
+X_42:bat[:int] := bat.pack(32:int);
+X_43:bat[:int] := bat.pack(0:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str);
X_15:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int);
-X_19:bat[:int] := algebra.projection(C_5:bat[:oid], X_15:bat[:int]);
-(X_20:bat[:int], X_21:bat[:oid]) := algebra.sort(X_19:bat[:int],
false:bit, false:bit, false:bit);
-X_25:bat[:int] := algebra.projection(X_21:bat[:oid], X_19:bat[:int]);
-sql.resultSet(X_27:bat[:str], X_28:bat[:str], X_29:bat[:str],
X_30:bat[:int], X_31:bat[:int], X_25:bat[:int]);
+X_29:bat[:int] := algebra.projection(C_5:bat[:oid], X_15:bat[:int]);
+(X_32:bat[:int], X_33:bat[:oid]) := algebra.sort(X_29:bat[:int],
false:bit, false:bit, false:bit);
+X_37:bat[:int] := algebra.projection(X_33:bat[:oid], X_29:bat[:int]);
+sql.resultSet(X_39:bat[:str], X_40:bat[:str], X_41:bat[:str],
X_42:bat[:int], X_43:bat[:int], X_37:bat[:int]);
end user.main;
#inline actions= 0 time=1 usec
#remapactions= 0 time=2 usec
@@ -117,39 +117,39 @@ end user.main;
% clob # type
% 194 # length
function user.main():void;
-X_1:void := querylog.define("explain select id , v1 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by
id;":str, "sequential_pipe":str, 58:int);
-X_48:bat[:int] := bat.new(nil:int);
+X_1:void := querylog.define("explain select id , v1 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by
id;":str, "sequential_pipe":str, 67:int);
+X_54:bat[:int] := bat.new(nil:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str);
X_19:bat[:oid] := sql.bind_idxbat(X_4:int, "sys":str, "fk":str,
"fk_fk1_fkey":str, 0:int);
(X_21:bat[:oid], X_22:bat[:oid]) := sql.bind_idxbat(X_4:int, "sys":str,
"fk":str, "fk_fk1_fkey":str, 2:int);
X_23:bat[:oid] := sql.delta(X_19:bat[:oid], X_21:bat[:oid],
X_22:bat[:oid]);
-X_37:bat[:oid] := algebra.projection(C_5:bat[:oid], X_23:bat[:oid]);
-C_24:bat[:oid] := sql.tid(X_4:int, "sys":str, "pk1":str);
-(X_39:bat[:oid], X_40:bat[:oid]) := algebra.join(X_37:bat[:oid],
C_24:bat[:oid], nil:BAT, nil:BAT, false:bit, nil:lng);
+X_42:bat[:oid] := algebra.projection(C_5:bat[:oid], X_23:bat[:oid]);
+C_29:bat[:oid] := sql.tid(X_4:int, "sys":str, "pk1":str);
+(X_45:bat[:oid], X_46:bat[:oid]) := algebra.join(X_42:bat[:oid],
C_29:bat[:oid], nil:BAT, nil:BAT, false:bit, nil:lng);
X_15:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int);
-X_36:bat[:int] := algebra.projection(C_5:bat[:oid], X_15:bat[:int]);
-X_47:bat[:int] := algebra.projection(X_39:bat[:oid], X_36:bat[:int]);
-C_45:bat[:oid] := bat.mirror(X_36:bat[:int]);
-C_46:bat[:oid] := algebra.difference(C_45:bat[:oid], X_39:bat[:oid],
nil:BAT, nil:BAT, false:bit, false:bit, nil:lng);
-X_31:bat[:int] := sql.bind(X_4:int, "sys":str, "pk1":str, "v1":str, 0:int);
-X_50:bat[:int] := bat.append(X_48:bat[:int], X_47:bat[:int], true:bit);
-X_52:bat[:int] := algebra.projection(C_46:bat[:oid], X_36:bat[:int]);
-X_53:bat[:int] := bat.append(X_50:bat[:int], X_52:bat[:int], true:bit);
-X_61:bat[:int] := bat.new(nil:int);
-X_60:bat[:int] := algebra.projectionpath(X_40:bat[:oid],
MonetDB: unlock - approved output
Changeset: 76a08453400a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=76a08453400a Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out sql/test/SQLancer/Tests/sqlancer01.stable.out sql/test/miscellaneous/Tests/groupby_error.stable.out Branch: unlock Log Message: approved output diffs (truncated from 3274 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -257,15 +257,15 @@ stdout of test 'MAL-signatures` in direc [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_1:bat[:str], X_2:bat[:str], X_3:bat[:cnd], X_4:bit):str ", "CMDBATstr_group_concat;", "" ] [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_1:bat[:str], X_2:bat[:str], X_3:bit):str ", "CMDBATstr_group_concat;", "" ] [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(X_1:bat[:str], X_2:bit):str ", "CMDBATstr_group_concat;", "" ] -[ "aggr", "suball", "pattern aggr.suball(X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:cnd], X_5:bit):bat[:any_1] ", "SQLall_grp;", "" ] +[ "aggr", "suball", "pattern aggr.suball(X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:any_1] ", "SQLall_grp;", "" ] [ "aggr", "suball", "pattern aggr.suball(X_1:bat[:any_1], X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:any_1] ", "SQLall_grp;", "" ] -[ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bat[:cnd], X_7:bit):bat[:bit] ", "SQLallnotequal_grp2;", "" ] +[ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bat[:oid], X_7:bit):bat[:bit] ", "SQLallnotequal_grp2;", "" ] [ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bit):bat[:bit] ", "SQLallnotequal_grp2;", "" ] -[ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:cnd], X_6:bit):bat[:bit] ", "SQLallnotequal_grp;", "" ] +[ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bit):bat[:bit] ", "SQLallnotequal_grp;", "" ] [ "aggr", "suballnotequal", "pattern aggr.suballnotequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ", "SQLallnotequal_grp;", "" ] -[ "aggr", "subanyequal", "pattern aggr.subanyequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bat[:cnd], X_7:bit):bat[:bit] ", "SQLanyequal_grp2;","" ] +[ "aggr", "subanyequal", "pattern aggr.subanyequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bat[:oid], X_7:bit):bat[:bit] ", "SQLanyequal_grp2;","" ] [ "aggr", "subanyequal", "pattern aggr.subanyequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bit):bat[:bit] ", "SQLanyequal_grp2;","" ] -[ "aggr", "subanyequal", "pattern aggr.subanyequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:cnd], X_6:bit):bat[:bit] ", "SQLanyequal_grp;", "" ] +[ "aggr", "subanyequal", "pattern aggr.subanyequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bat[:oid], X_6:bit):bat[:bit] ", "SQLanyequal_grp;", "" ] [ "aggr", "subanyequal", "pattern aggr.subanyequal(X_1:bat[:any_1], X_2:bat[:any_1], X_3:bat[:oid], X_4:bat[:oid], X_5:bit):bat[:bit] ", "SQLanyequal_grp;", "" ] [ "aggr", "subavg", "command aggr.subavg(X_3:bat[:bte], X_4:bat[:oid], X_5:bat[:any_1], X_6:bat[:cnd], X_7:bit) (X_0:bat[:bte], X_1:bat[:lng], X_2:bat[:lng]) ","AGGRavg3;","" ] [ "aggr", "subavg", "command aggr.subavg(X_3:bat[:int], X_4:bat[:oid], X_5:bat[:any_1], X_6:bat[:cnd], X_7:bit) (X_0:bat[:int], X_1:bat[:lng], X_2:bat[:lng]) ","AGGRavg3;","" ] @@ -361,7 +361,7 @@ stdout of test 'MAL-signatures` in direc [ "aggr", "subcovariancep", "command aggr.subcovariancep(X_1:bat[:int], X_2:bat[:int], X_3:bat[:oid], X_4:bat[:any_1], X_5:bat[:cnd], X_6:bit, X_7:bit):bat[:dbl] ",
MonetDB: unlock - approved output
Changeset: d6c4112c87ef for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d6c4112c87ef
Modified Files:
clients/Tests/exports.stable.out
monetdb5/optimizer/Tests/inline08.stable.out
sql/backends/monet5/rel_bin.c
sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
sql/test/BugTracker-2015/Tests/readonly.Bug-3709.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
Branch: unlock
Log Message:
approved output
diffs (truncated from 454 to 300 lines):
diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -205,7 +205,7 @@ void BATundo(BAT *b);
BAT *BATunique(BAT *b, BAT *s);
BAT *BATunmask(BAT *b);
BBPrec *BBP[N_BBPINIT];
-gdk_return BBPaddfarm(const char *dirname, int rolemask, bool logerror);
+gdk_return BBPaddfarm(const char *dirname, uint32_t rolemask, bool logerror);
void BBPclear(bat bid);
BAT *BBPdescriptor(bat b);
int BBPfix(bat b);
@@ -285,7 +285,7 @@ gdk_return GDKgetsem(int sem_id, int cou
gdk_return GDKgetsemval(int sem_id, int number, int *semval);
gdk_return GDKinit(struct opt *set, int setlen, bool embedded);
void *GDKinitmmap(size_t id, size_t size, size_t *return_size);
-bool GDKinmemory(void);
+bool GDKinmemory(int farmid);
ATOMIC_TYPE GDKlockcnt;
ATOMIC_TYPE GDKlockcontentioncnt;
MT_Lock *volatile GDKlocklist;
diff --git a/monetdb5/optimizer/Tests/inline08.stable.out
b/monetdb5/optimizer/Tests/inline08.stable.out
--- a/monetdb5/optimizer/Tests/inline08.stable.out
+++ b/monetdb5/optimizer/Tests/inline08.stable.out
@@ -31,8 +31,25 @@ stdout of test 'inline08` in directory '
function user.qry():void; #[0] (0) 0
b:bat[:str] := bat.new(:str); #[1] (0) CMDBATnew 1 <- 2
bat.append(b:bat[:str], "1":str); #[2] (0) BKCappend_val_wrap 3
<- 1 4
-z:bat[:str] := mal.multiplex("user":str, "bar":str, b:bat[:str],
b:bat[:str]); #[3] (0) MANIFOLDremapMultiplex 5 <- 6 7 1 1
-end user.qry; #[4] (0)
+b:bat[:str] := batstr.replace(b:bat[:str], "A":str, "":str); #[1]
(0) STRbatReplacecst 1 <- 1 17 18
+b:bat[:str] := batstr.replace(b:bat[:str], "E":str, "":str); #[2]
(0) STRbatReplacecst 1 <- 1 19 18
+b:bat[:str] := batstr.replace(b:bat[:str], "I":str, "":str); #[3]
(0) STRbatReplacecst 1 <- 1 20 18
+b:bat[:str] := batstr.replace(b:bat[:str], "O":str, "":str); #[4]
(0) STRbatReplacecst 1 <- 1 21 18
+b:bat[:str] := batstr.replace(b:bat[:str], "U":str, "":str); #[5]
(0) STRbatReplacecst 1 <- 1 22 18
+b:bat[:str] := batstr.replace(b:bat[:str], " ":str, "":str); #[6]
(0) STRbatReplacecst 1 <- 1 23 18
+X_9:bat[:str] := b:bat[:str]; #[7] (0) 12 <- 1
+b:bat[:str] := batstr.replace(b:bat[:str], "A":str, "":str); #[1]
(0) STRbatReplacecst 1 <- 1 17 18
+b:bat[:str] := batstr.replace(b:bat[:str], "E":str, "":str); #[2]
(0) STRbatReplacecst 1 <- 1 19 18
+b:bat[:str] := batstr.replace(b:bat[:str], "I":str, "":str); #[3]
(0) STRbatReplacecst 1 <- 1 20 18
+b:bat[:str] := batstr.replace(b:bat[:str], "O":str, "":str); #[4]
(0) STRbatReplacecst 1 <- 1 21 18
+b:bat[:str] := batstr.replace(b:bat[:str], "U":str, "":str); #[5]
(0) STRbatReplacecst 1 <- 1 22 18
+b:bat[:str] := batstr.replace(b:bat[:str], " ":str, "":str); #[6]
(0) STRbatReplacecst 1 <- 1 23 18
+X_10:bat[:str] := b:bat[:str]; #[7] (0) 13 <- 1
+X_11:bat[:str] := batcalc.+(X_9:bat[:str], X_10:bat[:str], nil:BAT,
nil:BAT); #[3] (0) CMDbatADD 14 <- 12 13 28 29
+z:bat[:str] := X_11:bat[:str]; #[4] (0) 5 <- 14
+end user.qry; #[19] (0)
+#inline actions= 0 time=3 usec
+#remapactions= 1 time=153 usec
# 20:02:17 >
# 20:02:17 > Done.
diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c
--- a/sql/backends/monet5/rel_bin.c
+++ b/sql/backends/monet5/rel_bin.c
@@ -3971,7 +3971,7 @@ rel2bin_insert(backend *be, sql_rel *rel
stmt *is = m->data;
sql_idx *i = n->data;
- if (non_updatable_index(i->type)) /* Some indexes don't
hold delta structures */
+ if (non_updatable_index(i->type)) /* Some indexes don't
hold delta structures */
MonetDB: unlock - approved output
Changeset: cdd28583a243 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cdd28583a243
Modified Files:
sql/benchmarks/nobench/Tests/nobench.stable.err
sql/benchmarks/nobench/Tests/nobench.stable.out
sql/test/BugTracker-2012/Tests/case_evaluated_too_early.Bug-3186.stable.out
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
sql/test/BugTracker-2015/Tests/readonly.Bug-3709.stable.out
sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.stable.out
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
sql/test/SQLancer/Tests/sqlancer01.stable.err
sql/test/SQLancer/Tests/sqlancer01.stable.out
sql/test/analytics/Tests/analytics14.stable.err
sql/test/analytics/Tests/analytics14.stable.out
sql/test/mergetables/Tests/part-elim.stable.out
sql/test/miscellaneous/Tests/groupby_error.stable.out
sql/test/remote/Tests/partition_elim.stable.out
sql/test/subquery/Tests/correlated.stable.err
sql/test/subquery/Tests/correlated.stable.out
sql/test/sysmon/Tests/sys_queue_expand.stable.out
Branch: unlock
Log Message:
approved output
diffs (truncated from 2451 to 300 lines):
diff --git a/sql/benchmarks/nobench/Tests/nobench.stable.err
b/sql/benchmarks/nobench/Tests/nobench.stable.err
--- a/sql/benchmarks/nobench/Tests/nobench.stable.err
+++ b/sql/benchmarks/nobench/Tests/nobench.stable.err
@@ -30,7 +30,7 @@ stderr of test 'nobench` in directory 's
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = select cast(json.text(json.filter(js,'dyn1')) as integer) from bench10;
-ERROR = !conversion of string 'GBRDA===' to type int failed.
+ERROR = !conversion of string to type int failed.
CODE = 22018
diff --git a/sql/benchmarks/nobench/Tests/nobench.stable.out
b/sql/benchmarks/nobench/Tests/nobench.stable.out
--- a/sql/benchmarks/nobench/Tests/nobench.stable.out
+++ b/sql/benchmarks/nobench/Tests/nobench.stable.out
@@ -62,7 +62,7 @@ stdout of test 'nobench` in directory 's
% 2 # length
[ 10 ]
#select json.filter(js, '$..str1,$..num') from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% json # type
% 24 # length
@@ -77,7 +77,7 @@ stdout of test 'nobench` in directory 's
[ "[\"GBRDA===\",5,0]" ]
[ "[\"GBRDCMJQ\",1,6]" ]
#select json.filter(js,'.nested_obj.str,.nested_obj.num') from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% json # type
% 22 # length
@@ -92,7 +92,7 @@ stdout of test 'nobench` in directory 's
[ "[\"GBRDCMBR\",5]" ]
[ "[\"GBRDC===\",1]" ]
#select json.filter(js,'..sparse_000,..sparse_001') from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% json # type
% 23 # length
@@ -107,7 +107,7 @@ stdout of test 'nobench` in directory 's
[ "[\"GBRDA===\",\"GBRDA===\"]"]
[ "[]" ]
#select json.filter(js,'..sparse_000,..sparse_110') from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% json # type
% 12 # length
@@ -122,7 +122,7 @@ stdout of test 'nobench` in directory 's
[ "[\"GBRDA===\"]" ]
[ "[]" ]
#select json.filter(js,'str1') from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% json # type
% 20 # length
@@ -137,7 +137,7 @@ stdout of test 'nobench` in directory 's
[ "[\"GBRDA===\"]" ]
[ "[\"GBRDCMJQ\"]" ]
#select json.text(json.filter(js,'str1')) from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% clob # type
% 16 # length
@@ -158,7 +158,7 @@ stdout of test 'nobench` in directory 's
% 462 # length
[ "{\"nested_obj\": {\"num\": 0, \"str\": \"GBRDA===\"}, \"dyn2\": 5,
\"dyn1\": 5, \"nested_arr\": [\"the\", \"state\", \"aware\", \"''\", \"the\"],
\"str2\": \"GBRDA===\", \"str1\": \"GBRDCMBR\", \"sparse_058\": \"GBRDCMBR\",
\"thousandth\": 5, \"num\": 5, \"bool\": true, \"sparse_059\": \"GBRDCMBR\",
\"sparse_054\": \"GBRDCMBR\", \"sparse_055\": \"GBRDCMBR\", \"sparse_056\":
\"GBRDCMBR\", \"sparse_057\": \"GBRDCMBR\", \"sparse_050\": \"GBRDCMBR\",
\"sparse_051\": \"GBRDCMBR\", \"sparse_052\": \"GBRDCMBR\", \"sparse_053\":
\"GBRDCMBR\"}" ]
#select json.number(json.filter(js,'num')) from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% double # type
% 24 # length
@@ -173,7 +173,7 @@ stdout of test 'nobench` in directory 's
[ 0]
[ 6]
#select json."integer"(json.filter(js,'num')) from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% bigint # type
% 1 # length
@@ -188,7 +188,7 @@ stdout of test 'nobench` in directory 's
[ 0]
[ 6]
#select cast(json.text(json.filter(js,'num')) as integer) from bench10;
-% sys. # table_name
+% sys.%1 # table_name
% %1 # name
% int # type
% 1 # length
@@ -212,7 +212,7 @@ stdout of test 'nobench` in directory 's
[ "{\"nested_obj\": {\"num\": 7, \"str\": \"GBRDCMJR\"}, \"dyn2\": 2,
\"dyn1\": 2, \"nested_arr\":
MonetDB: unlock - approved output
Changeset: b27e5db78428 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b27e5db78428
Modified Files:
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
sql/test/BugTracker-2015/Tests/readonly.Bug-3709.stable.err
sql/test/BugTracker-2015/Tests/readonly.Bug-3709.stable.out
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.stable.out
sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.stable.out
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
sql/test/mapi/Tests/sql_int128.stable.out.int128
sql/test/mergetables/Tests/mergequery.stable.out
sql/test/mergetables/Tests/part-elim.stable.out
sql/test/miscellaneous/Tests/groupby_error.stable.out
sql/test/remote/Tests/partition_elim.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: unlock
Log Message:
approved output
diffs (truncated from 5335 to 300 lines):
diff --git
a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
--- a/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
+++ b/monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
@@ -60,28 +60,25 @@ stdout of test 'opt_sql_append` in direc
% mal # name
% clob # type
% 245 # length
-function user.s10_0():void;
-X_1:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';":str, "sequential_pipe":str, 22:int);
+function user.main():void;
+X_1:void := querylog.define("explain copy into ttt from
\\'/tmp/xyz\\';":str, "sequential_pipe":str, 21:int);
X_4:int := sql.mvc();
-(X_25:bat[:int], X_26:bat[:int], X_27:bat[:int]) :=
sql.copy_from(0x7f75841ad000:ptr, "|":str, "\n":str, nil:str, "null":str,
"/tmp/xyz":str, -1:lng, 0:lng, 0:int, nil:str, 0:int);
+(X_25:bat[:int], X_26:bat[:int], X_27:bat[:int]) :=
sql.copy_from(0x7fc2ec1d9ad0:ptr, "|":str, "\n":str, nil:str, "null":str,
"/tmp/xyz":str, -1:lng, 0:lng, 0:int, nil:str, 0:int);
X_28:lng := aggr.count(X_25:bat[:int]);
X_29:lng := sql.claim(X_4:int, "sys":str, "ttt":str, X_28:lng);
X_33:int := sql.append(X_4:int, "sys":str, "ttt":str,
"averylongcolumnnametomakeitlargee":str,
X_29:lng, X_25:bat[:int]);
X_36:int := sql.append(X_33:int, "sys":str, "ttt":str, "b":str, X_29:lng,
X_26:bat[:int]);
X_39:int := sql.append(X_36:int, "sys":str, "ttt":str, "c":str, X_29:lng,
X_27:bat[:int]);
sql.affectedRows(X_39:int, X_28:lng);
-end user.s10_0;
-#inline actions= 0 time=1 usec
-#candidates actions= 1 time=14 usec
-#remapactions= 0 time=3 usec
-#costModelactions= 1 time=12 usec
-#coercionsactions=10 time=13 usec
-#evaluate actions= 0 time=2 usec
-#emptybindactions= 0 time=4 usec
-#pushselect actions= 0 time=3 usec
-#aliases actions= 0 time=0 usec
-#mergetable actions= 0 time=10 usec
-#deadcode actions= 0 time=2 usec
+end user.main;
+#inline actions= 0 time=0 usec
+#remapactions= 0 time=1 usec
+#costmodelactions= 1 time=1 usec
+#coercion actions= 0 time=1 usec
+#aliases actions=11 time=4 usec
+#evaluate actions= 0 time=3 usec
+#emptybindactions= 0
MonetDB: unlock - approved output
Changeset: bc095a8c2376 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bc095a8c2376
Modified Files:
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
Branch: unlock
Log Message:
approved output
diffs (48 lines):
diff --git
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
---
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
+++
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
@@ -40,9 +40,9 @@ function user.s4_0():void;
X_1249:bat[:int] := bat.pack(0:int);
X_184:bat[:timestamp] := bat.new(nil:timestamp);
X_196:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "1999-10-31
09:00:00.00":timestamp, "2000-04-02 10:00:00.00":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
-X_200:bat[:timestamp] := mal.manifold("mtime":str,
"timestamp_add_msec_interval":str, X_184:bat[:timestamp], -2880:lng);
+X_200:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_184:bat[:timestamp], -2880:lng);
X_215:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "2000-04-02
10:00:00.00":timestamp, "2000-10-29 09:00:00.00":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
-X_219:bat[:timestamp] := mal.manifold("mtime":str,
"timestamp_add_msec_interval":str, X_184:bat[:timestamp], -2520:lng);
+X_219:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_184:bat[:timestamp], -2520:lng);
X_233:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "2000-10-29
09:00:00.00":timestamp, "2001-04-01 10:00:00.00":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
X_254:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "2001-04-01
10:00:00.00":timestamp, "2001-10-28 09:00:00.00":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
X_272:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "2001-10-28
09:00:00.00":timestamp, "2002-04-07 10:00:00.00":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
@@ -134,7 +134,7 @@ function user.s4_0():void;
X_1235:bat[:timestamp] := batcalc.ifthenelse(X_215:bat[:bit],
X_219:bat[:timestamp], X_1232:bat[:timestamp]);
X_1237:bat[:timestamp] := batcalc.ifthenelse(X_196:bat[:bit],
X_200:bat[:timestamp], X_1235:bat[:timestamp]);
X_1238:bat[:timestamp] := batcalc.timestamp(X_1237:bat[:timestamp], 7:int);
-X_1242:bat[:str] := mal.manifold("mtime":str, "timestamp_to_str":str,
X_1238:bat[:timestamp], "%Y":str);
+X_1242:bat[:str] := batmtime.timestamp_to_str(X_1238:bat[:timestamp],
"%Y":str);
sql.resultSet(X_1246:bat[:str], X_1247:bat[:str], X_1248:bat[:str],
X_1249:bat[:int], X_1249:bat[:int], X_1242:bat[:str]);
end user.s4_0;
#inline actions= 0 time=24 usec
diff --git
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
---
a/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
+++
b/sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
@@ -40,9 +40,9 @@ function user.s4_0():void;
X_1249:bat[:int] := bat.pack(0:int);
X_184:bat[:timestamp] := bat.new(nil:timestamp);
X_196:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "1999-10-31
09:00:00.00":timestamp, "2000-04-02 10:00:00.00":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
-X_200:bat[:timestamp] := mal.manifold("mtime":str,
"timestamp_add_msec_interval":str, X_184:bat[:timestamp], -2880:lng);
+X_200:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_184:bat[:timestamp], -2880:lng);
X_215:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "2000-04-02
10:00:00.00":timestamp, "2000-10-29 09:00:00.00":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
-X_219:bat[:timestamp] := mal.manifold("mtime":str,
"timestamp_add_msec_interval":str, X_184:bat[:timestamp], -2520:lng);
+X_219:bat[:timestamp] :=
batmtime.timestamp_add_msec_interval(X_184:bat[:timestamp], -2520:lng);
X_233:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "2000-10-29
09:00:00.00":timestamp, "2001-04-01 10:00:00.00":timestamp, false:bit,
true:bit, false:bit, false:bit, false:bit);
X_254:bat[:bit] := batcalc.between(X_184:bat[:timestamp], "2001-04-01
10:00:00.00":timestamp, "2001-10-28 09:00:00.00":timestamp, false:bit,
true:bit, false:bit,
MonetDB: unlock - approved output
Changeset: fd9f2a5d342c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fd9f2a5d342c Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 Branch: unlock Log Message: approved output diffs (150 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -64,7 +64,7 @@ stdout of test 'MAL-signatures` in direc % .%1, .%1,.%1,.%1,.%1 # table_name % module, function, signature, address,comment # name % clob,clob, clob, clob, clob # type -% 12, 28, 364,39, 874 # length +% 12, 28, 364,42, 874 # length [ "aggr", "allnotequal", "command aggr.allnotequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] [ "aggr", "anyequal", "pattern aggr.anyequal(l:any_1, r:any_1):bit ", "CMDvarEQ;","" ] [ "aggr", "anyequal", "command aggr.anyequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l return true, else if r has nil nil else false" ] @@ -11316,12 +11316,22 @@ stdout of test 'MAL-signatures` in direc [ "batmmath", "tanh", "pattern batmmath.tanh(x:bat[:flt], s:bat[:oid]):bat[:flt] ", "CMDscience_bat_tanh;", "" ] [ "batmmath", "tanh", "pattern batmmath.tanh(x:bat[:flt], s:bat[:oid], r:bat[:bit]):bat[:flt] ", "CMDscience_bat_tanh;", "" ] [ "batmtime", "addmonths","command batmtime.addmonths(value:bat[:date], months:bat[:int]):bat[:date] ", "MTIMEdate_addmonths_bulk;","" ] +[ "batmtime", "addmonths","command batmtime.addmonths(value:date, months:bat[:int]):bat[:date] ", "MTIMEdate_addmonths_bulk_p1;", "" ] +[ "batmtime", "addmonths","command batmtime.addmonths(value:bat[:date], months:int):bat[:date] ", "MTIMEdate_addmonths_bulk_p2;", "" ] [ "batmtime", "century", "command batmtime.century(d:bat[:date]):bat[:int] ", "MTIMEdate_extract_century_bulk;", "" ] [ "batmtime", "century", "command batmtime.century(t:bat[:timestamp]):bat[:int] ", "MTIMEtimestamp_century_bulk;", "" ] [ "batmtime", "date_add_msec_interval", "command batmtime.date_add_msec_interval(t:bat[:date], ms:bat[:lng]):bat[:date] ", "MTIMEdate_add_msec_interval_bulk;","" ] -[ "batmtime", "date_sub_month_interval", "command batmtime.date_sub_month_interval(value:bat[:date], months:bat[:int]):bat[:date] ", "MTIMEdate_submonths_bulk;","" ] +[ "batmtime", "date_add_msec_interval", "command batmtime.date_add_msec_interval(t:date, ms:bat[:lng]):bat[:date] ", "MTIMEdate_add_msec_interval_bulk_p1;", "" ] +[ "batmtime", "date_add_msec_interval", "command batmtime.date_add_msec_interval(t:bat[:date], ms:lng):bat[:date] ", "MTIMEdate_add_msec_interval_bulk_p2;", "" ] +[ "batmtime", "date_sub_month_interval", "command batmtime.date_sub_month_interval(t:bat[:date], months:bat[:int]):bat[:date] ", "MTIMEdate_submonths_bulk;","" ] +[ "batmtime", "date_sub_month_interval", "command batmtime.date_sub_month_interval(t:date, months:bat[:int]):bat[:date] ", "MTIMEdate_submonths_bulk_p1;", "" ] +[ "batmtime", "date_sub_month_interval", "command batmtime.date_sub_month_interval(t:bat[:date], months:int):bat[:date] ", "MTIMEdate_submonths_bulk_p2;", "" ] [ "batmtime", "date_sub_msec_interval", "command batmtime.date_sub_msec_interval(t:bat[:date], ms:bat[:lng]):bat[:date] ", "MTIMEdate_sub_msec_interval_bulk;","" ] +[ "batmtime", "date_sub_msec_interval", "command batmtime.date_sub_msec_interval(t:date, ms:bat[:lng]):bat[:date] ", "MTIMEdate_sub_msec_interval_bulk_p1;", "" ] +[ "batmtime", "date_sub_msec_interval", "command batmtime.date_sub_msec_interval(t:bat[:date], ms:lng):bat[:date] ", "MTIMEdate_sub_msec_interval_bulk_p2;", "" ] [ "batmtime", "date_to_str", "command batmtime.date_to_str(d:bat[:str], format:bat[:str]):bat[:str] ", "MTIMEdate_to_str_bulk;", "" ] +[ "batmtime", "date_to_str", "command batmtime.date_to_str(d:date, format:bat[:str]):bat[:str] ","MTIMEdate_to_str_bulk_p1;","" ] +[ "batmtime", "date_to_str", "command batmtime.date_to_str(d:bat[:date], format:str):bat[:str] ","MTIMEdate_to_str_bulk_p2;","" ] [ "batmtime", "day", "command batmtime.day(d:bat[:date]):bat[:int] ", "MTIMEdate_extract_day_bulk;", "" ] [ "batmtime", "day", "command batmtime.day(msecs:bat[:lng]):bat[:lng] ", "MTIMEsql_day_bulk;", "" ] [ "batmtime", "day", "command batmtime.day(t:bat[:timestamp]):bat[:int] ",
MonetDB: unlock - approved output
Changeset: 106a1b1e2388 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=106a1b1e2388 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/mapi/Tests/sql_int128.stable.out.int128 sql/test/sys-schema/Tests/systemfunctions.stable.out sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 Branch: unlock Log Message: approved output diffs (truncated from 664 to 300 lines): diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -64,7 +64,7 @@ stdout of test 'MAL-signatures` in direc % .%1, .%1,.%1,.%1,.%1 # table_name % module, function, signature, address,comment # name % clob,clob, clob, clob, clob # type -% 12, 28, 364,38, 874 # length +% 12, 28, 364,39, 874 # length [ "aggr", "allnotequal", "command aggr.allnotequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] [ "aggr", "anyequal", "pattern aggr.anyequal(l:any_1, r:any_1):bit ", "CMDvarEQ;","" ] [ "aggr", "anyequal", "command aggr.anyequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l return true, else if r has nil nil else false" ] @@ -718,6 +718,7 @@ stdout of test 'MAL-signatures` in direc [ "batalgebra","not_ilike","command batalgebra.not_ilike(s:bat[:str], pat:str, esc:str):bat[:bit] ", "BATPCREnotilike;", "" ] [ "batalgebra","not_like", "command batalgebra.not_like(s:bat[:str], pat:str):bat[:bit] ", "BATPCREnotlike2;", "" ] [ "batalgebra","not_like", "command batalgebra.not_like(s:bat[:str], pat:str, esc:str):bat[:bit] ", "BATPCREnotlike;", "" ] +[ "batblob", "nitems", "command batblob.nitems(b:bat[:blob]):bat[:int] ", "BLOBnitems_bulk;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(b1:bat[:any_1], b2:bat[:any_1]):bat[:bit] ","CMDbatNE;","Return B1 != B2" ] [ "batcalc", "!=", "pattern batcalc.!=(b1:bat[:any_1], b2:bat[:any_1], nil_matches:bit):bat[:bit] ", "CMDbatNE;","Return B1 != B2" ] [ "batcalc", "!=", "pattern batcalc.!=(b1:bat[:any_1], b2:bat[:any_1], r:bat[:bit]):bat[:bit] ", "CMDbatNE;","Return B1 != B2" ] @@ -8132,12 +8133,16 @@ stdout of test 'MAL-signatures` in direc [ "batcalc", "cmp", "pattern batcalc.cmp(v:str, b:bat[:str], r:bat[:bit]):bat[:bte] ", "CMDbatCMP;", "Return -1/0/1 if V B" ] [ "batcalc", "cmp", "pattern batcalc.cmp(v:str, b:bat[:str], s:bat[:oid]):bat[:bte] ", "CMDbatCMP;", "Return -1/0/1 if V B with candidates list" ] [ "batcalc", "cmp", "pattern batcalc.cmp(v:str, b:bat[:str], s:bat[:oid], r:bat[:bit]):bat[:bte] ", "CMDbatCMP;", "Return -1/0/1 if V B with candidates list" ] +[ "batcalc", "date", "command batcalc.date(d:bat[:date]):bat[:date] ", "MTIMEdate_date_bulk;", "" ] +[ "batcalc", "date", "command batcalc.date(s:bat[:str]):bat[:date] ", "MTIMEdate_fromstr_bulk;", "" ] [ "batcalc", "date", "command batcalc.date(t:bat[:timestamp]):bat[:date] ", "MTIMEtimestamp_extract_date_bulk;","" ] [ "batcalc", "date", "command batcalc.date(v:bat[:oid]):bat[:date] ", "batnil_2_date;", "cast to date" ] [ "batcalc", "date", "command batcalc.date(v:bat[:oid], r:bat[:bit]):bat[:date] ", "batnil_ce_2_date;","cast to date" ] [ "batcalc", "date", "command batcalc.date(v:bat[:str]):bat[:date] ", "batstr_2_date;", "cast to date" ] [ "batcalc", "date", "command batcalc.date(v:bat[:str], r:bat[:bit]):bat[:date] ", "batstr_ce_2_date;","cast to date" ] +[ "batcalc", "daytime", "command batcalc.daytime(d:bat[:daytime]):bat[:daytime] ", "MTIMEdaytime_daytime_bulk;", "" ] [ "batcalc", "daytime", "command batcalc.daytime(s:bat[:lng]):bat[:daytime] ", "MTIMEdaytime_fromseconds_bulk;", "" ] +[ "batcalc", "daytime", "command batcalc.daytime(s:bat[:str]):bat[:daytime] ", "MTIMEdaytime_fromstr_bulk;", "" ] [ "batcalc", "daytime", "command batcalc.daytime(t:bat[:timestamp]):bat[:daytime] ", "MTIMEtimestamp_extract_daytime_bulk;", "" ] [ "batcalc", "daytime", "command batcalc.daytime(v:bat[:daytime], digits:int):bat[:daytime] ", "batdaytime_2time_daytime;","cast daytime to daytime and
MonetDB: unlock - approved output of tests
Changeset: 2a6c49de5185 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2a6c49de5185 Modified Files: sql/test/wlcr/Tests/All Branch: unlock Log Message: approved output of tests diffs (86 lines): diff --git a/sql/test/wlcr/Tests/All b/sql/test/wlcr/Tests/All --- a/sql/test/wlcr/Tests/All +++ b/sql/test/wlcr/Tests/All @@ -1,41 +1,41 @@ -# This is a scenario for continual replication -# first create a master with some sample data -wlcr00 -wlc01 - -# check the log records without replication -wlr01 - -# create the first replica synchronized with the master -wlr10 - -# add two sets of tuples to the master -wlc20 -wlc21 - -# and automatically roll forward the clone in 2 steps -wlr20 - -# prepare an update to the master -wlc30 - -# roll forward to clone -wlr30 - -# delete some tupples -wlc40 -wlr35 -wlr40 - -# clear the complete table -wlc50 -wlr50 - -# restart for timing based roll forward -wlc70 -wlr70 - -# stop the master -wlc100 -wlr100 -wlr110 +## This is a scenario for continual replication +## first create a master with some sample data +#wlcr00 +#wlc01 +# +## check the log records without replication +#wlr01 +# +## create the first replica synchronized with the master +#wlr10 +# +## add two sets of tuples to the master +#wlc20 +#wlc21 +# +## and automatically roll forward the clone in 2 steps +#wlr20 +# +## prepare an update to the master +#wlc30 +# +## roll forward to clone +#wlr30 +# +## delete some tupples +#wlc40 +#wlr35 +#wlr40 +# +## clear the complete table +#wlc50 +#wlr50 +# +## restart for timing based roll forward +#wlc70 +#wlr70 +# +## stop the master +#wlc100 +#wlr100 +#wlr110 ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
