Changeset: 11726567fbe3 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=11726567fbe3 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 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/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/check2.stable.out.int128 sql/test/leaks/Tests/check3.stable.out.int128 sql/test/leaks/Tests/check4.stable.out.int128 sql/test/leaks/Tests/check5.stable.out.int128 Branch: wlcr Log Message:
Approve output diffs (truncated from 621 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 @@ -8740,7 +8740,6 @@ Ready. [ "wlcr", "master", "pattern wlcr.master():void ", "WLCmaster;", "Activate the workload-capture-replay" ] [ "wlcr", "query", "pattern wlcr.query(q:str):void ", "WLCquery;", "Keep the queries for replay." ] [ "wlcr", "rename_user", "pattern wlcr.rename_user(sname:str, newnme:str, action:int):void ", "WLCgeneric;", "Catalog operation rename_user" ] -[ "wlcr", "replicate", "pattern wlcr.replicate(dbname:str):void ", "WLCRreplicate;", "Roll the snapshot forward to an up-to-date clone" ] [ "wlcr", "revoke", "pattern wlcr.revoke(sname:str, tbl:str, grantee:str, privs:int, cname:str, grant:int, grantor:int):void ", "WLCgeneric;", "Catalog operation revoke" ] [ "wlcr", "revoke_function", "pattern wlcr.revoke_function(sname:str, fcnid:int, grantee:str, privs:int, grant:int, grantor:int):void ", "WLCgeneric;", "Catalog operation revoke_function" ] [ "wlcr", "revoke_roles", "pattern wlcr.revoke_roles(sname:str, auth:str, grantor:int, admin:int):void ", "WLCgeneric;", "Catalog operation revoke_roles" ] @@ -8796,6 +8795,7 @@ Ready. [ "wlr", "query", "pattern wlr.query(q:str):void ", "WLRquery;", "The actual query applied" ] [ "wlr", "rename_user", "pattern wlr.rename_user(sname:str, newnme:str, action:int):void ", "WLRgeneric;", "Catalog operation rename_user" ] [ "wlr", "replaythreshold", "pattern wlr.replaythreshold(dur:int):void ", "WLRreplaythreshold;", "Threshold (in milliseconds) for re-running queries" ] +[ "wlr", "replicate", "pattern wlr.replicate(dbname:str):void ", "WLRreplicate;", "Roll the snapshot forward to an up-to-date clone" ] [ "wlr", "revoke", "pattern wlr.revoke(sname:str, tbl:str, grantee:str, privs:int, cname:str, grant:int, grantor:int):void ", "WLRgeneric;", "Catalog operation revoke" ] [ "wlr", "revoke_function", "pattern wlr.revoke_function(sname:str, fcnid:int, grantee:str, privs:int, grant:int, grantor:int):void ", "WLRgeneric;", "Catalog operation revoke_function" ] [ "wlr", "revoke_roles", "pattern wlr.revoke_roles(sname:str, auth:str, grantor:int, admin:int):void ", "WLRgeneric;", "Catalog operation revoke_roles" ] @@ -8807,6 +8807,7 @@ Ready. [ "wlr", "transaction_release", "pattern wlr.transaction_release(chain:int, name:str):void ", "WLRgeneric;", "A transaction statement (type can be commit,release,rollback or start)" ] [ "wlr", "transaction_rollback", "pattern wlr.transaction_rollback(chain:int, name:str):void ", "WLRgeneric;", "A transaction statement (type can be commit,release,rollback or start)" ] [ "wlr", "update", "pattern wlr.update(sname:str, tname:str, cname:str, tid:oid, val:any):int ", "WLRupdate;", "Apply the update in the workload-capture-replay list" ] +[ "wlr", "waitformaster", "pattern wlr.waitformaster():void ", "WLRwaitformaster;", "Wait until all known log files have been processed" ] [ "xml", "#fromstr", "command xml.#fromstr():void ", "XMLfromString;", "Convert a string to an xml." ] [ "xml", "#tostr", "command xml.#tostr():void ", "XMLtoString;", "Convert xml to string equivalent" ] [ "xml", "aggr", "command xml.aggr(val:bat[:xml]):xml ", "BATXMLgroup;", "Aggregate the XML values." ] 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 @@ -11105,7 +11105,6 @@ Ready. [ "wlcr", "master", "pattern wlcr.master():void ", "WLCmaster;", "Activate the workload-capture-replay" ] [ "wlcr", "query", "pattern wlcr.query(q:str):void ", "WLCquery;", "Keep the queries for replay." ] [ "wlcr", "rename_user", "pattern wlcr.rename_user(sname:str, newnme:str, action:int):void ", "WLCgeneric;", "Catalog operation rename_user" ] -[ "wlcr", "replicate", "pattern wlcr.replicate(dbname:str):void ", "WLCRreplicate;", "Roll the snapshot forward to an up-to-date clone" ] [ "wlcr", "revoke", "pattern wlcr.revoke(sname:str, tbl:str, grantee:str, privs:int, cname:str, grant:int, grantor:int):void ", "WLCgeneric;", "Catalog operation revoke" ] [ "wlcr", "revoke_function", "pattern wlcr.revoke_function(sname:str, fcnid:int, grantee:str, privs:int, grant:int, grantor:int):void ", "WLCgeneric;", "Catalog operation revoke_function" ] [ "wlcr", "revoke_roles", "pattern wlcr.revoke_roles(sname:str, auth:str, grantor:int, admin:int):void ", "WLCgeneric;", "Catalog operation revoke_roles" ] @@ -11161,6 +11160,7 @@ Ready. [ "wlr", "query", "pattern wlr.query(q:str):void ", "WLRquery;", "The actual query applied" ] [ "wlr", "rename_user", "pattern wlr.rename_user(sname:str, newnme:str, action:int):void ", "WLRgeneric;", "Catalog operation rename_user" ] [ "wlr", "replaythreshold", "pattern wlr.replaythreshold(dur:int):void ", "WLRreplaythreshold;", "Threshold (in milliseconds) for re-running queries" ] +[ "wlr", "replicate", "pattern wlr.replicate(dbname:str):void ", "WLRreplicate;", "Roll the snapshot forward to an up-to-date clone" ] [ "wlr", "revoke", "pattern wlr.revoke(sname:str, tbl:str, grantee:str, privs:int, cname:str, grant:int, grantor:int):void ", "WLRgeneric;", "Catalog operation revoke" ] [ "wlr", "revoke_function", "pattern wlr.revoke_function(sname:str, fcnid:int, grantee:str, privs:int, grant:int, grantor:int):void ", "WLRgeneric;", "Catalog operation revoke_function" ] [ "wlr", "revoke_roles", "pattern wlr.revoke_roles(sname:str, auth:str, grantor:int, admin:int):void ", "WLRgeneric;", "Catalog operation revoke_roles" ] @@ -11172,6 +11172,7 @@ Ready. [ "wlr", "transaction_release", "pattern wlr.transaction_release(chain:int, name:str):void ", "WLRgeneric;", "A transaction statement (type can be commit,release,rollback or start)" ] [ "wlr", "transaction_rollback", "pattern wlr.transaction_rollback(chain:int, name:str):void ", "WLRgeneric;", "A transaction statement (type can be commit,release,rollback or start)" ] [ "wlr", "update", "pattern wlr.update(sname:str, tname:str, cname:str, tid:oid, val:any):int ", "WLRupdate;", "Apply the update in the workload-capture-replay list" ] +[ "wlr", "waitformaster", "pattern wlr.waitformaster():void ", "WLRwaitformaster;", "Wait until all known log files have been processed" ] [ "xml", "#fromstr", "command xml.#fromstr():void ", "XMLfromString;", "Convert a string to an xml." ] [ "xml", "#tostr", "command xml.#tostr():void ", "XMLtoString;", "Convert xml to string equivalent" ] [ "xml", "aggr", "command xml.aggr(val:bat[:xml]):xml ", "BATXMLgroup;", "Aggregate the XML values." ] diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -372,6 +372,7 @@ Ready. \dSf sys."var" \dSf sys."var_pop" \dSf sys."var_samp" +\dSf sys."waitformaster" SYSTEM SCHEMA bam SYSTEM SCHEMA json SYSTEM SCHEMA profiler @@ -807,6 +808,7 @@ SYSTEM FUNCTION sys.vacuum SYSTEM FUNCTION sys.var SYSTEM FUNCTION sys.var_pop SYSTEM FUNCTION sys.var_samp +SYSTEM FUNCTION sys.waitformaster SYSTEM FUNCTION sys.week SYSTEM FUNCTION sys.weekofyear SYSTEM FUNCTION sys.xor @@ -1038,7 +1040,7 @@ create function sys.queue() returns tabl create function radians(d double) returns double return d*pi()/180; create function sys.rejects() returns table(rowid bigint, fldid int, "message" string, "input" string) external name sql.copy_rejects; create procedure replaythreshold(duration int) external name wlr.replaythreshold; -create procedure replicate(dbname string) external name wlcr.replicate; +create procedure replicate(dbname string) external name wlr.replicate; create procedure sys.resume(tag int) external name sql.sysmon_resume; create procedure sys.resume(tag bigint) external name sql.sysmon_resume; create procedure reuse(sys string, tab string) external name sql.reuse; @@ -2301,7 +2303,7 @@ drop function pcre_replace(string, strin [ "sys", "replace", "replace", "str", 0, 1, false, false, false ] [ "sys", "replace", "replace", "str", 0, 1, false, false, false ] [ "sys", "replaythreshold", "create procedure replaythreshold(duration int) external name wlr.replaythreshold;", "wlr", 1, 2, true, false, false ] -[ "sys", "replicate", "create procedure replicate(dbname string) external name wlcr.replicate;", "wlcr", 1, 2, true, false, false ] +[ "sys", "replicate", "create procedure replicate(dbname string) external name wlr.replicate;", "wlr", 1, 2, true, false, false ] [ "sys", "restart", "restart", "sql", 0, 1, false, false, false ] [ "sys", "resume", "create procedure sys.resume(tag bigint) external name sql.sysmon_resume;", "sql", 1, 2, true, false, false ] [ "sys", "resume", "create procedure sys.resume(tag int) external name sql.sysmon_resume;", "sql", 1, 2, true, false, false ] @@ -3333,6 +3335,7 @@ drop function pcre_replace(string, strin [ "sys", "var_samp", "create aggregate var_samp(val time) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] [ "sys", "var_samp", "create aggregate var_samp(val timestamp) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] [ "sys", "var_samp", "create aggregate var_samp(val tinyint) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] +[ "sys", "waitformaster", "create procedure waitformaster() external name wlr.waitformaster;", "wlr", 1, 2, true, false, false ] [ "sys", "week", "weekofyear", "mtime", 0, 1, false, false, false ] [ "sys", "weekofyear", "weekofyear", "mtime", 0, 1, false, false, false ] [ "sys", "xor", "xor", "calc", 0, 1, false, false, false ] @@ -4889,6 +4892,7 @@ drop function pcre_replace(string, strin [ "sys", "var_samp", "val", "time", 1, 0, 1, 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", "var_samp", "val", "timestamp", 7, 0, 1, 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", "var_samp", "val", "tinyint", 8, 0, 1, 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", "waitformaster", 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", "week", "arg_1", "date", 0, 0, 1, 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", "weekofyear", "arg_1", "date", 0, 0, 1, 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", "xor", "arg_1", "boolean", 1, 0, 1, "arg_2", "boolean", 1, 0, 1, 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 ] @@ -7325,6 +7329,7 @@ drop function pcre_replace(string, strin [ "var_samp" ] [ "var_samp" ] [ "var_samp" ] +[ "waitformaster" ] [ "week" ] [ "weekofyear" ] [ "xor" ] diff --git a/clients/Tests/SQL-dump.stable.out.int128 b/clients/Tests/SQL-dump.stable.out.int128 --- a/clients/Tests/SQL-dump.stable.out.int128 +++ b/clients/Tests/SQL-dump.stable.out.int128 @@ -368,6 +368,7 @@ Ready. \dSf sys."var" \dSf sys."var_pop" \dSf sys."var_samp" +\dSf sys."waitformaster" SYSTEM SCHEMA bam SYSTEM SCHEMA json SYSTEM SCHEMA profiler @@ -803,6 +804,7 @@ SYSTEM FUNCTION sys.vacuum SYSTEM FUNCTION sys.var SYSTEM FUNCTION sys.var_pop SYSTEM FUNCTION sys.var_samp +SYSTEM FUNCTION sys.waitformaster SYSTEM FUNCTION sys.week SYSTEM FUNCTION sys.weekofyear SYSTEM FUNCTION sys.xor @@ -1040,7 +1042,7 @@ create function sys.queue() returns tabl create function radians(d double) returns double return d*pi()/180; create function sys.rejects() returns table(rowid bigint, fldid int, "message" string, "input" string) external name sql.copy_rejects; create procedure replaythreshold(duration int) external name wlr.replaythreshold; -create procedure replicate(dbname string) external name wlcr.replicate; +create procedure replicate(dbname string) external name wlr.replicate; create procedure sys.resume(tag int) external name sql.sysmon_resume; create procedure sys.resume(tag bigint) external name sql.sysmon_resume; create procedure reuse(sys string, tab string) external name sql.reuse; @@ -1235,6 +1237,7 @@ create aggregate var_samp(val date) retu create aggregate var_samp(val time) returns double external name "aggr"."variance"; create aggregate var_samp(val timestamp) returns double external name "aggr"."variance"; create aggregate var_samp(val hugeint) returns double external name "aggr"."variance"; +create procedure waitformaster() external name wlr.waitformaster; -- helper function create function pcre_replace(origin string, pat string, repl string, flags string) returns string external name pcre.replace; @@ -2331,7 +2334,7 @@ drop function pcre_replace(string, strin [ "sys", "replace", "replace", "str", 0, 1, false, false, false ] [ "sys", "replace", "replace", "str", 0, 1, false, false, false ] [ "sys", "replaythreshold", "create procedure replaythreshold(duration int) external name wlr.replaythreshold;", "wlr", 1, 2, true, false, false ] -[ "sys", "replicate", "create procedure replicate(dbname string) external name wlcr.replicate;", "wlcr", 1, 2, true, false, false ] +[ "sys", "replicate", "create procedure replicate(dbname string) external name wlr.replicate;", "wlr", 1, 2, true, false, false ] [ "sys", "restart", "restart", "sql", 0, 1, false, false, false ] [ "sys", "resume", "create procedure sys.resume(tag bigint) external name sql.sysmon_resume;", "sql", 1, 2, true, false, false ] [ "sys", "resume", "create procedure sys.resume(tag int) external name sql.sysmon_resume;", "sql", 1, 2, true, false, false ] @@ -3520,6 +3523,7 @@ drop function pcre_replace(string, strin [ "sys", "var_samp", "create aggregate var_samp(val time) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] [ "sys", "var_samp", "create aggregate var_samp(val timestamp) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] [ "sys", "var_samp", "create aggregate var_samp(val tinyint) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] +[ "sys", "waitformaster", "create procedure waitformaster() external name wlr.waitformaster;", "wlr", 1, 2, true, false, false ] [ "sys", "week", "weekofyear", "mtime", 0, 1, false, false, false ] [ "sys", "weekofyear", "weekofyear", "mtime", 0, 1, false, false, false ] [ "sys", "xor", "xor", "calc", 0, 1, false, false, false ] @@ -5257,6 +5261,7 @@ drop function pcre_replace(string, strin [ "sys", "var_samp", "val", "time", 1, 0, 1, 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", "var_samp", "val", "timestamp", 7, 0, 1, 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", "var_samp", "val", "tinyint", 8, 0, 1, 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", "waitformaster", 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", "week", "arg_1", "date", 0, 0, 1, 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", "weekofyear", "arg_1", "date", 0, 0, 1, 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", "xor", "arg_1", "boolean", 1, 0, 1, "arg_2", "boolean", 1, 0, 1, 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 ] @@ -7883,6 +7888,7 @@ drop function pcre_replace(string, strin [ "var_samp" ] [ "var_samp" ] [ "var_samp" ] +[ "waitformaster" ] [ "week" ] [ "weekofyear" ] [ "xor" ] diff --git a/sql/test/Tests/systemfunctions.stable.out b/sql/test/Tests/systemfunctions.stable.out --- a/sql/test/Tests/systemfunctions.stable.out +++ b/sql/test/Tests/systemfunctions.stable.out @@ -1382,7 +1382,7 @@ Ready. [ "sys", "replace", 2, "clob", "" ] [ "sys", "replace", 3, "clob", "" ] [ "sys", "replaythreshold", 0, "int", "create procedure replaythreshold(duration int)\nexternal name wlr.replaythreshold;" ] -[ "sys", "replicate", 0, "clob", "create procedure replicate(dbname string)\nexternal name wlcr.replicate;" ] +[ "sys", "replicate", 0, "clob", "create procedure replicate(dbname string)\nexternal name wlr.replicate;" ] [ "sys", "restart", 0, "bigint", "restart" ] [ "sys", "restart", 1, "varchar", "" ] [ "sys", "restart", 2, "varchar", "" ] diff --git a/sql/test/Tests/systemfunctions.stable.out.int128 b/sql/test/Tests/systemfunctions.stable.out.int128 --- a/sql/test/Tests/systemfunctions.stable.out.int128 +++ b/sql/test/Tests/systemfunctions.stable.out.int128 @@ -1447,7 +1447,7 @@ Ready. [ "sys", "replace", 2, "clob", "" ] [ "sys", "replace", 3, "clob", "" ] [ "sys", "replaythreshold", 0, "int", "create procedure replaythreshold(duration int)\nexternal name wlr.replaythreshold;" ] -[ "sys", "replicate", 0, "clob", "create procedure replicate(dbname string)\nexternal name wlcr.replicate;" ] +[ "sys", "replicate", 0, "clob", "create procedure replicate(dbname string)\nexternal name wlr.replicate;" ] [ "sys", "restart", 0, "bigint", "restart" ] [ "sys", "restart", 1, "varchar", "" ] [ "sys", "restart", 2, "varchar", "" ] 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 @@ -339,6 +339,7 @@ Ready. \dSf sys."var" \dSf sys."var_pop" \dSf sys."var_samp" +\dSf sys."waitformaster" SYSTEM SCHEMA bam SYSTEM SCHEMA json SYSTEM SCHEMA profiler @@ -998,7 +999,7 @@ create function sys.queue() returns tabl create function radians(d double) returns double return d*pi()/180; create function sys.rejects() returns table(rowid bigint, fldid int, "message" string, "input" string) external name sql.copy_rejects; create procedure replaythreshold(duration int) external name wlr.replaythreshold; -create procedure replicate(dbname string) external name wlcr.replicate; +create procedure replicate(dbname string) external name wlr.replicate; create procedure sys.resume(tag int) external name sql.sysmon_resume; create procedure sys.resume(tag bigint) external name sql.sysmon_resume; create procedure reuse(sys string, tab string) external name sql.reuse; @@ -2261,7 +2262,7 @@ drop function pcre_replace(string, strin [ "sys", "replace", "replace", "str", 0, 1, false, false, false ] [ "sys", "replace", "replace", "str", 0, 1, false, false, false ] [ "sys", "replaythreshold", "create procedure replaythreshold(duration int) external name wlr.replaythreshold;", "wlr", 1, 2, true, false, false ] -[ "sys", "replicate", "create procedure replicate(dbname string) external name wlcr.replicate;", "wlcr", 1, 2, true, false, false ] +[ "sys", "replicate", "create procedure replicate(dbname string) external name wlr.replicate;", "wlr", 1, 2, true, false, false ] [ "sys", "restart", "restart", "sql", 0, 1, false, false, false ] [ "sys", "resume", "create procedure sys.resume(tag bigint) external name sql.sysmon_resume;", "sql", 1, 2, true, false, false ] [ "sys", "resume", "create procedure sys.resume(tag int) external name sql.sysmon_resume;", "sql", 1, 2, true, false, false ] @@ -3293,6 +3294,7 @@ drop function pcre_replace(string, strin [ "sys", "var_samp", "create aggregate var_samp(val time) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] [ "sys", "var_samp", "create aggregate var_samp(val timestamp) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] [ "sys", "var_samp", "create aggregate var_samp(val tinyint) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] +[ "sys", "waitformaster", "create procedure waitformaster() external name wlr.waitformaster;", "wlr", 1, 2, true, false, false ] [ "sys", "week", "weekofyear", "mtime", 0, 1, false, false, false ] [ "sys", "weekofyear", "weekofyear", "mtime", 0, 1, false, false, false ] [ "sys", "xor", "xor", "calc", 0, 1, false, false, false ] @@ -4849,6 +4851,7 @@ drop function pcre_replace(string, strin [ "sys", "var_samp", "val", "time", 1, 0, 1, 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", "var_samp", "val", "timestamp", 7, 0, 1, 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", "var_samp", "val", "tinyint", 8, 0, 1, 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", "waitformaster", 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", "week", "arg_1", "date", 0, 0, 1, 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", "weekofyear", "arg_1", "date", 0, 0, 1, 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", "xor", "arg_1", "boolean", 1, 0, 1, "arg_2", "boolean", 1, 0, 1, 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 ] @@ -7285,6 +7288,7 @@ drop function pcre_replace(string, strin [ "var_samp" ] [ "var_samp" ] [ "var_samp" ] +[ "waitformaster" ] [ "week" ] [ "weekofyear" ] [ "xor" ] diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit b/sql/test/emptydb/Tests/check.stable.out.32bit --- a/sql/test/emptydb/Tests/check.stable.out.32bit +++ b/sql/test/emptydb/Tests/check.stable.out.32bit @@ -343,6 +343,7 @@ Ready. \dSf sys."var" \dSf sys."var_pop" \dSf sys."var_samp" +\dSf sys."waitformaster" SYSTEM SCHEMA bam SYSTEM SCHEMA json SYSTEM SCHEMA profiler @@ -778,6 +779,7 @@ SYSTEM FUNCTION sys.vacuum SYSTEM FUNCTION sys.var SYSTEM FUNCTION sys.var_pop SYSTEM FUNCTION sys.var_samp +SYSTEM FUNCTION sys.waitformaster SYSTEM FUNCTION sys.week SYSTEM FUNCTION sys.weekofyear SYSTEM FUNCTION sys.xor @@ -1007,7 +1009,7 @@ create function sys.queue() returns tabl create function radians(d double) returns double return d*pi()/180; create function sys.rejects() returns table(rowid bigint, fldid int, "message" string, "input" string) external name sql.copy_rejects; create procedure replaythreshold(duration int) external name wlr.replaythreshold; -create procedure replicate(dbname string) external name wlcr.replicate; +create procedure replicate(dbname string) external name wlr.replicate; create procedure sys.resume(tag int) external name sql.sysmon_resume; create procedure sys.resume(tag bigint) external name sql.sysmon_resume; create procedure reuse(sys string, tab string) external name sql.reuse; @@ -2270,7 +2272,7 @@ drop function pcre_replace(string, strin [ "sys", "replace", "replace", "str", 0, 1, false, false, false ] [ "sys", "replace", "replace", "str", 0, 1, false, false, false ] [ "sys", "replaythreshold", "create procedure replaythreshold(duration int) external name wlr.replaythreshold;", "wlr", 1, 2, true, false, false ] -[ "sys", "replicate", "create procedure replicate(dbname string) external name wlcr.replicate;", "wlcr", 1, 2, true, false, false ] +[ "sys", "replicate", "create procedure replicate(dbname string) external name wlr.replicate;", "wlr", 1, 2, true, false, false ] [ "sys", "restart", "restart", "sql", 0, 1, false, false, false ] [ "sys", "resume", "create procedure sys.resume(tag bigint) external name sql.sysmon_resume;", "sql", 1, 2, true, false, false ] [ "sys", "resume", "create procedure sys.resume(tag int) external name sql.sysmon_resume;", "sql", 1, 2, true, false, false ] @@ -3302,6 +3304,7 @@ drop function pcre_replace(string, strin [ "sys", "var_samp", "create aggregate var_samp(val time) returns double external name \"aggr\".\"variance\";", "aggr", 1, 3, false, false, false ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list