Changeset: 1ac1aaf6bbeb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1ac1aaf6bbeb Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/exports.stable.out monetdb5/modules/atoms/mtime.c monetdb5/modules/atoms/mtime.h monetdb5/modules/atoms/mtime.mal sql/backends/monet5/generator/generator.c sql/backends/monet5/sql.c sql/backends/monet5/sql_datetrunc.c sql/backends/monet5/sql_result.c sql/backends/monet5/sql_scenario.c sql/backends/monet5/wlr.c Branch: mtime Log Message:
Removed MAL types timezone and zrule and their implementations. diffs (truncated from 2528 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 @@ -65,7 +65,7 @@ stdout of test 'MAL-signatures` in direc % .L1, .L1, .L1, .L1, .L1 # table_name % module, function, signature, address, comment # name % clob, clob, clob, clob, clob # type -% 11, 28, 364, 44, 874 # length +% 11, 28, 364, 43, 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", "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" ] [ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on bte" ] @@ -6450,11 +6450,11 @@ stdout of test 'MAL-signatures` in direc [ "batcalc", "cmp", "pattern batcalc.cmp(v:sht, b:bat[:sht], 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]):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", "date", "command batcalc.date(t:bat[:timestamp]):bat[:date] ", "MTIMEtimestamp_extract_date_default_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[:str]):bat[:date] ", "batstr_2_date;", "cast to date" ] [ "batcalc", "daytime", "command batcalc.daytime(s:bat[:lng]):bat[:daytime] ", "MTIMEsecs2daytime_bulk;", "" ] -[ "batcalc", "daytime", "command batcalc.daytime(t:bat[:timestamp]):bat[:daytime] ", "MTIMEtimestamp_extract_daytime_default_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 check for overflow" ] [ "batcalc", "daytime", "command batcalc.daytime(v:bat[:oid]):bat[:daytime] ", "batnil_2_daytime;", "Cast to daytime" ] [ "batcalc", "daytime", "command batcalc.daytime(v:bat[:oid], digits:int):bat[:daytime] ", "batnil_2time_daytime;", "cast to daytime and check for overflow" ] @@ -10146,13 +10146,13 @@ stdout of test 'MAL-signatures` in direc [ "calc", "cmp", "pattern calc.cmp(v1:str, v2:str):bte ", "CMDvarCMP;", "Return -1/0/1 if V1 </==/> V2" ] [ "calc", "date", "command calc.date(d:date):date ", "MTIMEdate_date;", "" ] [ "calc", "date", "command calc.date(s:str):date ", "MTIMEdate_fromstr;", "" ] -[ "calc", "date", "command calc.date(t:timestamp):date ", "MTIMEtimestamp_extract_date_default;", "" ] +[ "calc", "date", "command calc.date(t:timestamp):date ", "MTIMEtimestamp_extract_date;", "" ] [ "calc", "date", "command calc.date(v:void):date ", "nil_2_date;", "cast to date" ] [ "calc", "date", "command calc.date(v:str):date ", "str_2_date;", "cast to date" ] [ "calc", "daytime", "command calc.daytime(d:daytime):daytime ", "MTIMEdaytime2daytime;", "" ] [ "calc", "daytime", "command calc.daytime(s:str):daytime ", "MTIMEdaytime_fromstr;", "" ] [ "calc", "daytime", "command calc.daytime(s:lng):daytime ", "MTIMEsecs2daytime;", "" ] -[ "calc", "daytime", "command calc.daytime(t:timestamp):daytime ", "MTIMEtimestamp_extract_daytime_default;", "" ] +[ "calc", "daytime", "command calc.daytime(t:timestamp):daytime ", "MTIMEtimestamp_extract_daytime;", "" ] [ "calc", "daytime", "command calc.daytime(v:daytime, digits:int):daytime ", "daytime_2time_daytime;", "cast daytime to daytime and check for overflow" ] [ "calc", "daytime", "command calc.daytime(v:void):daytime ", "nil_2_daytime;", "Cast to daytime" ] [ "calc", "daytime", "command calc.daytime(v:void, digits:int):daytime ", "nil_2time_daytime;", "cast to daytime and check for overflow" ] @@ -11359,7 +11359,6 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "adddays", "command mtime.adddays(value:date, days:int):date ", "MTIMEdate_adddays;", "returns the date after a number\n\tof days (possibly negative)." ] [ "mtime", "addmonths", "command mtime.addmonths(value:date, months:int):date ", "MTIMEdate_addmonths;", "returns the date after a number of\n\tmonths (possibly negative)." ] [ "mtime", "addyears", "command mtime.addyears(value:date, years:int):date ", "MTIMEdate_addyears;", "returns the date after a number\n\tof years (possibly negative)." ] -[ "mtime", "compute", "command mtime.compute(r:zrule, year:int):date ", "MTIMEcompute_rule_foryear;", "compute the date from a rule in a given year" ] [ "mtime", "current_date", "command mtime.current_date():date ", "MTIMEcurrent_date;", "" ] [ "mtime", "current_time", "command mtime.current_time():daytime ", "MTIMEcurrent_time;", "" ] [ "mtime", "current_timestamp", "command mtime.current_timestamp():timestamp ", "MTIMEcurrent_timestamp;", "" ] @@ -11367,8 +11366,7 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "date", "command mtime.date(yr:int, mo:int, day:int):date ", "MTIMEdate_create;", "creates a date from (year,month,day)." ] [ "mtime", "date", "command mtime.date(s:str):date ", "MTIMEdate_fromstr;", "convert the string to a type date value" ] [ "mtime", "date", "command mtime.date(X_0:void):date ", "MTIMEnil2date;", "generate the nil date" ] -[ "mtime", "date", "command mtime.date(t:timestamp, v:timezone):date ", "MTIMEtimestamp_extract_date;", "extracts date from timestamp in a\n\tspecific timezone." ] -[ "mtime", "date", "command mtime.date(t:timestamp):date ", "MTIMEtimestamp_extract_date_default;", "extracts date from timestamp\n\tin the local timezone." ] +[ "mtime", "date", "command mtime.date(t:timestamp):date ", "MTIMEtimestamp_extract_date;", "extracts date from timestamp." ] [ "mtime", "date_add_month_interval", "command mtime.date_add_month_interval(t:date, s:int):date ", "MTIMEdate_addmonths;", "Add months to a date" ] [ "mtime", "date_add_msec_interval", "command mtime.date_add_msec_interval(t:date, ms:lng):date ", "MTIMEdate_add_msec_interval_lng_wrap;", "" ] [ "mtime", "date_add_sec_interval", "command mtime.date_add_sec_interval(t:date, s:int):date ", "MTIMEdate_add_sec_interval_wrap;", "Add seconds to a date" ] @@ -11377,7 +11375,6 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "date_sub_sec_interval", "command mtime.date_sub_sec_interval(t:date, s:int):date ", "MTIMEdate_sub_sec_interval_wrap;", "Subtract seconds from a date" ] [ "mtime", "date_to_str", "command mtime.date_to_str(d:date, format:str):str ", "MTIMEdate_to_str;", "create a string from the date, using the specified format (see man strftime)" ] [ "mtime", "day", "command mtime.day(d:date):int ", "MTIMEdate_extract_day;", "extracts day from date " ] -[ "mtime", "day", "command mtime.day(t:zrule):int ", "MTIMErule_extract_day;", "extract day from rule." ] [ "mtime", "day", "command mtime.day(msecs:lng):lng ", "MTIMEsql_day;", "" ] [ "mtime", "day", "command mtime.day(t:timestamp):int ", "MTIMEtimestamp_day;", "" ] [ "mtime", "dayname", "command mtime.dayname(day:int):str ", "MTIMEday_to_str;", "Returns day name from a number\n\tbetween [1-7], str(nil) otherwise." ] @@ -11391,27 +11388,20 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "daytime", "command mtime.daytime(h:int, m:int, s:int, mi:int):daytime ", "MTIMEdaytime_create;", "creates a time from (hours,minutes,\n\tseconds,milliseconds) parameters." ] [ "mtime", "daytime", "command mtime.daytime(s:str):daytime ", "MTIMEdaytime_fromstr;", "convert the string to a daytime value." ] [ "mtime", "daytime", "command mtime.daytime(X_0:lng):daytime ", "MTIMEsecs2daytime;", "" ] -[ "mtime", "daytime", "command mtime.daytime(t:timestamp, v:timezone):daytime ", "MTIMEtimestamp_extract_daytime;", "extracts daytime from timestamp\n\tin a specific timezone." ] -[ "mtime", "daytime", "command mtime.daytime(t:timestamp):daytime ", "MTIMEtimestamp_extract_daytime_default;", "extracts daytime from timestamp\n\tin the local timezone." ] +[ "mtime", "daytime", "command mtime.daytime(t:timestamp):daytime ", "MTIMEtimestamp_extract_daytime;", "extracts daytime from timestamp." ] [ "mtime", "diff", "command mtime.diff(val1:date, val2:date):int ", "MTIMEdate_diff;", "returns the number of days\n\tbetween 'val1' and 'val2'." ] [ "mtime", "diff", "command mtime.diff(val1:daytime, val2:daytime):lng ", "MTIMEdaytime_diff;", "returns the number of msec between 'val1' and 'val2'." ] [ "mtime", "diff", "command mtime.diff(val1:timestamp, val2:timestamp):lng ", "MTIMEtimestamp_diff;", "returns the number of milliseconds\n\tbetween 'val1' and 'val2'." ] -[ "mtime", "dst", "command mtime.dst(t:timestamp, v:timezone):bit ", "MTIMEtimestamp_inside_dst;", "return whether DST holds in the\n\ttimezone at a certain point of time." ] -[ "mtime", "end_dst", "command mtime.end_dst(t:timezone):zrule ", "MTIMEtzone_extract_end;", "extract rule that determines\n\tend of DST from timezone." ] [ "mtime", "epilogue", "command mtime.epilogue():void ", "MTIMEepilogue;", "" ] [ "mtime", "hours", "command mtime.hours(h:daytime):int ", "MTIMEdaytime_extract_hours;", "extracts hour from daytime" ] [ "mtime", "hours", "command mtime.hours(msecs:lng):int ", "MTIMEsql_hours;", "" ] [ "mtime", "hours", "command mtime.hours(t:timestamp):int ", "MTIMEtimestamp_hours;", "" ] -[ "mtime", "local_timezone", "command mtime.local_timezone():lng ", "MTIMElocal_timezone;", "get the local timezone in seconds" ] [ "mtime", "milliseconds", "command mtime.milliseconds(d:daytime):int ", "MTIMEdaytime_extract_milliseconds;", "extracts milliseconds from daytime" ] [ "mtime", "milliseconds", "command mtime.milliseconds(t:timestamp):int ", "MTIMEtimestamp_milliseconds;", "" ] [ "mtime", "minutes", "command mtime.minutes(d:daytime):int ", "MTIMEdaytime_extract_minutes;", "extracts minutes from daytime" ] -[ "mtime", "minutes", "command mtime.minutes(t:zrule):int ", "MTIMErule_extract_minutes;", "extract minutes from rule." ] [ "mtime", "minutes", "command mtime.minutes(msecs:lng):int ", "MTIMEsql_minutes;", "" ] [ "mtime", "minutes", "command mtime.minutes(t:timestamp):int ", "MTIMEtimestamp_minutes;", "" ] -[ "mtime", "minutes", "command mtime.minutes(t:timezone):int ", "MTIMEtzone_extract_minutes;", "extract number of minutes that\n\ttime zone is offset wrt GMT." ] [ "mtime", "month", "command mtime.month(d:date):int ", "MTIMEdate_extract_month;", "extracts month from date" ] -[ "mtime", "month", "command mtime.month(t:zrule):int ", "MTIMErule_extract_month;", "extract month from rule." ] [ "mtime", "month", "command mtime.month(months:int):int ", "MTIMEsql_month;", "" ] [ "mtime", "month", "command mtime.month(t:timestamp):int ", "MTIMEtimestamp_month;", "" ] [ "mtime", "monthname", "command mtime.monthname(month:int):str ", "MTIMEmonth_to_str;", "Returns month name from a number\n\tbetween [1-12], str(nil) otherwise." ] @@ -11421,15 +11411,11 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "prelude", "command mtime.prelude():void ", "MTIMEprelude;", "" ] [ "mtime", "quarter", "command mtime.quarter(d:date):int ", "MTIMEdate_extract_quarter;", "extracts quarter from date" ] [ "mtime", "quarter", "command mtime.quarter(t:timestamp):int ", "MTIMEtimestamp_quarter;", "" ] -[ "mtime", "rule", "command mtime.rule(mo:int, d:int, wkday:int, mi:int):zrule ", "MTIMErule_create;", "create a DST start/end date rule." ] -[ "mtime", "rule", "command mtime.rule(s:str):zrule ", "MTIMErule_fromstr;", "create a rule from a string." ] [ "mtime", "seconds", "command mtime.seconds(d:daytime):int ", "MTIMEdaytime_extract_seconds;", "extracts seconds from daytime" ] [ "mtime", "seconds", "command mtime.seconds(msecs:lng):int ", "MTIMEsql_seconds;", "" ] [ "mtime", "seconds", "command mtime.seconds(t:timestamp):int ", "MTIMEtimestamp_seconds;", "" ] -[ "mtime", "setTimezone", "command mtime.setTimezone(name:str):timezone ", "MTIMEtimezone;", "Test and set the timezone." ] [ "mtime", "sql_seconds", "command mtime.sql_seconds(d:daytime):int ", "MTIMEdaytime_extract_sql_seconds;", "extracts seconds (with fractional milliseconds) from daytime" ] [ "mtime", "sql_seconds", "command mtime.sql_seconds(t:timestamp):int ", "MTIMEtimestamp_sql_seconds;", "" ] -[ "mtime", "start_dst", "command mtime.start_dst(t:timezone):zrule ", "MTIMEtzone_extract_start;", "extract rule that determines\n\tstart of DST from timezone." ] [ "mtime", "str_to_date", "command mtime.str_to_date(s:str, format:str):date ", "MTIMEstr_to_date;", "create a date from the string, using the specified format (see man strptime)" ] [ "mtime", "str_to_time", "command mtime.str_to_time(s:str, format:str):daytime ", "MTIMEstr_to_time;", "create a time from the string, using the specified format (see man strptime)" ] [ "mtime", "str_to_timestamp", "command mtime.str_to_timestamp(s:str, format:str):timestamp ", "MTIMEstr_to_timestamp;", "create a timestamp from the string, using the specified format (see man strptime)" ] @@ -11438,9 +11424,8 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "time_synonyms", "command mtime.time_synonyms(allow:bit):void ", "MTIMEsynonyms;", "Allow synonyms for the parse format of\n\tdate/timestamp." ] [ "mtime", "time_to_str", "command mtime.time_to_str(d:daytime, format:str):str ", "MTIMEtime_to_str;", "create a string from the time, using the specified format (see man strftime)" ] [ "mtime", "timestamp", "command mtime.timestamp(t:timestamp):timestamp ", "MTIMEtimestamp2timestamp;", "" ] -[ "mtime", "timestamp", "command mtime.timestamp(d:date, dt:daytime, t:timezone):timestamp ", "MTIMEtimestamp_create;", "creates a timestamp from (date, daytime,timezone) parameters." ] -[ "mtime", "timestamp", "command mtime.timestamp(d:date, dt:daytime):timestamp ", "MTIMEtimestamp_create_default;", "creates a timestamp from (d,dt) parameters (in the local timezone)." ] -[ "mtime", "timestamp", "command mtime.timestamp(d:date):timestamp ", "MTIMEtimestamp_create_from_date;", "creates a timestamp from (d,00:00:00) parameters (in the local timezone)." ] +[ "mtime", "timestamp", "command mtime.timestamp(d:date, dt:daytime):timestamp ", "MTIMEtimestamp_create;", "creates a timestamp from (date, daytime) parameters." ] +[ "mtime", "timestamp", "command mtime.timestamp(d:date):timestamp ", "MTIMEtimestamp_create_from_date;", "creates a timestamp from (d,00:00:00) parameters." ] [ "mtime", "timestamp_add_month_interval", "command mtime.timestamp_add_month_interval(t:timestamp, s:lng):timestamp ", "MTIMEtimestamp_add_month_interval_lng_wrap;", "Add months to a timestamp" ] [ "mtime", "timestamp_add_month_interval", "command mtime.timestamp_add_month_interval(t:timestamp, s:int):timestamp ", "MTIMEtimestamp_add_month_interval_wrap;", "Add months to a timestamp" ] [ "mtime", "timestamp_add_msec_interval", "command mtime.timestamp_add_msec_interval(t:timestamp, ms:lng):timestamp ", "MTIMEtimestamp_add;", "" ] @@ -11448,14 +11433,7 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "timestamp_sub_month_interval", "command mtime.timestamp_sub_month_interval(t:timestamp, s:int):timestamp ", "MTIMEtimestamp_sub_month_interval_wrap;", "Subtract months from a timestamp" ] [ "mtime", "timestamp_sub_msec_interval", "command mtime.timestamp_sub_msec_interval(t:timestamp, ms:lng):timestamp ", "MTIMEtimestamp_sub_msec_interval_lng_wrap;", "" ] [ "mtime", "timestamp_to_str", "command mtime.timestamp_to_str(d:timestamp, format:str):str ", "MTIMEtimestamp_to_str;", "create a string from the time, using the specified format (see man strftime)" ] -[ "mtime", "timezone", "command mtime.timezone(s:int):timezone ", "MTIMEtzone_create;", "Convert the int to a timezone." ] -[ "mtime", "timezone", "command mtime.timezone(mi:int, s:zrule, erule:zrule):timezone ", "MTIMEtzone_create_dst;", "create a timezone as an hour difference\n\tfrom GMT and a DST." ] -[ "mtime", "timezone", "command mtime.timezone(s:lng):timezone ", "MTIMEtzone_create_lng;", "Convert the int to a timezone." ] -[ "mtime", "timezone", "command mtime.timezone(s:str):timezone ", "MTIMEtzone_fromstr;", "Convert the string to a timezone." ] -[ "mtime", "timezone_local", "command mtime.timezone_local():timezone ", "MTIMEtzone_get_local;", "get the local timezone; which is used for printing timestamps" ] -[ "mtime", "timezone_local", "command mtime.timezone_local(t:timezone):void ", "MTIMEtzone_set_local;", "set the local timezone; which is used for printing timestamps" ] [ "mtime", "week", "command mtime.week(d:date):int ", "MTIMEdate_extract_weekofyear;", "Returns the week number in the year." ] -[ "mtime", "weekday", "command mtime.weekday(t:zrule):int ", "MTIMErule_extract_weekday;", "extract weekday from rule." ] [ "mtime", "weekofyear", "command mtime.weekofyear(d:date):int ", "MTIMEdate_extract_weekofyear;", "Returns the week number in the year." ] [ "mtime", "year", "command mtime.year(d:date):int ", "MTIMEdate_extract_year;", "extracts year from date (nonzero\n\tvalue between -5867411 and +5867411)." ] [ "mtime", "year", "command mtime.year(months:int):int ", "MTIMEsql_year;", "" ] @@ -11990,11 +11968,6 @@ stdout of test 'MAL-signatures` in direc [ "timestamp", "epoch", "command timestamp.epoch(t:lng):timestamp ", "MTIMEtimestamplng;", "convert milli seconds since epoch into a timestamp" ] [ "timestamp", "isnil", "pattern timestamp.isnil(v:timestamp):bit ", "CMDvarISNIL;", "Nil test for timestamp value" ] [ "timestamp", "unix_epoch", "unsafe command timestamp.unix_epoch():timestamp ", "MTIMEunix_epoch;", "The Unix epoch time (00:00:00 UTC on January 1, 1970)" ] -[ "timezone", "#fromstr", "command timezone.#fromstr():void ", "tzone_fromstr;", "" ] -[ "timezone", "#tostr", "command timezone.#tostr():void ", "tzone_tostr;", "" ] -[ "timezone", "str", "command timezone.str(z:timezone):str ", "MTIMEtzone_tostr;", "" ] -[ "timezone", "timestamp", "command timezone.timestamp(secs:int):timestamp ", "MTIMEtimestamp;", "Utility function to create a timestamp from a number of seconds since the Unix epoch" ] -[ "timezone", "timestamp", "command timezone.timestamp(s:str):timestamp ", "MTIMEtimestamp_fromstr;", "" ] [ "tokenizer", "append", "command tokenizer.append(u:str):oid ", "TKNZRappend;", "tokenize a new string and append it to the tokenizer (duplicate elimination is performed)" ] [ "tokenizer", "close", "command tokenizer.close():void ", "TKNZRclose;", "close the current tokenizer store" ] [ "tokenizer", "depositFile", "command tokenizer.depositFile(fnme:str):void ", "TKNZRdepositFile;", "batch insertion from a file of strings to tokenize, each string is separated by a new line" ] @@ -12231,11 +12204,6 @@ stdout of test 'MAL-signatures` in direc [ "xml", "subaggr", "command xml.subaggr(val:bat[:xml], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit):bat[:xml] ", "AGGRsubxmlcand;", "Grouped aggregation of XML values with candidates list." ] [ "xml", "text", "command xml.text(src:xml):str ", "XMLxmltext;", "Extract text from an xml atom" ] [ "xml", "xml", "command xml.xml(src:str):xml ", "XMLstr2xml;", "Cast the string to an xml compliant string" ] -[ "zrule", "#fromstr", "command zrule.#fromstr():void ", "rule_fromstr;", "" ] -[ "zrule", "#tostr", "command zrule.#tostr():void ", "rule_tostr;", "" ] -[ "zrule", "define", "command zrule.define(m:int, d:int, w:int, h:int, min:int):zrule ", "MTIMEruleDef0;", "Introduce a synomym timezone rule." ] -[ "zrule", "define", "command zrule.define(m:int, d:str, w:int, h:int, min:int):zrule ", "MTIMEruleDef1;", "Introduce a synomym timezone rule." ] -[ "zrule", "define", "command zrule.define(m:int, d:str, w:int, min:int):zrule ", "MTIMEruleDef2;", "Introduce a synomym timezone rule." ] # 14:47:14 > # 14:47:14 > "Done." 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 @@ -69,7 +69,7 @@ stdout of test 'MAL-signatures` in direc % .L1, .L1, .L1, .L1, .L1 # table_name % module, function, signature, address, comment # name % clob, clob, clob, clob, clob # type -% 11, 28, 364, 44, 874 # length +% 11, 28, 364, 43, 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", "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" ] [ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on bte" ] @@ -9081,11 +9081,11 @@ stdout of test 'MAL-signatures` in direc [ "batcalc", "cmp", "pattern batcalc.cmp(v:sht, b:bat[:sht], 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]):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", "date", "command batcalc.date(t:bat[:timestamp]):bat[:date] ", "MTIMEtimestamp_extract_date_default_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[:str]):bat[:date] ", "batstr_2_date;", "cast to date" ] [ "batcalc", "daytime", "command batcalc.daytime(s:bat[:lng]):bat[:daytime] ", "MTIMEsecs2daytime_bulk;", "" ] -[ "batcalc", "daytime", "command batcalc.daytime(t:bat[:timestamp]):bat[:daytime] ", "MTIMEtimestamp_extract_daytime_default_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 check for overflow" ] [ "batcalc", "daytime", "command batcalc.daytime(v:bat[:oid]):bat[:daytime] ", "batnil_2_daytime;", "Cast to daytime" ] [ "batcalc", "daytime", "command batcalc.daytime(v:bat[:oid], digits:int):bat[:daytime] ", "batnil_2time_daytime;", "cast to daytime and check for overflow" ] @@ -14316,13 +14316,13 @@ stdout of test 'MAL-signatures` in direc [ "calc", "cmp", "pattern calc.cmp(v1:str, v2:str):bte ", "CMDvarCMP;", "Return -1/0/1 if V1 </==/> V2" ] [ "calc", "date", "command calc.date(d:date):date ", "MTIMEdate_date;", "" ] [ "calc", "date", "command calc.date(s:str):date ", "MTIMEdate_fromstr;", "" ] -[ "calc", "date", "command calc.date(t:timestamp):date ", "MTIMEtimestamp_extract_date_default;", "" ] +[ "calc", "date", "command calc.date(t:timestamp):date ", "MTIMEtimestamp_extract_date;", "" ] [ "calc", "date", "command calc.date(v:void):date ", "nil_2_date;", "cast to date" ] [ "calc", "date", "command calc.date(v:str):date ", "str_2_date;", "cast to date" ] [ "calc", "daytime", "command calc.daytime(d:daytime):daytime ", "MTIMEdaytime2daytime;", "" ] [ "calc", "daytime", "command calc.daytime(s:str):daytime ", "MTIMEdaytime_fromstr;", "" ] [ "calc", "daytime", "command calc.daytime(s:lng):daytime ", "MTIMEsecs2daytime;", "" ] -[ "calc", "daytime", "command calc.daytime(t:timestamp):daytime ", "MTIMEtimestamp_extract_daytime_default;", "" ] +[ "calc", "daytime", "command calc.daytime(t:timestamp):daytime ", "MTIMEtimestamp_extract_daytime;", "" ] [ "calc", "daytime", "command calc.daytime(v:daytime, digits:int):daytime ", "daytime_2time_daytime;", "cast daytime to daytime and check for overflow" ] [ "calc", "daytime", "command calc.daytime(v:void):daytime ", "nil_2_daytime;", "Cast to daytime" ] [ "calc", "daytime", "command calc.daytime(v:void, digits:int):daytime ", "nil_2time_daytime;", "cast to daytime and check for overflow" ] @@ -15771,7 +15771,6 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "adddays", "command mtime.adddays(value:date, days:int):date ", "MTIMEdate_adddays;", "returns the date after a number\n\tof days (possibly negative)." ] [ "mtime", "addmonths", "command mtime.addmonths(value:date, months:int):date ", "MTIMEdate_addmonths;", "returns the date after a number of\n\tmonths (possibly negative)." ] [ "mtime", "addyears", "command mtime.addyears(value:date, years:int):date ", "MTIMEdate_addyears;", "returns the date after a number\n\tof years (possibly negative)." ] -[ "mtime", "compute", "command mtime.compute(r:zrule, year:int):date ", "MTIMEcompute_rule_foryear;", "compute the date from a rule in a given year" ] [ "mtime", "current_date", "command mtime.current_date():date ", "MTIMEcurrent_date;", "" ] [ "mtime", "current_time", "command mtime.current_time():daytime ", "MTIMEcurrent_time;", "" ] [ "mtime", "current_timestamp", "command mtime.current_timestamp():timestamp ", "MTIMEcurrent_timestamp;", "" ] @@ -15779,8 +15778,7 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "date", "command mtime.date(yr:int, mo:int, day:int):date ", "MTIMEdate_create;", "creates a date from (year,month,day)." ] [ "mtime", "date", "command mtime.date(s:str):date ", "MTIMEdate_fromstr;", "convert the string to a type date value" ] [ "mtime", "date", "command mtime.date(X_0:void):date ", "MTIMEnil2date;", "generate the nil date" ] -[ "mtime", "date", "command mtime.date(t:timestamp, v:timezone):date ", "MTIMEtimestamp_extract_date;", "extracts date from timestamp in a\n\tspecific timezone." ] -[ "mtime", "date", "command mtime.date(t:timestamp):date ", "MTIMEtimestamp_extract_date_default;", "extracts date from timestamp\n\tin the local timezone." ] +[ "mtime", "date", "command mtime.date(t:timestamp):date ", "MTIMEtimestamp_extract_date;", "extracts date from timestamp." ] [ "mtime", "date_add_month_interval", "command mtime.date_add_month_interval(t:date, s:int):date ", "MTIMEdate_addmonths;", "Add months to a date" ] [ "mtime", "date_add_msec_interval", "command mtime.date_add_msec_interval(t:date, ms:lng):date ", "MTIMEdate_add_msec_interval_lng_wrap;", "" ] [ "mtime", "date_add_sec_interval", "command mtime.date_add_sec_interval(t:date, s:int):date ", "MTIMEdate_add_sec_interval_wrap;", "Add seconds to a date" ] @@ -15789,7 +15787,6 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "date_sub_sec_interval", "command mtime.date_sub_sec_interval(t:date, s:int):date ", "MTIMEdate_sub_sec_interval_wrap;", "Subtract seconds from a date" ] [ "mtime", "date_to_str", "command mtime.date_to_str(d:date, format:str):str ", "MTIMEdate_to_str;", "create a string from the date, using the specified format (see man strftime)" ] [ "mtime", "day", "command mtime.day(d:date):int ", "MTIMEdate_extract_day;", "extracts day from date " ] -[ "mtime", "day", "command mtime.day(t:zrule):int ", "MTIMErule_extract_day;", "extract day from rule." ] [ "mtime", "day", "command mtime.day(msecs:lng):lng ", "MTIMEsql_day;", "" ] [ "mtime", "day", "command mtime.day(t:timestamp):int ", "MTIMEtimestamp_day;", "" ] [ "mtime", "dayname", "command mtime.dayname(day:int):str ", "MTIMEday_to_str;", "Returns day name from a number\n\tbetween [1-7], str(nil) otherwise." ] @@ -15803,27 +15800,20 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "daytime", "command mtime.daytime(h:int, m:int, s:int, mi:int):daytime ", "MTIMEdaytime_create;", "creates a time from (hours,minutes,\n\tseconds,milliseconds) parameters." ] [ "mtime", "daytime", "command mtime.daytime(s:str):daytime ", "MTIMEdaytime_fromstr;", "convert the string to a daytime value." ] [ "mtime", "daytime", "command mtime.daytime(X_0:lng):daytime ", "MTIMEsecs2daytime;", "" ] -[ "mtime", "daytime", "command mtime.daytime(t:timestamp, v:timezone):daytime ", "MTIMEtimestamp_extract_daytime;", "extracts daytime from timestamp\n\tin a specific timezone." ] -[ "mtime", "daytime", "command mtime.daytime(t:timestamp):daytime ", "MTIMEtimestamp_extract_daytime_default;", "extracts daytime from timestamp\n\tin the local timezone." ] +[ "mtime", "daytime", "command mtime.daytime(t:timestamp):daytime ", "MTIMEtimestamp_extract_daytime;", "extracts daytime from timestamp." ] [ "mtime", "diff", "command mtime.diff(val1:date, val2:date):int ", "MTIMEdate_diff;", "returns the number of days\n\tbetween 'val1' and 'val2'." ] [ "mtime", "diff", "command mtime.diff(val1:daytime, val2:daytime):lng ", "MTIMEdaytime_diff;", "returns the number of msec between 'val1' and 'val2'." ] [ "mtime", "diff", "command mtime.diff(val1:timestamp, val2:timestamp):lng ", "MTIMEtimestamp_diff;", "returns the number of milliseconds\n\tbetween 'val1' and 'val2'." ] -[ "mtime", "dst", "command mtime.dst(t:timestamp, v:timezone):bit ", "MTIMEtimestamp_inside_dst;", "return whether DST holds in the\n\ttimezone at a certain point of time." ] -[ "mtime", "end_dst", "command mtime.end_dst(t:timezone):zrule ", "MTIMEtzone_extract_end;", "extract rule that determines\n\tend of DST from timezone." ] [ "mtime", "epilogue", "command mtime.epilogue():void ", "MTIMEepilogue;", "" ] [ "mtime", "hours", "command mtime.hours(h:daytime):int ", "MTIMEdaytime_extract_hours;", "extracts hour from daytime" ] [ "mtime", "hours", "command mtime.hours(msecs:lng):int ", "MTIMEsql_hours;", "" ] [ "mtime", "hours", "command mtime.hours(t:timestamp):int ", "MTIMEtimestamp_hours;", "" ] -[ "mtime", "local_timezone", "command mtime.local_timezone():lng ", "MTIMElocal_timezone;", "get the local timezone in seconds" ] [ "mtime", "milliseconds", "command mtime.milliseconds(d:daytime):int ", "MTIMEdaytime_extract_milliseconds;", "extracts milliseconds from daytime" ] [ "mtime", "milliseconds", "command mtime.milliseconds(t:timestamp):int ", "MTIMEtimestamp_milliseconds;", "" ] [ "mtime", "minutes", "command mtime.minutes(d:daytime):int ", "MTIMEdaytime_extract_minutes;", "extracts minutes from daytime" ] -[ "mtime", "minutes", "command mtime.minutes(t:zrule):int ", "MTIMErule_extract_minutes;", "extract minutes from rule." ] [ "mtime", "minutes", "command mtime.minutes(msecs:lng):int ", "MTIMEsql_minutes;", "" ] [ "mtime", "minutes", "command mtime.minutes(t:timestamp):int ", "MTIMEtimestamp_minutes;", "" ] -[ "mtime", "minutes", "command mtime.minutes(t:timezone):int ", "MTIMEtzone_extract_minutes;", "extract number of minutes that\n\ttime zone is offset wrt GMT." ] [ "mtime", "month", "command mtime.month(d:date):int ", "MTIMEdate_extract_month;", "extracts month from date" ] -[ "mtime", "month", "command mtime.month(t:zrule):int ", "MTIMErule_extract_month;", "extract month from rule." ] [ "mtime", "month", "command mtime.month(months:int):int ", "MTIMEsql_month;", "" ] [ "mtime", "month", "command mtime.month(t:timestamp):int ", "MTIMEtimestamp_month;", "" ] [ "mtime", "monthname", "command mtime.monthname(month:int):str ", "MTIMEmonth_to_str;", "Returns month name from a number\n\tbetween [1-12], str(nil) otherwise." ] @@ -15833,15 +15823,11 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "prelude", "command mtime.prelude():void ", "MTIMEprelude;", "" ] [ "mtime", "quarter", "command mtime.quarter(d:date):int ", "MTIMEdate_extract_quarter;", "extracts quarter from date" ] [ "mtime", "quarter", "command mtime.quarter(t:timestamp):int ", "MTIMEtimestamp_quarter;", "" ] -[ "mtime", "rule", "command mtime.rule(mo:int, d:int, wkday:int, mi:int):zrule ", "MTIMErule_create;", "create a DST start/end date rule." ] -[ "mtime", "rule", "command mtime.rule(s:str):zrule ", "MTIMErule_fromstr;", "create a rule from a string." ] [ "mtime", "seconds", "command mtime.seconds(d:daytime):int ", "MTIMEdaytime_extract_seconds;", "extracts seconds from daytime" ] [ "mtime", "seconds", "command mtime.seconds(msecs:lng):int ", "MTIMEsql_seconds;", "" ] [ "mtime", "seconds", "command mtime.seconds(t:timestamp):int ", "MTIMEtimestamp_seconds;", "" ] -[ "mtime", "setTimezone", "command mtime.setTimezone(name:str):timezone ", "MTIMEtimezone;", "Test and set the timezone." ] [ "mtime", "sql_seconds", "command mtime.sql_seconds(d:daytime):int ", "MTIMEdaytime_extract_sql_seconds;", "extracts seconds (with fractional milliseconds) from daytime" ] [ "mtime", "sql_seconds", "command mtime.sql_seconds(t:timestamp):int ", "MTIMEtimestamp_sql_seconds;", "" ] -[ "mtime", "start_dst", "command mtime.start_dst(t:timezone):zrule ", "MTIMEtzone_extract_start;", "extract rule that determines\n\tstart of DST from timezone." ] [ "mtime", "str_to_date", "command mtime.str_to_date(s:str, format:str):date ", "MTIMEstr_to_date;", "create a date from the string, using the specified format (see man strptime)" ] [ "mtime", "str_to_time", "command mtime.str_to_time(s:str, format:str):daytime ", "MTIMEstr_to_time;", "create a time from the string, using the specified format (see man strptime)" ] [ "mtime", "str_to_timestamp", "command mtime.str_to_timestamp(s:str, format:str):timestamp ", "MTIMEstr_to_timestamp;", "create a timestamp from the string, using the specified format (see man strptime)" ] @@ -15850,9 +15836,8 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "time_synonyms", "command mtime.time_synonyms(allow:bit):void ", "MTIMEsynonyms;", "Allow synonyms for the parse format of\n\tdate/timestamp." ] [ "mtime", "time_to_str", "command mtime.time_to_str(d:daytime, format:str):str ", "MTIMEtime_to_str;", "create a string from the time, using the specified format (see man strftime)" ] [ "mtime", "timestamp", "command mtime.timestamp(t:timestamp):timestamp ", "MTIMEtimestamp2timestamp;", "" ] -[ "mtime", "timestamp", "command mtime.timestamp(d:date, dt:daytime, t:timezone):timestamp ", "MTIMEtimestamp_create;", "creates a timestamp from (date, daytime,timezone) parameters." ] -[ "mtime", "timestamp", "command mtime.timestamp(d:date, dt:daytime):timestamp ", "MTIMEtimestamp_create_default;", "creates a timestamp from (d,dt) parameters (in the local timezone)." ] -[ "mtime", "timestamp", "command mtime.timestamp(d:date):timestamp ", "MTIMEtimestamp_create_from_date;", "creates a timestamp from (d,00:00:00) parameters (in the local timezone)." ] +[ "mtime", "timestamp", "command mtime.timestamp(d:date, dt:daytime):timestamp ", "MTIMEtimestamp_create;", "creates a timestamp from (date, daytime) parameters." ] +[ "mtime", "timestamp", "command mtime.timestamp(d:date):timestamp ", "MTIMEtimestamp_create_from_date;", "creates a timestamp from (d,00:00:00) parameters." ] [ "mtime", "timestamp_add_month_interval", "command mtime.timestamp_add_month_interval(t:timestamp, s:lng):timestamp ", "MTIMEtimestamp_add_month_interval_lng_wrap;", "Add months to a timestamp" ] [ "mtime", "timestamp_add_month_interval", "command mtime.timestamp_add_month_interval(t:timestamp, s:int):timestamp ", "MTIMEtimestamp_add_month_interval_wrap;", "Add months to a timestamp" ] [ "mtime", "timestamp_add_msec_interval", "command mtime.timestamp_add_msec_interval(t:timestamp, ms:lng):timestamp ", "MTIMEtimestamp_add;", "" ] @@ -15860,14 +15845,7 @@ stdout of test 'MAL-signatures` in direc [ "mtime", "timestamp_sub_month_interval", "command mtime.timestamp_sub_month_interval(t:timestamp, s:int):timestamp ", "MTIMEtimestamp_sub_month_interval_wrap;", "Subtract months from a timestamp" ] [ "mtime", "timestamp_sub_msec_interval", "command mtime.timestamp_sub_msec_interval(t:timestamp, ms:lng):timestamp ", "MTIMEtimestamp_sub_msec_interval_lng_wrap;", "" ] [ "mtime", "timestamp_to_str", "command mtime.timestamp_to_str(d:timestamp, format:str):str ", "MTIMEtimestamp_to_str;", "create a string from the time, using the specified format (see man strftime)" ] -[ "mtime", "timezone", "command mtime.timezone(s:int):timezone ", "MTIMEtzone_create;", "Convert the int to a timezone." ] -[ "mtime", "timezone", "command mtime.timezone(mi:int, s:zrule, erule:zrule):timezone ", "MTIMEtzone_create_dst;", "create a timezone as an hour difference\n\tfrom GMT and a DST." ] -[ "mtime", "timezone", "command mtime.timezone(s:lng):timezone ", "MTIMEtzone_create_lng;", "Convert the int to a timezone." ] -[ "mtime", "timezone", "command mtime.timezone(s:str):timezone ", "MTIMEtzone_fromstr;", "Convert the string to a timezone." ] -[ "mtime", "timezone_local", "command mtime.timezone_local():timezone ", "MTIMEtzone_get_local;", "get the local timezone; which is used for printing timestamps" ] -[ "mtime", "timezone_local", "command mtime.timezone_local(t:timezone):void ", "MTIMEtzone_set_local;", "set the local timezone; which is used for printing timestamps" ] [ "mtime", "week", "command mtime.week(d:date):int ", "MTIMEdate_extract_weekofyear;", "Returns the week number in the year." ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
