Changeset: 5a2c4ad3be1b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5a2c4ad3be1b Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/exports.stable.out 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 Branch: datetrunc Log Message:
Mtest run for date_trunc diffs (170 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 @@ -11675,6 +11675,10 @@ Ready. [ "sql", "cume_dist", "pattern sql.cume_dist(b:any_1, p:bit, o:bit):dbl ", "SQLcume_dist;", "return the accumulated distribution of the number of rows per group to the total number of partition rows" ] [ "sql", "current_time", "pattern sql.current_time():daytime ", "SQLcurrent_daytime;", "Get the clients current daytime" ] [ "sql", "current_timestamp", "pattern sql.current_timestamp():timestamp ", "SQLcurrent_timestamp;", "Get the clients current timestamp" ] +[ "sql", "date_trunc", "command sql.date_trunc(scale:str, v:bat[:daytime]):bat[:daytime] ", "bat_date_trunc;", "Truncate a timestamp to (millenium, century,decade,year,quarter,month,week,day,hour,minute,second, milliseconds,microseconds)" ] +[ "sql", "date_trunc", "command sql.date_trunc(scale:str, v:bat[:timestamp]):bat[:timestamp] ", "bat_date_trunc;", "" ] +[ "sql", "date_trunc", "command sql.date_trunc(scale:str, v:daytime):daytime ", "date_trunc;", "Truncate a timestamp to (millenium, century,decade,year,quarter,month,week,day,hour,minute,second, milliseconds,microseconds)" ] +[ "sql", "date_trunc", "command sql.date_trunc(scale:str, v:timestamp):timestamp ", "date_trunc;", "" ] [ "sql", "db_users", "pattern sql.db_users():bat[:str] ", "db_users_wrap;", "return table of users with sql scenario" ] [ "sql", "dec_round", "command sql.dec_round(v:bte, r:bte):bte ", "bte_dec_round_wrap;", "round off the value v to nearests multiple of r" ] [ "sql", "dec_round", "command sql.dec_round(v:dbl, r:dbl):dbl ", "dbl_dec_round_wrap;", "round off the value v to nearests multiple of r" ] 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 @@ -16088,6 +16088,10 @@ Ready. [ "sql", "cume_dist", "pattern sql.cume_dist(b:any_1, p:bit, o:bit):dbl ", "SQLcume_dist;", "return the accumulated distribution of the number of rows per group to the total number of partition rows" ] [ "sql", "current_time", "pattern sql.current_time():daytime ", "SQLcurrent_daytime;", "Get the clients current daytime" ] [ "sql", "current_timestamp", "pattern sql.current_timestamp():timestamp ", "SQLcurrent_timestamp;", "Get the clients current timestamp" ] +[ "sql", "date_trunc", "command sql.date_trunc(scale:str, v:bat[:daytime]):bat[:daytime] ", "bat_date_trunc;", "Truncate a timestamp to (millenium, century,decade,year,quarter,month,week,day,hour,minute,second, milliseconds,microseconds)" ] +[ "sql", "date_trunc", "command sql.date_trunc(scale:str, v:bat[:timestamp]):bat[:timestamp] ", "bat_date_trunc;", "" ] +[ "sql", "date_trunc", "command sql.date_trunc(scale:str, v:daytime):daytime ", "date_trunc;", "Truncate a timestamp to (millenium, century,decade,year,quarter,month,week,day,hour,minute,second, milliseconds,microseconds)" ] +[ "sql", "date_trunc", "command sql.date_trunc(scale:str, v:timestamp):timestamp ", "date_trunc;", "" ] [ "sql", "db_users", "pattern sql.db_users():bat[:str] ", "db_users_wrap;", "return table of users with sql scenario" ] [ "sql", "dec_round", "command sql.dec_round(v:bte, r:bte):bte ", "bte_dec_round_wrap;", "round off the value v to nearests multiple of r" ] [ "sql", "dec_round", "command sql.dec_round(v:dbl, r:dbl):dbl ", "dbl_dec_round_wrap;", "round off the value v to nearests multiple of r" ] 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 @@ -1513,6 +1513,7 @@ str MTIMEdate_extract_quarter_bulk(bat * str MTIMEdate_extract_weekofyear(int *ret, const date *v); str MTIMEdate_extract_year(int *ret, const date *v); str MTIMEdate_extract_year_bulk(bat *ret, const bat *bid); +str MTIMEdate_extract_ymd(int *year, int *month, int *day, const date *v); str MTIMEdate_fromstr(date *ret, const char *const *s); str MTIMEdate_sub_msec_interval_lng_wrap(date *ret, const date *t, const lng *msec); str MTIMEdate_sub_sec_interval_wrap(date *ret, const date *t, const int *sec); 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 @@ -492,6 +492,9 @@ Ready. [ "sys", "date_to_str", 0, "clob", "create function date_to_str(d date, format string) returns string\n external name mtime.\"date_to_str\";" ] [ "sys", "date_to_str", 1, "date", "" ] [ "sys", "date_to_str", 2, "clob", "" ] +[ "sys", "date_trunc", 0, "timestamp", "create function sys.date_trunc(txt string, t timestamp)\nreturns timestamp\nexternal name sql.date_trunc;" ] +[ "sys", "date_trunc", 1, "clob", "" ] +[ "sys", "date_trunc", 2, "timestamp", "" ] [ "sys", "day", 0, "int", "day" ] [ "sys", "day", 1, "date", "" ] [ "sys", "day", 0, "int", "day" ] 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 @@ -528,6 +528,9 @@ Ready. [ "sys", "date_to_str", 0, "clob", "create function date_to_str(d date, format string) returns string\n external name mtime.\"date_to_str\";" ] [ "sys", "date_to_str", 1, "date", "" ] [ "sys", "date_to_str", 2, "clob", "" ] +[ "sys", "date_trunc", 0, "timestamp", "create function sys.date_trunc(txt string, t timestamp)\nreturns timestamp\nexternal name sql.date_trunc;" ] +[ "sys", "date_trunc", 1, "clob", "" ] +[ "sys", "date_trunc", 2, "timestamp", "" ] [ "sys", "day", 0, "int", "day" ] [ "sys", "day", 1, "date", "" ] [ "sys", "day", 0, "int", "day" ] 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 @@ -145,6 +145,7 @@ Ready. \dSf sys."corr" \dSf sys."createorderindex" \dSf sys."date_to_str" +\dSf sys."date_trunc" \dSf sys."db_users" \dSf sys."debug" \dSf sys."degrees" @@ -495,6 +496,7 @@ SYSTEM FUNCTION sys.current_time SYSTEM FUNCTION sys.current_timestamp SYSTEM FUNCTION sys.curtime SYSTEM FUNCTION sys.date_to_str +SYSTEM FUNCTION sys.date_trunc SYSTEM FUNCTION sys.day SYSTEM FUNCTION sys.dayofmonth SYSTEM FUNCTION sys.dayofweek @@ -960,6 +962,7 @@ create aggregate corr(e1 smallint, e2 sm create aggregate corr(e1 tinyint, e2 tinyint) returns double external name "aggr"."corr"; create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex; create function date_to_str(d date, format string) returns string external name mtime."date_to_str"; +create function sys.date_trunc(txt string, t timestamp) returns timestamp external name sql.date_trunc; CREATE FUNCTION db_users () RETURNS TABLE(name varchar(2048)) EXTERNAL NAME sql.db_users; create function sys.debug(debug int) returns integer external name mdb."setDebug"; create function degrees(r double) returns double return r*180/pi(); @@ -2293,6 +2296,7 @@ drop function pcre_replace(string, strin [ "sys", "current_timestamp", "SYSTEM", "current_timestamp", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "timestamptz", 7, 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", "curtime", "SYSTEM", "current_time", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "timetz", 7, 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", "date_to_str", "SYSTEM", "create function date_to_str(d date, format string) returns string external name mtime.\"date_to_str\";", "mtime", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "d", "date", 0, 0, "in", "format", "clob", 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 ] +[ "sys", "date_trunc", "SYSTEM", "create function sys.date_trunc(txt string, t timestamp) returns timestamp external name sql.date_trunc;", "sql", "MAL", "Scalar function", false, false, false, "result", "timestamp", 7, 0, "out", "txt", "clob", 0, 0, "in", "t", "timestamp", 7, 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 ] [ "sys", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "sec_interval", 13, 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", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "date", 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", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "timestamp", 7, 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 ] 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 @@ -145,6 +145,7 @@ Ready. \dSf sys."corr" \dSf sys."createorderindex" \dSf sys."date_to_str" +\dSf sys."date_trunc" \dSf sys."db_users" \dSf sys."debug" \dSf sys."degrees" @@ -495,6 +496,7 @@ SYSTEM FUNCTION sys.current_time SYSTEM FUNCTION sys.current_timestamp SYSTEM FUNCTION sys.curtime SYSTEM FUNCTION sys.date_to_str +SYSTEM FUNCTION sys.date_trunc SYSTEM FUNCTION sys.day SYSTEM FUNCTION sys.dayofmonth SYSTEM FUNCTION sys.dayofweek @@ -960,6 +962,7 @@ create aggregate corr(e1 smallint, e2 sm create aggregate corr(e1 tinyint, e2 tinyint) returns double external name "aggr"."corr"; create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex; create function date_to_str(d date, format string) returns string external name mtime."date_to_str"; +create function sys.date_trunc(txt string, t timestamp) returns timestamp external name sql.date_trunc; CREATE FUNCTION db_users () RETURNS TABLE(name varchar(2048)) EXTERNAL NAME sql.db_users; create function sys.debug(debug int) returns integer external name mdb."setDebug"; create function degrees(r double) returns double return r*180/pi(); @@ -2293,6 +2296,7 @@ drop function pcre_replace(string, strin [ "sys", "current_timestamp", "SYSTEM", "current_timestamp", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "timestamptz", 7, 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", "curtime", "SYSTEM", "current_time", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "timetz", 7, 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", "date_to_str", "SYSTEM", "create function date_to_str(d date, format string) returns string external name mtime.\"date_to_str\";", "mtime", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "d", "date", 0, 0, "in", "format", "clob", 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 ] +[ "sys", "date_trunc", "SYSTEM", "create function sys.date_trunc(txt string, t timestamp) returns timestamp external name sql.date_trunc;", "sql", "MAL", "Scalar function", false, false, false, "result", "timestamp", 7, 0, "out", "txt", "clob", 0, 0, "in", "t", "timestamp", 7, 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 ] [ "sys", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "sec_interval", 13, 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", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "date", 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", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "timestamp", 7, 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 ] diff --git a/sql/test/emptydb/Tests/check.stable.out.int128 b/sql/test/emptydb/Tests/check.stable.out.int128 --- a/sql/test/emptydb/Tests/check.stable.out.int128 +++ b/sql/test/emptydb/Tests/check.stable.out.int128 @@ -145,6 +145,7 @@ Ready. \dSf sys."corr" \dSf sys."createorderindex" \dSf sys."date_to_str" +\dSf sys."date_trunc" \dSf sys."db_users" \dSf sys."debug" \dSf sys."degrees" @@ -495,6 +496,7 @@ SYSTEM FUNCTION sys.current_time SYSTEM FUNCTION sys.current_timestamp SYSTEM FUNCTION sys.curtime SYSTEM FUNCTION sys.date_to_str +SYSTEM FUNCTION sys.date_trunc SYSTEM FUNCTION sys.day SYSTEM FUNCTION sys.dayofmonth SYSTEM FUNCTION sys.dayofweek @@ -961,6 +963,7 @@ create aggregate corr(e1 smallint, e2 sm create aggregate corr(e1 tinyint, e2 tinyint) returns double external name "aggr"."corr"; create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex; create function date_to_str(d date, format string) returns string external name mtime."date_to_str"; +create function sys.date_trunc(txt string, t timestamp) returns timestamp external name sql.date_trunc; CREATE FUNCTION db_users () RETURNS TABLE(name varchar(2048)) EXTERNAL NAME sql.db_users; create function sys.debug(debug int) returns integer external name mdb."setDebug"; create function degrees(r double) returns double return r*180/pi(); @@ -2317,6 +2320,7 @@ drop function pcre_replace(string, strin [ "sys", "current_timestamp", "SYSTEM", "current_timestamp", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "timestamptz", 7, 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", "curtime", "SYSTEM", "current_time", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "timetz", 7, 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", "date_to_str", "SYSTEM", "create function date_to_str(d date, format string) returns string external name mtime.\"date_to_str\";", "mtime", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "d", "date", 0, 0, "in", "format", "clob", 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 ] +[ "sys", "date_trunc", "SYSTEM", "create function sys.date_trunc(txt string, t timestamp) returns timestamp external name sql.date_trunc;", "sql", "MAL", "Scalar function", false, false, false, "result", "timestamp", 7, 0, "out", "txt", "clob", 0, 0, "in", "t", "timestamp", 7, 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 ] [ "sys", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "sec_interval", 13, 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", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "date", 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", "day", "SYSTEM", "day", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "timestamp", 7, 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 ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
