Changeset: d38a568106e8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d38a568106e8 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 sql/ChangeLog.Jun2020 Branch: Jun2020 Log Message:
Updated ChangeLog and approved MAL signatures diffs (105 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 @@ -14253,10 +14253,10 @@ stdout of test 'MAL-signatures` in direc [ "sql", "zero_or_one", "command sql.zero_or_one(col:bat[:any_1]):any_1 ", "zero_or_one;", "if col contains exactly one value return this. Incase of more raise an exception else return nil" ] [ "sql", "zero_or_one", "command sql.zero_or_one(col:bat[:any_1], err:bit):any_1 ", "zero_or_one_error;", "if col contains exactly one value return this. Incase of more raise an exception if err is true else return nil" ] [ "sql", "zero_or_one", "command sql.zero_or_one(col:bat[:any_1], err:bat[:bit]):any_1 ", "zero_or_one_error_bat;", "if col contains exactly one value return this. Incase of more raise an exception if err is true else return nil" ] -[ "sqlcatalog", "alter_add_range_partition", "pattern sqlcatalog.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:any_1, max:any_1, nills:int, update:int):void ", "SQLalter_add_range_partition;", "Catalog operation alter_add_range_partition" ] +[ "sqlcatalog", "alter_add_range_partition", "pattern sqlcatalog.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:any_1, max:any_1, nills:bit, update:int):void ", "SQLalter_add_range_partition;", "Catalog operation alter_add_range_partition" ] [ "sqlcatalog", "alter_add_table", "pattern sqlcatalog.alter_add_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "SQLalter_add_table;", "Catalog operation alter_add_table" ] -[ "sqlcatalog", "alter_add_value_partition", "pattern sqlcatalog.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int):void ", "SQLalter_add_value_partition;", "Catalog operation alter_add_value_partition" ] -[ "sqlcatalog", "alter_add_value_partition", "pattern sqlcatalog.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int, arg:any...):void ", "SQLalter_add_value_partition;", "Catalog operation alter_add_value_partition" ] +[ "sqlcatalog", "alter_add_value_partition", "pattern sqlcatalog.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int):void ", "SQLalter_add_value_partition;", "Catalog operation alter_add_value_partition" ] +[ "sqlcatalog", "alter_add_value_partition", "pattern sqlcatalog.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int, arg:any...):void ", "SQLalter_add_value_partition;", "Catalog operation alter_add_value_partition" ] [ "sqlcatalog", "alter_del_table", "pattern sqlcatalog.alter_del_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "SQLalter_del_table;", "Catalog operation alter_del_table" ] [ "sqlcatalog", "alter_seq", "pattern sqlcatalog.alter_seq(sname:str, seqname:str, seq:ptr, val:bat[:lng]):void ", "SQLalter_seq;", "Catalog operation alter_seq" ] [ "sqlcatalog", "alter_seq", "pattern sqlcatalog.alter_seq(sname:str, seqname:str, seq:ptr, val:lng):void ", "SQLalter_seq;", "Catalog operation alter_seq" ] @@ -14457,10 +14457,10 @@ stdout of test 'MAL-signatures` in direc [ "wkba", "#tostr", "command wkba.#tostr():void ", "wkbaTOSTR;", "" ] [ "wkba", "#write", "command wkba.#write():void ", "wkbaWRITE;", "" ] [ "wlc", "action", "pattern wlc.action(q:str):void ", "WLCaction;", "Keep the database changing queries for replay. " ] -[ "wlc", "alter_add_range_partition", "pattern wlc.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:str, max:str, nills:int, update:int):void ", "WLCgeneric;", "Catalog operation alter_add_range_partition" ] +[ "wlc", "alter_add_range_partition", "pattern wlc.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:str, max:str, nills:bit, update:int):void ", "WLCgeneric;", "Catalog operation alter_add_range_partition" ] [ "wlc", "alter_add_table", "pattern wlc.alter_add_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "WLCgeneric;", "Catalog operation alter_add_table" ] -[ "wlc", "alter_add_value_partition", "pattern wlc.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int):void ", "WLCgeneric;", "Catalog operation alter_add_value_partition" ] -[ "wlc", "alter_add_value_partition", "pattern wlc.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int, arg:str...):void ", "WLCgeneric;", "Catalog operation alter_add_value_partition" ] +[ "wlc", "alter_add_value_partition", "pattern wlc.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int):void ", "WLCgeneric;", "Catalog operation alter_add_value_partition" ] +[ "wlc", "alter_add_value_partition", "pattern wlc.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int, arg:str...):void ", "WLCgeneric;", "Catalog operation alter_add_value_partition" ] [ "wlc", "alter_del_table", "pattern wlc.alter_del_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "WLCgeneric;", "Catalog operation alter_del_table" ] [ "wlc", "alter_seq", "pattern wlc.alter_seq(sname:str, seqname:str, seq:ptr, val:bat[:lng]):void ", "WLCgeneric;", "Catalog operation alter_seq" ] [ "wlc", "alter_seq", "pattern wlc.alter_seq(sname:str, seqname:str, val:lng):void ", "WLCgeneric;", "Catalog operation alter_seq" ] @@ -14527,10 +14527,10 @@ stdout of test 'MAL-signatures` in direc [ "wlc", "update", "pattern wlc.update(sname:str, tname:str, cname:str, tid:any, val:any):int ", "WLCupdate;", "Keep the update in the workload-capture-replay list" ] [ "wlr", "accept", "pattern wlr.accept():void ", "WLRaccept;", "Accept failing transaction" ] [ "wlr", "action", "pattern wlr.action(q:str):void ", "WLRaction;", "A query producing updates" ] -[ "wlr", "alter_add_range_partition", "pattern wlr.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:str, max:str, nills:int, update:int):void ", "WLRgeneric;", "Catalog operation alter_add_range_partition" ] +[ "wlr", "alter_add_range_partition", "pattern wlr.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:str, max:str, nills:bit, update:int):void ", "WLRgeneric;", "Catalog operation alter_add_range_partition" ] [ "wlr", "alter_add_table", "pattern wlr.alter_add_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "WLRgeneric;", "Catalog operation alter_add_table" ] -[ "wlr", "alter_add_value_partition", "pattern wlr.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int):void ", "WLRgeneric;", "Catalog operation alter_add_value_partition" ] -[ "wlr", "alter_add_value_partition", "pattern wlr.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int, arg:str...):void ", "WLRgeneric;", "Catalog operation alter_add_value_partition" ] +[ "wlr", "alter_add_value_partition", "pattern wlr.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int):void ", "WLRgeneric;", "Catalog operation alter_add_value_partition" ] +[ "wlr", "alter_add_value_partition", "pattern wlr.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int, arg:str...):void ", "WLRgeneric;", "Catalog operation alter_add_value_partition" ] [ "wlr", "alter_del_table", "pattern wlr.alter_del_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "WLRgeneric;", "Catalog operation alter_del_table" ] [ "wlr", "alter_seq", "pattern wlr.alter_seq(sname:str, seqname:str, seq:ptr, val:bat[:lng]):void ", "WLRgeneric;", "Catalog operation alter_seq" ] [ "wlr", "alter_seq", "pattern wlr.alter_seq(sname:str, seqname:str, val:lng):void ", "WLRgeneric;", "Catalog operation alter_seq" ] diff --git a/clients/Tests/MAL-signatures.stable.out.int128 b/clients/Tests/MAL-signatures.stable.out.int128 --- a/clients/Tests/MAL-signatures.stable.out.int128 +++ b/clients/Tests/MAL-signatures.stable.out.int128 @@ -19727,10 +19727,10 @@ stdout of test 'MAL-signatures` in direc [ "sql", "zero_or_one", "command sql.zero_or_one(col:bat[:any_1]):any_1 ", "zero_or_one;", "if col contains exactly one value return this. Incase of more raise an exception else return nil" ] [ "sql", "zero_or_one", "command sql.zero_or_one(col:bat[:any_1], err:bit):any_1 ", "zero_or_one_error;", "if col contains exactly one value return this. Incase of more raise an exception if err is true else return nil" ] [ "sql", "zero_or_one", "command sql.zero_or_one(col:bat[:any_1], err:bat[:bit]):any_1 ", "zero_or_one_error_bat;", "if col contains exactly one value return this. Incase of more raise an exception if err is true else return nil" ] -[ "sqlcatalog", "alter_add_range_partition", "pattern sqlcatalog.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:any_1, max:any_1, nills:int, update:int):void ", "SQLalter_add_range_partition;", "Catalog operation alter_add_range_partition" ] +[ "sqlcatalog", "alter_add_range_partition", "pattern sqlcatalog.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:any_1, max:any_1, nills:bit, update:int):void ", "SQLalter_add_range_partition;", "Catalog operation alter_add_range_partition" ] [ "sqlcatalog", "alter_add_table", "pattern sqlcatalog.alter_add_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "SQLalter_add_table;", "Catalog operation alter_add_table" ] -[ "sqlcatalog", "alter_add_value_partition", "pattern sqlcatalog.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int):void ", "SQLalter_add_value_partition;", "Catalog operation alter_add_value_partition" ] -[ "sqlcatalog", "alter_add_value_partition", "pattern sqlcatalog.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int, arg:any...):void ", "SQLalter_add_value_partition;", "Catalog operation alter_add_value_partition" ] +[ "sqlcatalog", "alter_add_value_partition", "pattern sqlcatalog.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int):void ", "SQLalter_add_value_partition;", "Catalog operation alter_add_value_partition" ] +[ "sqlcatalog", "alter_add_value_partition", "pattern sqlcatalog.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int, arg:any...):void ", "SQLalter_add_value_partition;", "Catalog operation alter_add_value_partition" ] [ "sqlcatalog", "alter_del_table", "pattern sqlcatalog.alter_del_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "SQLalter_del_table;", "Catalog operation alter_del_table" ] [ "sqlcatalog", "alter_seq", "pattern sqlcatalog.alter_seq(sname:str, seqname:str, seq:ptr, val:bat[:lng]):void ", "SQLalter_seq;", "Catalog operation alter_seq" ] [ "sqlcatalog", "alter_seq", "pattern sqlcatalog.alter_seq(sname:str, seqname:str, seq:ptr, val:lng):void ", "SQLalter_seq;", "Catalog operation alter_seq" ] @@ -19932,10 +19932,10 @@ stdout of test 'MAL-signatures` in direc [ "wkba", "#tostr", "command wkba.#tostr():void ", "wkbaTOSTR;", "" ] [ "wkba", "#write", "command wkba.#write():void ", "wkbaWRITE;", "" ] [ "wlc", "action", "pattern wlc.action(q:str):void ", "WLCaction;", "Keep the database changing queries for replay. " ] -[ "wlc", "alter_add_range_partition", "pattern wlc.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:str, max:str, nills:int, update:int):void ", "WLCgeneric;", "Catalog operation alter_add_range_partition" ] +[ "wlc", "alter_add_range_partition", "pattern wlc.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:str, max:str, nills:bit, update:int):void ", "WLCgeneric;", "Catalog operation alter_add_range_partition" ] [ "wlc", "alter_add_table", "pattern wlc.alter_add_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "WLCgeneric;", "Catalog operation alter_add_table" ] -[ "wlc", "alter_add_value_partition", "pattern wlc.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int):void ", "WLCgeneric;", "Catalog operation alter_add_value_partition" ] -[ "wlc", "alter_add_value_partition", "pattern wlc.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int, arg:str...):void ", "WLCgeneric;", "Catalog operation alter_add_value_partition" ] +[ "wlc", "alter_add_value_partition", "pattern wlc.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int):void ", "WLCgeneric;", "Catalog operation alter_add_value_partition" ] +[ "wlc", "alter_add_value_partition", "pattern wlc.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int, arg:str...):void ", "WLCgeneric;", "Catalog operation alter_add_value_partition" ] [ "wlc", "alter_del_table", "pattern wlc.alter_del_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "WLCgeneric;", "Catalog operation alter_del_table" ] [ "wlc", "alter_seq", "pattern wlc.alter_seq(sname:str, seqname:str, seq:ptr, val:bat[:lng]):void ", "WLCgeneric;", "Catalog operation alter_seq" ] [ "wlc", "alter_seq", "pattern wlc.alter_seq(sname:str, seqname:str, val:lng):void ", "WLCgeneric;", "Catalog operation alter_seq" ] @@ -20002,10 +20002,10 @@ stdout of test 'MAL-signatures` in direc [ "wlc", "update", "pattern wlc.update(sname:str, tname:str, cname:str, tid:any, val:any):int ", "WLCupdate;", "Keep the update in the workload-capture-replay list" ] [ "wlr", "accept", "pattern wlr.accept():void ", "WLRaccept;", "Accept failing transaction" ] [ "wlr", "action", "pattern wlr.action(q:str):void ", "WLRaction;", "A query producing updates" ] -[ "wlr", "alter_add_range_partition", "pattern wlr.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:str, max:str, nills:int, update:int):void ", "WLRgeneric;", "Catalog operation alter_add_range_partition" ] +[ "wlr", "alter_add_range_partition", "pattern wlr.alter_add_range_partition(sname:str, mtnme:str, psnme:str, ptnme:str, min:str, max:str, nills:bit, update:int):void ", "WLRgeneric;", "Catalog operation alter_add_range_partition" ] [ "wlr", "alter_add_table", "pattern wlr.alter_add_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "WLRgeneric;", "Catalog operation alter_add_table" ] -[ "wlr", "alter_add_value_partition", "pattern wlr.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int):void ", "WLRgeneric;", "Catalog operation alter_add_value_partition" ] -[ "wlr", "alter_add_value_partition", "pattern wlr.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:int, update:int, arg:str...):void ", "WLRgeneric;", "Catalog operation alter_add_value_partition" ] +[ "wlr", "alter_add_value_partition", "pattern wlr.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int):void ", "WLRgeneric;", "Catalog operation alter_add_value_partition" ] +[ "wlr", "alter_add_value_partition", "pattern wlr.alter_add_value_partition(sname:str, mtnme:str, psnme:str, ptnme:str, nills:bit, update:int, arg:str...):void ", "WLRgeneric;", "Catalog operation alter_add_value_partition" ] [ "wlr", "alter_del_table", "pattern wlr.alter_del_table(sname:str, mtnme:str, psnme:str, ptnme:str, action:int):void ", "WLRgeneric;", "Catalog operation alter_del_table" ] [ "wlr", "alter_seq", "pattern wlr.alter_seq(sname:str, seqname:str, seq:ptr, val:bat[:lng]):void ", "WLRgeneric;", "Catalog operation alter_seq" ] [ "wlr", "alter_seq", "pattern wlr.alter_seq(sname:str, seqname:str, val:lng):void ", "WLRgeneric;", "Catalog operation alter_seq" ] diff --git a/sql/ChangeLog.Jun2020 b/sql/ChangeLog.Jun2020 --- a/sql/ChangeLog.Jun2020 +++ b/sql/ChangeLog.Jun2020 @@ -1,6 +1,11 @@ # ChangeLog file for sql # This file is updated with Maddlog +* Fri Mar 27 2020 Pedro Ferreira <[email protected]> +- Added support for FROM RANGE MINVALUE TO RANGE MAXVALUE and FROM RANGE + MINVALUE TO RANGE MAXVALUE WITH NULL VALUES cases in partioned tables + by range (before they weren't). + * Wed Jan 29 2020 Sjoerd Mullender <[email protected]> - Removed support for Python 2. Python 2 itself is no longer supported. Use Python 3 instead. _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
