Changeset: 6fb4300fcc00 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6fb4300fcc00
Modified Files:
clients/Tests/MAL-signatures.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: typing
Log Message:
Approved output
diffs (201 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
@@ -5585,9 +5585,9 @@ stdout of test 'MAL-signatures` in direc
[ "batmtime", "dayofyear", "command
batmtime.dayofyear(X_1:bat[:date]):bat[:int] ",
"MTIMEdate_extract_dayofyear_bulk;", "" ]
[ "batmtime", "decade", "command
batmtime.decade(X_1:bat[:date]):bat[:int] ",
"MTIMEdate_extract_decade_bulk;", "" ]
[ "batmtime", "decade", "command
batmtime.decade(X_1:bat[:timestamp]):bat[:int] ",
"MTIMEtimestamp_decade_bulk;", "" ]
-[ "batmtime", "diff", "command batmtime.diff(X_1:bat[:date],
X_2:bat[:date]):bat[:int] ", "MTIMEdate_diff_bulk;", "" ]
-[ "batmtime", "diff", "command batmtime.diff(X_1:date,
X_2:bat[:date]):bat[:int] ", "MTIMEdate_diff_bulk_p1;", "" ]
-[ "batmtime", "diff", "command batmtime.diff(X_1:bat[:date],
X_2:date):bat[:int] ", "MTIMEdate_diff_bulk_p2;", "" ]
+[ "batmtime", "diff", "command batmtime.diff(X_1:bat[:date],
X_2:bat[:date]):bat[:lng] ", "MTIMEdate_diff_bulk;", "" ]
+[ "batmtime", "diff", "command batmtime.diff(X_1:date,
X_2:bat[:date]):bat[:lng] ", "MTIMEdate_diff_bulk_p1;", "" ]
+[ "batmtime", "diff", "command batmtime.diff(X_1:bat[:date],
X_2:date):bat[:lng] ", "MTIMEdate_diff_bulk_p2;", "" ]
[ "batmtime", "diff", "command batmtime.diff(X_1:bat[:daytime],
X_2:bat[:daytime]):bat[:lng] ", "MTIMEdaytime_diff_msec_bulk;", "" ]
[ "batmtime", "diff", "command batmtime.diff(X_1:daytime,
X_2:bat[:daytime]):bat[:lng] ", "MTIMEdaytime_diff_msec_bulk_p1;", ""
]
[ "batmtime", "diff", "command batmtime.diff(X_1:bat[:daytime],
X_2:daytime):bat[:lng] ", "MTIMEdaytime_diff_msec_bulk_p2;", "" ]
@@ -8180,7 +8180,7 @@ stdout of test 'MAL-signatures` in direc
[ "mtime", "dayofyear", "command mtime.dayofyear(X_1:date):int ",
"MTIMEdate_extract_dayofyear;", "" ]
[ "mtime", "decade", "command mtime.decade(X_1:date):int ",
"MTIMEdate_extract_decade;", "" ]
[ "mtime", "decade", "command mtime.decade(X_1:timestamp):int ",
"MTIMEtimestamp_decade;", "" ]
-[ "mtime", "diff", "command mtime.diff(X_1:date, X_2:date):int ",
"MTIMEdate_diff;", "" ]
+[ "mtime", "diff", "command mtime.diff(X_1:date, X_2:date):lng ",
"MTIMEdate_diff;", "" ]
[ "mtime", "diff", "command mtime.diff(X_1:daytime, X_2:daytime):lng ",
"MTIMEdaytime_diff_msec;", "" ]
[ "mtime", "diff", "command mtime.diff(X_1:timestamp, X_2:timestamp):lng
", "MTIMEtimestamp_diff_msec;", "" ]
[ "mtime", "epoch", "command mtime.epoch(X_1:timestamp):int ",
"MTIMEseconds_since_epoch;", "" ]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out
b/sql/test/sys-schema/Tests/systemfunctions.stable.out
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out
@@ -773,8 +773,14 @@ stdout of test 'systemfunctions` in dire
[ "sys", "get_type", 1, "int", "" ]
[ "sys", "get_type", 2, "int", "" ]
[ "sys", "get_value_for", 0, "bigint", "get_value"
]
+[ "sys", "get_value_for", 1, "char", "" ]
+[ "sys", "get_value_for", 2, "char", "" ]
+[ "sys", "get_value_for", 0, "bigint", "get_value"
]
[ "sys", "get_value_for", 1, "varchar", "" ]
[ "sys", "get_value_for", 2, "varchar", "" ]
+[ "sys", "get_value_for", 0, "bigint", "get_value"
]
+[ "sys", "get_value_for", 1, "clob", "" ]
+[ "sys", "get_value_for", 2, "clob", "" ]
[ "sys", "getanchor", 0, "clob", "create function getanchor(
theurl url ) returns string\nexternal name url.\"getAnchor\";" ]
[ "sys", "getanchor", 1, "url", "" ]
[ "sys", "getbasename", 0, "clob", "create function
getbasename(theurl url) returns string\nexternal name url.\"getBasename\";" ]
@@ -1147,16 +1153,36 @@ stdout of test 'systemfunctions` in dire
[ "sys", "like", 1, "clob", "" ]
[ "sys", "like", 2, "clob", "" ]
[ "sys", "like", 3, "clob", "" ]
+[ "sys", "listagg", 0, "char", "str_group_concat" ]
+[ "sys", "listagg", 1, "char", "" ]
+[ "sys", "listagg", 0, "char", "str_group_concat" ]
+[ "sys", "listagg", 1, "char", "" ]
+[ "sys", "listagg", 2, "char", "" ]
[ "sys", "listagg", 0, "varchar", "str_group_concat"
]
[ "sys", "listagg", 1, "varchar", "" ]
[ "sys", "listagg", 0, "varchar", "str_group_concat"
]
[ "sys", "listagg", 1, "varchar", "" ]
[ "sys", "listagg", 2, "varchar", "" ]
+[ "sys", "listagg", 0, "clob", "str_group_concat" ]
+[ "sys", "listagg", 1, "clob", "" ]
+[ "sys", "listagg", 0, "clob", "str_group_concat" ]
+[ "sys", "listagg", 1, "clob", "" ]
+[ "sys", "listagg", 2, "clob", "" ]
+[ "sys", "listagg", 0, "char", "str_group_concat" ]
+[ "sys", "listagg", 1, "char", "" ]
+[ "sys", "listagg", 0, "char", "str_group_concat" ]
+[ "sys", "listagg", 1, "char", "" ]
+[ "sys", "listagg", 2, "char", "" ]
[ "sys", "listagg", 0, "varchar", "str_group_concat"
]
[ "sys", "listagg", 1, "varchar", "" ]
[ "sys", "listagg", 0, "varchar", "str_group_concat"
]
[ "sys", "listagg", 1, "varchar", "" ]
[ "sys", "listagg", 2, "varchar", "" ]
+[ "sys", "listagg", 0, "clob", "str_group_concat" ]
+[ "sys", "listagg", 1, "clob", "" ]
+[ "sys", "listagg", 0, "clob", "str_group_concat" ]
+[ "sys", "listagg", 1, "clob", "" ]
+[ "sys", "listagg", 2, "clob", "" ]
[ "sys", "listdir", 0, "clob", "create procedure
listdir(dirname string) external name fits.listdir;" ]
[ "sys", "listdirpat", 0, "clob", "create procedure
listdirpat(dirname string,pat string) external name fits.listdirpattern;" ]
[ "sys", "listdirpat", 1, "clob", "" ]
@@ -1466,8 +1492,14 @@ stdout of test 'systemfunctions` in dire
[ "sys", "newurl", 2, "clob", "" ]
[ "sys", "newurl", 3, "clob", "" ]
[ "sys", "next_value_for", 0, "bigint", "next_value"
]
+[ "sys", "next_value_for", 1, "char", "" ]
+[ "sys", "next_value_for", 2, "char", "" ]
+[ "sys", "next_value_for", 0, "bigint", "next_value"
]
[ "sys", "next_value_for", 1, "varchar", "" ]
[ "sys", "next_value_for", 2, "varchar", "" ]
+[ "sys", "next_value_for", 0, "bigint", "next_value"
]
+[ "sys", "next_value_for", 1, "clob", "" ]
+[ "sys", "next_value_for", 2, "clob", "" ]
[ "sys", "not", 0, "boolean", "not" ]
[ "sys", "not", 1, "boolean", "" ]
[ "sys", "not_exist", 0, "boolean", "not_exist" ]
@@ -1774,9 +1806,17 @@ stdout of test 'systemfunctions` in dire
[ "sys", "replace", 2, "clob", "" ]
[ "sys", "replace", 3, "clob", "" ]
[ "sys", "restart", 0, "bigint", "restart" ]
+[ "sys", "restart", 1, "char", "" ]
+[ "sys", "restart", 2, "char", "" ]
+[ "sys", "restart", 3, "bigint", "" ]
+[ "sys", "restart", 0, "bigint", "restart" ]
[ "sys", "restart", 1, "varchar", "" ]
[ "sys", "restart", 2, "varchar", "" ]
[ "sys", "restart", 3, "bigint", "" ]
+[ "sys", "restart", 0, "bigint", "restart" ]
+[ "sys", "restart", 1, "clob", "" ]
+[ "sys", "restart", 2, "clob", "" ]
+[ "sys", "restart", 3, "bigint", "" ]
[ "sys", "resume", 0, "bigint", "create procedure
sys.resume(tag bigint)\nexternal name sysmon.resume;" ]
[ "sys", "reuse", 0, "clob", "create procedure reuse(sys
string, tab string)\nexternal name sql.reuse;" ]
[ "sys", "reuse", 1, "clob", "" ]
diff --git a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
--- a/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
+++ b/sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
@@ -838,8 +838,14 @@ stdout of test 'systemfunctions` in dire
[ "sys", "get_type", 1, "int", "" ]
[ "sys", "get_type", 2, "int", "" ]
[ "sys", "get_value_for", 0, "bigint", "get_value"
]
+[ "sys", "get_value_for", 1, "char", "" ]
+[ "sys", "get_value_for", 2, "char", "" ]
+[ "sys", "get_value_for", 0, "bigint", "get_value"
]
[ "sys", "get_value_for", 1, "varchar", "" ]
[ "sys", "get_value_for", 2, "varchar", "" ]
+[ "sys", "get_value_for", 0, "bigint", "get_value"
]
+[ "sys", "get_value_for", 1, "clob", "" ]
+[ "sys", "get_value_for", 2, "clob", "" ]
[ "sys", "getanchor", 0, "clob", "create function getanchor(
theurl url ) returns string\nexternal name url.\"getAnchor\";" ]
[ "sys", "getanchor", 1, "url", "" ]
[ "sys", "getbasename", 0, "clob", "create function
getbasename(theurl url) returns string\nexternal name url.\"getBasename\";" ]
@@ -1242,16 +1248,36 @@ stdout of test 'systemfunctions` in dire
[ "sys", "like", 1, "clob", "" ]
[ "sys", "like", 2, "clob", "" ]
[ "sys", "like", 3, "clob", "" ]
+[ "sys", "listagg", 0, "char", "str_group_concat" ]
+[ "sys", "listagg", 1, "char", "" ]
+[ "sys", "listagg", 0, "char", "str_group_concat" ]
+[ "sys", "listagg", 1, "char", "" ]
+[ "sys", "listagg", 2, "char", "" ]
[ "sys", "listagg", 0, "varchar", "str_group_concat"
]
[ "sys", "listagg", 1, "varchar", "" ]
[ "sys", "listagg", 0, "varchar", "str_group_concat"
]
[ "sys", "listagg", 1, "varchar", "" ]
[ "sys", "listagg", 2, "varchar", "" ]
+[ "sys", "listagg", 0, "clob", "str_group_concat" ]
+[ "sys", "listagg", 1, "clob", "" ]
+[ "sys", "listagg", 0, "clob", "str_group_concat" ]
+[ "sys", "listagg", 1, "clob", "" ]
+[ "sys", "listagg", 2, "clob", "" ]
+[ "sys", "listagg", 0, "char", "str_group_concat" ]
+[ "sys", "listagg", 1, "char", "" ]
+[ "sys", "listagg", 0, "char", "str_group_concat" ]
+[ "sys", "listagg", 1, "char", "" ]
+[ "sys", "listagg", 2, "char", "" ]
[ "sys", "listagg", 0, "varchar", "str_group_concat"
]
[ "sys", "listagg", 1, "varchar", "" ]
[ "sys", "listagg", 0, "varchar", "str_group_concat"
]
[ "sys", "listagg", 1, "varchar", "" ]
[ "sys", "listagg", 2, "varchar", "" ]
+[ "sys", "listagg", 0, "clob", "str_group_concat" ]
+[ "sys", "listagg", 1, "clob", "" ]
+[ "sys", "listagg", 0, "clob", "str_group_concat" ]
+[ "sys", "listagg", 1, "clob", "" ]
+[ "sys", "listagg", 2, "clob", "" ]
[ "sys", "listdir", 0, "clob", "create procedure
listdir(dirname string) external name fits.listdir;" ]
[ "sys", "listdirpat", 0, "clob", "create procedure
listdirpat(dirname string,pat string) external name fits.listdirpattern;" ]
[ "sys", "listdirpat", 1, "clob", "" ]
@@ -1571,8 +1597,14 @@ stdout of test 'systemfunctions` in dire
[ "sys", "newurl", 2, "clob", "" ]
[ "sys", "newurl", 3, "clob", "" ]
[ "sys", "next_value_for", 0, "bigint", "next_value"
]
+[ "sys", "next_value_for", 1, "char", "" ]
+[ "sys", "next_value_for", 2, "char", "" ]
+[ "sys", "next_value_for", 0, "bigint", "next_value"
]
[ "sys", "next_value_for", 1, "varchar", "" ]
[ "sys", "next_value_for", 2, "varchar", "" ]
+[ "sys", "next_value_for", 0, "bigint", "next_value"
]
+[ "sys", "next_value_for", 1, "clob", "" ]
+[ "sys", "next_value_for", 2, "clob", "" ]
[ "sys", "not", 0, "boolean", "not" ]
[ "sys", "not", 1, "boolean", "" ]
[ "sys", "not_exist", 0, "boolean", "not_exist" ]
@@ -1897,9 +1929,17 @@ stdout of test 'systemfunctions` in dire
[ "sys", "replace", 2, "clob", "" ]
[ "sys", "replace", 3, "clob", "" ]
[ "sys", "restart", 0, "bigint", "restart" ]
+[ "sys", "restart", 1, "char", "" ]
+[ "sys", "restart", 2, "char", "" ]
+[ "sys", "restart", 3, "bigint", "" ]
+[ "sys", "restart", 0, "bigint", "restart" ]
[ "sys", "restart", 1, "varchar", "" ]
[ "sys", "restart", 2, "varchar", "" ]
[ "sys", "restart", 3, "bigint", "" ]
+[ "sys", "restart", 0, "bigint", "restart" ]
+[ "sys", "restart", 1, "clob", "" ]
+[ "sys", "restart", 2, "clob", "" ]
+[ "sys", "restart", 3, "bigint", "" ]
[ "sys", "resume", 0, "bigint", "create procedure
sys.resume(tag bigint)\nexternal name sysmon.resume;" ]
[ "sys", "reuse", 0, "clob", "create procedure reuse(sys
string, tab string)\nexternal name sql.reuse;" ]
[ "sys", "reuse", 1, "clob", "" ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
