Changeset: ad70d442b192 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ad70d442b192
Added Files:
sql/server/sql_var.c
sql/test/scoping/Tests/All
sql/test/scoping/Tests/SingleServer
sql/test/scoping/Tests/ambiguity.sql
sql/test/scoping/Tests/ambiguity.stable.err
sql/test/scoping/Tests/ambiguity.stable.out
sql/test/scoping/Tests/predefinedvariable.sql
sql/test/scoping/Tests/predefinedvariable.stable.err
sql/test/scoping/Tests/predefinedvariable.stable.out
sql/test/scoping/Tests/schema_disambiguity.sql
sql/test/scoping/Tests/schema_disambiguity.stable.err
sql/test/scoping/Tests/schema_disambiguity.stable.out
sql/test/scoping/Tests/scoping01.sql
sql/test/scoping/Tests/scoping01.stable.err
sql/test/scoping/Tests/scoping01.stable.out
sql/test/scoping/Tests/scoping02.sql
sql/test/scoping/Tests/scoping02.stable.err
sql/test/scoping/Tests/scoping02.stable.out
sql/test/scoping/Tests/scoping03.sql
sql/test/scoping/Tests/scoping03.stable.err
sql/test/scoping/Tests/scoping03.stable.out
Removed Files:
sql/test/Tests/fsum1.stable.out
Modified Files:
.bumpversion.cfg
.hgtags
MonetDB.spec
NT/monetdb_config.h.in
NT/rules.msc
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
clients/mapiclient/mhelp.c
clients/mapilib/mapi.rc
clients/odbc/driver/driver.rc
clients/odbc/winsetup/setup.rc
debian/changelog
gdk/gdk_time.c
gdk/gdk_time.h
gdk/libbat.rc
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.sql
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
monetdb5/modules/atoms/mtime.c
monetdb5/modules/atoms/mtime.mal
monetdb5/modules/mal/batmtime.mal
monetdb5/tools/libmonetdb5.rc
sql/ChangeLog
sql/backends/monet5/rel_bin.c
sql/backends/monet5/sql.c
sql/backends/monet5/sql.mal
sql/backends/monet5/sql_cat.c
sql/backends/monet5/sql_execute.c
sql/backends/monet5/sql_gencode.c
sql/backends/monet5/sql_optimizer.c
sql/backends/monet5/sql_orderidx.c
sql/backends/monet5/sql_result.c
sql/backends/monet5/sql_scenario.c
sql/backends/monet5/sql_statement.c
sql/backends/monet5/sql_statement.h
sql/backends/monet5/sql_statistics.c
sql/backends/monet5/sql_upgrades.c
sql/backends/monet5/sql_user.c
sql/common/sql_hash.c
sql/common/sql_list.c
sql/include/sql_catalog.h
sql/include/sql_hash.h
sql/include/sql_relation.h
sql/rel.txt
sql/server/CMakeLists.txt
sql/server/rel_dump.c
sql/server/rel_exp.c
sql/server/rel_exp.h
sql/server/rel_psm.c
sql/server/rel_rel.c
sql/server/rel_schema.c
sql/server/rel_schema.h
sql/server/rel_select.c
sql/server/rel_semantic.c
sql/server/rel_sequence.c
sql/server/rel_updates.c
sql/server/sql_env.c
sql/server/sql_env.h
sql/server/sql_mvc.c
sql/server/sql_mvc.h
sql/server/sql_parser.y
sql/server/sql_privileges.c
sql/server/sql_privileges.h
sql/server/sql_scan.c
sql/server/sql_semantic.c
sql/server/sql_semantic.h
sql/storage/sql_storage.h
sql/storage/store.c
sql/test/BugConstraints/add_constraint_1643522.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.sql
sql/test/BugTracker-2009/Tests/set_and_arg_null.SF-2812729.sql
sql/test/BugTracker-2009/Tests/set_and_arg_null.SF-2812729.stable.out
sql/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.sql
sql/test/BugTracker-2010/Tests/with_row_number_crash.Bug-2631.sql
sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.sql
sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.stable.out
sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.sql
sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.stable.out
sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.sql
sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out
sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql
sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.stable.err
sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.stable.out
sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.sql
sql/test/BugTracker-2015/Tests/schema-trigger.Bug-3710.sql
sql/test/BugTracker-2015/Tests/schema_view2.Bug-3766.sql
sql/test/BugTracker-2017/Tests/error-clean-cache.Bug-6351.sql
sql/test/BugTracker-2017/Tests/error-clean-cache.Bug-6351.stable.err
sql/test/BugTracker-2017/Tests/error-clean-cache.Bug-6351.stable.out
sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.stable.err
sql/test/BugTracker-2018/Tests/comment-on-table-is-null.Bug-6639.sql
sql/test/BugTracker-2019/Tests/alter_table_drop_column.Bug-6749.py
sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.sql
sql/test/BugTracker-2019/Tests/set-schema-mclient-msg.Bug-6754.sql
sql/test/BugTracker-2019/Tests/set-schema-mclient-msg.Bug-6754.stable.out
sql/test/BugTracker/Tests/variables.SF-1508160.stable.err
sql/test/BugTracker/Tests/variables.SF-1508160.stable.out
sql/test/Dependencies/dependency_DBobjects.sql
sql/test/Dependencies/dependency_functions.sql
sql/test/Dependencies/dependency_owner_schema_3.sql
sql/test/DropCascade/Tests/drop_columns_cascade.sql
sql/test/DropCascade/Tests/drop_function_cascade.sql
sql/test/DropCascade/Tests/drop_pkey_cascade.sql
sql/test/DropCascade/Tests/drop_table_cascade.sql
sql/test/DropCascade/Tests/drop_view_cascade.sql
sql/test/SQLite_regress/sqllogictest/Tests/All
sql/test/Tests/comment-on.stable.err
sql/test/Tests/keys.sql
sql/test/Tests/procedure_syntax.sql
sql/test/Tests/session_vars.sql
sql/test/Tests/session_vars.stable.err
sql/test/Tests/session_vars.stable.out
sql/test/Tests/zones.sql
sql/test/Triggers/cascaded_triggers.sql
sql/test/Triggers/referencing_clause_new.sql
sql/test/Triggers/referencing_clause_old.sql
sql/test/Triggers/trigger_activation.sql
sql/test/Triggers/triggers_schema_operations.sql
sql/test/Users/Tests/metadataConsistency.sql
sql/test/Users/Tests/metadataConsistency.stable.out
sql/test/Via-m/Tests/event_s03.stable.out
sql/test/Via-m/Tests/event_s05.stable.out
sql/test/Via-m/Tests/event_s07.stable.err
sql/test/Via-m/Tests/event_s09.stable.out
sql/test/Via-m/Tests/event_s11.stable.err
sql/test/Via-m/Tests/event_s11.stable.out
sql/test/Via-m/Tests/file_s04.stable.out
sql/test/Via-m/Tests/file_s05.stable.out
sql/test/Via-m/Tests/file_s06.stable.out
sql/test/Via-m/Tests/file_s08.stable.out
sql/test/Via-m/Tests/file_s10.stable.err
sql/test/Via-m/Tests/file_s12.stable.err
sql/test/Via-m/Tests/file_s15.stable.out
sql/test/Via-m/Tests/media_s04.stable.out
sql/test/Via-m/Tests/media_s06.stable.out
sql/test/Via-m/Tests/media_s08.stable.out
sql/test/Via-m/Tests/media_s10.stable.out
sql/test/Via-m/Tests/media_s12.stable.err
sql/test/Via-m/Tests/media_s14.stable.err
sql/test/Via-m/Tests/media_s16.stable.err
sql/test/Via-m/Tests/media_s18.stable.err
sql/test/Via-m/Tests/media_s19.stable.err
sql/test/Via-m/insert_event1.sql
sql/test/Via-m/insert_event2.sql
sql/test/Via-m/insert_event3.sql
sql/test/Via-m/insert_event4.sql
sql/test/Via-m/insert_file2.sql
sql/test/Via-m/insert_file3.sql
sql/test/Via-m/insert_file4.sql
sql/test/Via-m/insert_file5.sql
sql/test/Via-m/insert_file6.sql
sql/test/Via-m/insert_file7.sql
sql/test/Via-m/insert_file8.sql
sql/test/Via-m/insert_media1.sql
sql/test/Via-m/insert_media2.sql
sql/test/Via-m/insert_media3.sql
sql/test/Via-m/insert_media4.sql
sql/test/Via-m/insert_media5.sql
sql/test/Via-m/insert_media6.sql
sql/test/Via-m/insert_media7.sql
sql/test/bugs/Tests/create_insert_select_aggr-bug-00001.sql
sql/test/bugs/Tests/create_insert_select_aggr-bug-00001.stable.err
sql/test/bugs/Tests/union_all-bug-sf-941788.sql
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.SQL.py
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/in-value-list/Tests/various-in-value-list-queries.sql
sql/test/json/Tests/components.sql
sql/test/json/Tests/pathexpr.sql
sql/test/mapi/Tests/sql_int128.sql
sql/test/mapi/Tests/sql_int128.stable.out.int128
sql/test/mergetables/Tests/part-elim.sql
sql/test/mergetables/Tests/part-elim.stable.out
sql/test/miscellaneous/Tests/All
sql/test/miscellaneous/Tests/deallocate.sql
sql/test/miscellaneous/Tests/deallocate.stable.out
sql/test/miscellaneous/Tests/declared_tables.sql
sql/test/miscellaneous/Tests/declared_tables.stable.err
sql/test/miscellaneous/Tests/declared_tables.stable.out
sql/test/miscellaneous/Tests/simple_selects.sql
sql/test/miscellaneous/Tests/simple_selects.stable.err
sql/test/miscellaneous/Tests/simple_selects.stable.out
sql/test/miscellaneous/Tests/table_udf_missing_var.py
sql/test/miscellaneous/Tests/table_udf_missing_var.stable.err
sql/test/miscellaneous/Tests/table_udf_missing_var.stable.out
sql/test/orderidx/Tests/imprints_all_types.sql
sql/test/orderidx/Tests/oidx_all_types.sql
sql/test/pg_regress/Tests/alter_table.stable.err
sql/test/pg_regress/Tests/horology.stable.err
sql/test/pg_regress/Tests/timestamp.sql
sql/test/pg_regress/Tests/timestamp.stable.out
sql/test/pg_regress/Tests/timestamptz.sql
sql/test/pg_regress/Tests/timestamptz.stable.out
sql/test/ssqq/Tests/insert_query.stable.err
sql/test/ssqq/Tests/insert_query.stable.out
sql/test/ssqq/Tests/insert_queue.stable.err
sql/test/ssqq/Tests/insert_queue.stable.out
sql/test/ssqq/Tests/insert_quser.stable.err
sql/test/ssqq/Tests/insert_quser.stable.out
sql/test/ssqq/insert_query.sql
sql/test/ssqq/insert_queue.sql
sql/test/ssqq/insert_quser.sql
sql/test/subquery/Tests/subquery4.sql
sql/test/subquery/Tests/subquery4.stable.err
sql/test/subquery/Tests/subquery4.stable.out
sql/test/subquery/Tests/subquery6.sql
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
Branch: mbedded
Log Message:
merged with default ....
diffs (truncated from 16382 to 300 lines):
diff --git a/.bumpversion.cfg b/.bumpversion.cfg
--- a/.bumpversion.cfg
+++ b/.bumpversion.cfg
@@ -6,6 +6,8 @@ tag = False
[bumpversion:file:configure.ag]
[bumpversion:file:MonetDB.spec]
+search = %global version {current_version}
+replace = %global version {new_version}
[bumpversion:file:NT/rules.msc]
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -772,3 +772,6 @@ 0d51d6758f2b1f3f1804415545f8551a38da1848
28480e096722b7f76ab021c0d16c68c6949f41b4 Jun2020_5
0d51d6758f2b1f3f1804415545f8551a38da1848 Jun2020_release
28480e096722b7f76ab021c0d16c68c6949f41b4 Jun2020_release
+80bd3e89c48032840f493a63d6c4c12ee6273b3d Jun2020_7
+28480e096722b7f76ab021c0d16c68c6949f41b4 Jun2020_release
+80bd3e89c48032840f493a63d6c4c12ee6273b3d Jun2020_release
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -984,6 +984,9 @@ fi
%postun -p /sbin/ldconfig
%changelog
+* Fri May 29 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.7-20200529
+- Rebuilt.
+
* Tue May 26 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.5-20200526
- Rebuilt.
- BZ#6864: (I)LIKE with multiple % doen't find matches
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
@@ -64,7 +64,7 @@ stdout of test 'MAL-signatures` in direc
% .%1, .%1, .%1, .%1, .%1 # table_name
% module, function, signature, address, comment # name
% clob, clob, clob, clob, clob # type
-% 12, 28, 364, 38, 874 # length
+% 12, 28, 364, 39, 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", "pattern aggr.anyequal(l:any_1, r:any_1):bit ",
"CMDvarEQ;", "" ]
[ "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" ]
@@ -9101,8 +9101,8 @@ stdout of test 'MAL-signatures` in direc
[ "batcalc", "hash", "command batcalc.hash(b:bat[:lng]):bat[:lng] ",
"MKEYbathash;", "" ]
[ "batcalc", "hash", "command batcalc.hash(b:bat[:oid]):bat[:lng] ",
"MKEYbathash;", "" ]
[ "batcalc", "hash", "command batcalc.hash(b:bat[:sht]):bat[:lng] ",
"MKEYbathash;", "" ]
-[ "batcalc", "identity", "command
batcalc.identity(b:bat[:any_2]):bat[:oid] ", "BATSQLidentity;", "Returns
the unique row identitfiers." ]
-[ "batcalc", "identity", "pattern batcalc.identity(b:bat[:any_2], s:oid)
(resb:bat[:oid], ns:oid) ", "PBATSQLidentity;", "Returns the unique row
identitfiers." ]
+[ "batcalc", "identity", "command
batcalc.identity(b:bat[:any]):bat[:oid] ", "BATSQLidentity;", "Returns
the unique row identitfiers." ]
+[ "batcalc", "identity", "pattern batcalc.identity(b:bat[:any], s:oid)
(resb:bat[:oid], ns:oid) ", "PBATSQLidentity;", "Returns the unique
row identitfiers." ]
[ "batcalc", "ifthenelse", "pattern batcalc.ifthenelse(b:bat[:bit],
b1:bat[:any_1], b2:bat[:any_1]):bat[:any_1] ", "CMDifthen;", "If-then-else
operation to assemble a conditional result" ]
[ "batcalc", "ifthenelse", "pattern batcalc.ifthenelse(b:bat[:bit],
b1:bat[:any_1], v2:any_1):bat[:any_1] ", "CMDifthen;", "If-then-else
operation to assemble a conditional result" ]
[ "batcalc", "ifthenelse", "pattern batcalc.ifthenelse(b:bat[:bit],
v1:any_1, b2:bat[:any_1]):bat[:any_1] ", "CMDifthen;", "If-then-else
operation to assemble a conditional result" ]
@@ -11308,10 +11308,18 @@ stdout of test 'MAL-signatures` in direc
[ "batmmath", "tanh", "pattern batmmath.tanh(x:bat[:flt],
r:bat[:bit]):bat[:flt] ", "CMDscience_bat_tanh;", "" ]
[ "batmmath", "tanh", "pattern batmmath.tanh(x:bat[:flt],
s:bat[:oid]):bat[:flt] ", "CMDscience_bat_tanh;", "" ]
[ "batmmath", "tanh", "pattern batmmath.tanh(x:bat[:flt], s:bat[:oid],
r:bat[:bit]):bat[:flt] ", "CMDscience_bat_tanh;", "" ]
+[ "batmtime", "addmonths", "command batmtime.addmonths(value:bat[:date],
months:bat[:int]):bat[:date] ", "MTIMEdate_addmonths_bulk;", "" ]
[ "batmtime", "century", "command
batmtime.century(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_century_bulk;", "" ]
+[ "batmtime", "date_add_msec_interval", "command
batmtime.date_add_msec_interval(t:bat[:date], ms:bat[:lng]):bat[:date] ",
"MTIMEdate_add_msec_interval_bulk;", "" ]
+[ "batmtime", "date_sub_month_interval", "command
batmtime.date_sub_month_interval(value:bat[:date], months:bat[:int]):bat[:date]
", "MTIMEdate_submonths_bulk;", "" ]
+[ "batmtime", "date_sub_msec_interval", "command
batmtime.date_sub_msec_interval(t:bat[:date], ms:bat[:lng]):bat[:date] ",
"MTIMEdate_sub_msec_interval_bulk;", "" ]
[ "batmtime", "day", "command batmtime.day(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_day_bulk;", "" ]
+[ "batmtime", "dayofweek", "command
batmtime.dayofweek(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_dayofweek_bulk;", "" ]
+[ "batmtime", "dayofyear", "command
batmtime.dayofyear(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_dayofyear_bulk;", "" ]
[ "batmtime", "decade", "command
batmtime.decade(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_decade_bulk;", "" ]
[ "batmtime", "diff", "command batmtime.diff(b1:bat[:date],
b2:bat[:date]):bat[:int] ", "MTIMEdate_diff_bulk;", "Difference of two
sets of date." ]
+[ "batmtime", "diff", "command batmtime.diff(val1:bat[:date],
val2:bat[:date]):bat[:int] ", "MTIMEdate_diff_bulk;", "returns the number of
days\n\tbetween 'val1' and 'val2'." ]
+[ "batmtime", "diff", "command batmtime.diff(b1:bat[:daytime],
b2:bat[:daytime]):bat[:lng] ", "MTIMEdaytime_diff_msec_bulk;", "Difference of
two sets of daytime." ]
[ "batmtime", "diff", "command batmtime.diff(b1:bat[:timestamp],
b2:bat[:timestamp]):bat[:lng] ", "MTIMEtimestamp_diff_msec_bulk;",
"Difference of two sets of timestamp." ]
[ "batmtime", "hours", "command
batmtime.hours(d:bat[:daytime]):bat[:int] ",
"MTIMEdaytime_extract_hours_bulk;", "" ]
[ "batmtime", "minutes", "command
batmtime.minutes(d:bat[:daytime]):bat[:int] ",
"MTIMEdaytime_extract_minutes_bulk;", "" ]
@@ -11319,8 +11327,13 @@ stdout of test 'MAL-signatures` in direc
[ "batmtime", "quarter", "command
batmtime.quarter(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_quarter_bulk;", "" ]
[ "batmtime", "sql_seconds", "command
batmtime.sql_seconds(d:bat[:daytime]):bat[:int] ",
"MTIMEdaytime_extract_sql_seconds_bulk;", "" ]
[ "batmtime", "sql_seconds", "command
batmtime.sql_seconds(d:bat[:timestamp]):bat[:int] ",
"MTIMEtimestamp_sql_seconds_bulk;", "" ]
+[ "batmtime", "time_add_msec_interval", "command
batmtime.time_add_msec_interval(t:bat[:daytime], ms:bat[:lng]):bat[:daytime] ",
"MTIMEtime_add_msec_interval_bulk;", "" ]
+[ "batmtime", "time_sub_msec_interval", "command
batmtime.time_sub_msec_interval(t:bat[:daytime], ms:bat[:lng]):bat[:daytime] ",
"MTIMEtime_sub_msec_interval_bulk;", "" ]
+[ "batmtime", "timestamp_add_month_interval", "command
batmtime.timestamp_add_month_interval(t:bat[:timestamp],
s:bat[:int]):bat[:timestamp] ",
"MTIMEtimestamp_add_month_interval_bulk;", "" ]
[ "batmtime", "timestamp_add_msec_interval", "command
batmtime.timestamp_add_msec_interval(t:bat[:timestamp],
ms:bat[:lng]):bat[:timestamp] ",
"MTIMEtimestamp_add_msec_interval_bulk;", "" ]
+[ "batmtime", "timestamp_sub_month_interval", "command
batmtime.timestamp_sub_month_interval(t:bat[:timestamp],
s:bat[:int]):bat[:timestamp] ",
"MTIMEtimestamp_sub_month_interval_bulk;", "" ]
[ "batmtime", "timestamp_sub_msec_interval", "command
batmtime.timestamp_sub_msec_interval(t:bat[:timestamp],
ms:bat[:lng]):bat[:timestamp] ",
"MTIMEtimestamp_sub_msec_interval_bulk;", "" ]
+[ "batmtime", "weekofyear", "command
batmtime.weekofyear(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_weekofyear_bulk;", "" ]
[ "batmtime", "year", "command batmtime.year(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_year_bulk;", "" ]
[ "batpcre", "replace", "command batpcre.replace(orig:bat[:str],
pat:str, repl:str, flag:str):bat[:str] ", "PCREreplace_bat_wrap;",
"" ]
[ "batpcre", "replace_first", "command
batpcre.replace_first(orig:bat[:str], pat:str, repl:str, flag:str):bat[:str] ",
"PCREreplacefirst_bat_wrap;", "" ]
@@ -12836,7 +12849,7 @@ stdout of test 'MAL-signatures` in direc
[ "calc", "hash", "pattern calc.hash(v:lng):lng ", "MKEYhash;",
"" ]
[ "calc", "hash", "pattern calc.hash(v:oid):lng ", "MKEYhash;",
"" ]
[ "calc", "hash", "pattern calc.hash(v:sht):lng ", "MKEYhash;",
"" ]
-[ "calc", "identity", "command calc.identity(X_0:any_2):oid ",
"SQLidentity;", "Returns a unique row identitfier." ]
+[ "calc", "identity", "command calc.identity(X_0:any):oid ",
"SQLidentity;", "Returns a unique row identitfier." ]
[ "calc", "ifthenelse", "pattern calc.ifthenelse(b:bit, t:any_1,
f:any_1):any_1 ", "CALCswitchbit;", "If VALUE is true return MIDDLE
else RIGHT" ]
[ "calc", "index", "command calc.index(v:str, u:bit):bte ",
"STRindex_bte;", "Return the offsets as an index bat" ]
[ "calc", "index", "command calc.index(v:str, u:bit):int ",
"STRindex_int;", "Return the offsets as an index bat" ]
@@ -13865,7 +13878,7 @@ stdout of test 'MAL-signatures` in direc
[ "mtime", "current_time", "command mtime.current_time():daytime ",
"MTIMEcurrent_time;", "" ]
[ "mtime", "current_timestamp", "command
mtime.current_timestamp():timestamp ", "MTIMEcurrent_timestamp;", "" ]
[ "mtime", "date_add_msec_interval", "command
mtime.date_add_msec_interval(t:date, ms:lng):date ",
"MTIMEdate_add_msec_interval;", "" ]
-[ "mtime", "date_sub_month_interval", "command
mtime.date_sub_month_interval(t:date, s:int):date ", "MTIMEdate_submonths;",
"Subtract months from a date" ]
+[ "mtime", "date_sub_month_interval", "command
mtime.date_sub_month_interval(t:date, months:int):date ",
"MTIMEdate_submonths;", "Subtract months from a date" ]
[ "mtime", "date_sub_msec_interval", "command
mtime.date_sub_msec_interval(t:date, ms:lng):date ",
"MTIMEdate_sub_msec_interval;", "" ]
[ "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 " ]
@@ -14182,7 +14195,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "export_table", "unsafe pattern sql.export_table(fname:str,
fmt:str, colsep:str, recsep:str, qout:str, nullrep:str, onclient:int,
tbl:bat[:str], attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int],
cols:bat[:any]...):int ", "mvc_export_table_wrap;", "Prepare a
table result set for the COPY INTO stream" ]
[ "sql", "first_value", "pattern sql.first_value(b:any_1, s:lng,
e:lng):any_1 ", "SQLfirst_value;", "return the first value of
groups" ]
[ "sql", "flush_log", "unsafe command sql.flush_log():void ",
"SQLflush_log;", "start flushing the write ahead log" ]
-[ "sql", "getVariable", "pattern sql.getVariable(mvc:int,
varname:str):any_1 ", "getVariable;", "Get the value of a session variable" ]
+[ "sql", "getVariable", "pattern sql.getVariable(mvc:int, sname:str,
varname:str):any_1 ", "getVariable;", "Get the value of a session
variable" ]
[ "sql", "getVersion", "command sql.getVersion(clientid:int):lng ",
"mvc_getVersion;", "Return the database version identifier for a client."
]
[ "sql", "get_value", "pattern sql.get_value(sname:str,
sequence:str):lng ", "mvc_get_value;", "return the current value of the
sequence" ]
[ "sql", "grow", "pattern sql.grow(tid:bat[:oid], X_0:any_1):int ",
"mvc_grow_wrap;", "Resize the tid column of a declared table." ]
@@ -14248,7 +14261,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "row_number", "pattern sql.row_number(b:any_1, p:bit,
o:bit):int ", "SQLrow_number;", "return the row_numer-ed groups"
]
[ "sql", "rt_credentials", "pattern
sql.rt_credentials(tablename:str) (uri:bat[:str], username:bat[:str],
hash:bat[:str]) ", "sql_rt_credentials_wrap;", "Return the remote
table credentials for the given table" ]
[ "sql", "sessions", "pattern sql.sessions() (id:bat[:int],
user:bat[:str], start:bat[:timestamp], idle:bat[:timestamp],
optmizer:bat[:str], stimeout:bat[:int], qtimeout:bat[:int], wlimit:bat[:int],
mlimit:bat[:int]) ", "sql_sessions_wrap;", "SQL export table of active
sessions, their timeouts and idle status" ]
-[ "sql", "setVariable", "unsafe pattern sql.setVariable(mvc:int,
varname:str, value:any_1):int ", "setVariable;", "Set the value of a
session variable" ]
+[ "sql", "setVariable", "unsafe pattern sql.setVariable(mvc:int,
sname:str, varname:str, value:any_1):int ", "setVariable;", "Set the value
of a session variable" ]
[ "sql", "shrink", "unsafe pattern sql.shrink(sch:str,
tbl:str):void ", "SQLshrink;", "Consolidate the deletion table over all
columns using shrinking" ]
[ "sql", "shutdown", "pattern sql.shutdown(delay:bte):str ",
"SQLshutdown_wrap;", "" ]
[ "sql", "shutdown", "pattern sql.shutdown(delay:bte, force:bit):str
", "SQLshutdown_wrap;", "" ]
@@ -14258,7 +14271,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "shutdown", "pattern sql.shutdown(delay:sht, force:bit):str
", "SQLshutdown_wrap;", "" ]
[ "sql", "single", "pattern sql.single(x:any_2):bat[:any_2] ",
"CMDBATsingle;", "" ]
[ "sql", "sql_environment", "inline function sql.sql_environment()
(name:bat[:str], value:bat[:str]);", "", "" ]
-[ "sql", "sql_variables", "pattern sql.sql_variables():bat[:str]
", "sql_variables;", "return the table with session variables"
]
+[ "sql", "sql_variables", "pattern sql.sql_variables()
(sname:bat[:str], name:bat[:str], type:bat[:str], value:bat[:str]) ",
"sql_variables;", "return the table with session variables" ]
[ "sql", "stdev", "pattern sql.stdev(b:bte, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
[ "sql", "stdev", "pattern sql.stdev(b:dbl, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
[ "sql", "stdev", "pattern sql.stdev(b:flt, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
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
@@ -68,7 +68,7 @@ stdout of test 'MAL-signatures` in direc
% .%1, .%1, .%1, .%1, .%1 # table_name
% module, function, signature, address, comment # name
% clob, clob, clob, clob, clob # type
-% 12, 28, 364, 38, 874 # length
+% 12, 28, 364, 39, 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", "pattern aggr.anyequal(l:any_1, r:any_1):bit ",
"CMDvarEQ;", "" ]
[ "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" ]
@@ -13139,8 +13139,8 @@ stdout of test 'MAL-signatures` in direc
[ "batcalc", "hge_noerror", "pattern batcalc.hge_noerror(b:bat[:str],
r:bat[:bit]):bat[:hge] ", "CMDconvert_hge;", "cast from str to hge" ]
[ "batcalc", "hge_noerror", "pattern batcalc.hge_noerror(b:bat[:str],
s:bat[:oid]):bat[:hge] ", "CMDconvert_hge;", "cast from str to hge
with candidates list" ]
[ "batcalc", "hge_noerror", "pattern batcalc.hge_noerror(b:bat[:str],
s:bat[:oid], r:bat[:bit]):bat[:hge] ", "CMDconvert_hge;", "cast
from str to hge with candidates list" ]
-[ "batcalc", "identity", "command
batcalc.identity(b:bat[:any_2]):bat[:oid] ", "BATSQLidentity;", "Returns
the unique row identitfiers." ]
-[ "batcalc", "identity", "pattern batcalc.identity(b:bat[:any_2], s:oid)
(resb:bat[:oid], ns:oid) ", "PBATSQLidentity;", "Returns the unique row
identitfiers." ]
+[ "batcalc", "identity", "command
batcalc.identity(b:bat[:any]):bat[:oid] ", "BATSQLidentity;", "Returns
the unique row identitfiers." ]
+[ "batcalc", "identity", "pattern batcalc.identity(b:bat[:any], s:oid)
(resb:bat[:oid], ns:oid) ", "PBATSQLidentity;", "Returns the unique
row identitfiers." ]
[ "batcalc", "ifthenelse", "pattern batcalc.ifthenelse(b:bat[:bit],
b1:bat[:any_1], b2:bat[:any_1]):bat[:any_1] ", "CMDifthen;", "If-then-else
operation to assemble a conditional result" ]
[ "batcalc", "ifthenelse", "pattern batcalc.ifthenelse(b:bat[:bit],
b1:bat[:any_1], v2:any_1):bat[:any_1] ", "CMDifthen;", "If-then-else
operation to assemble a conditional result" ]
[ "batcalc", "ifthenelse", "pattern batcalc.ifthenelse(b:bat[:bit],
v1:any_1, b2:bat[:any_1]):bat[:any_1] ", "CMDifthen;", "If-then-else
operation to assemble a conditional result" ]
@@ -16098,10 +16098,18 @@ stdout of test 'MAL-signatures` in direc
[ "batmmath", "tanh", "pattern batmmath.tanh(x:bat[:flt],
r:bat[:bit]):bat[:flt] ", "CMDscience_bat_tanh;", "" ]
[ "batmmath", "tanh", "pattern batmmath.tanh(x:bat[:flt],
s:bat[:oid]):bat[:flt] ", "CMDscience_bat_tanh;", "" ]
[ "batmmath", "tanh", "pattern batmmath.tanh(x:bat[:flt], s:bat[:oid],
r:bat[:bit]):bat[:flt] ", "CMDscience_bat_tanh;", "" ]
+[ "batmtime", "addmonths", "command batmtime.addmonths(value:bat[:date],
months:bat[:int]):bat[:date] ", "MTIMEdate_addmonths_bulk;", "" ]
[ "batmtime", "century", "command
batmtime.century(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_century_bulk;", "" ]
+[ "batmtime", "date_add_msec_interval", "command
batmtime.date_add_msec_interval(t:bat[:date], ms:bat[:lng]):bat[:date] ",
"MTIMEdate_add_msec_interval_bulk;", "" ]
+[ "batmtime", "date_sub_month_interval", "command
batmtime.date_sub_month_interval(value:bat[:date], months:bat[:int]):bat[:date]
", "MTIMEdate_submonths_bulk;", "" ]
+[ "batmtime", "date_sub_msec_interval", "command
batmtime.date_sub_msec_interval(t:bat[:date], ms:bat[:lng]):bat[:date] ",
"MTIMEdate_sub_msec_interval_bulk;", "" ]
[ "batmtime", "day", "command batmtime.day(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_day_bulk;", "" ]
+[ "batmtime", "dayofweek", "command
batmtime.dayofweek(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_dayofweek_bulk;", "" ]
+[ "batmtime", "dayofyear", "command
batmtime.dayofyear(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_dayofyear_bulk;", "" ]
[ "batmtime", "decade", "command
batmtime.decade(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_decade_bulk;", "" ]
[ "batmtime", "diff", "command batmtime.diff(b1:bat[:date],
b2:bat[:date]):bat[:int] ", "MTIMEdate_diff_bulk;", "Difference of two
sets of date." ]
+[ "batmtime", "diff", "command batmtime.diff(val1:bat[:date],
val2:bat[:date]):bat[:int] ", "MTIMEdate_diff_bulk;", "returns the number of
days\n\tbetween 'val1' and 'val2'." ]
+[ "batmtime", "diff", "command batmtime.diff(b1:bat[:daytime],
b2:bat[:daytime]):bat[:lng] ", "MTIMEdaytime_diff_msec_bulk;", "Difference of
two sets of daytime." ]
[ "batmtime", "diff", "command batmtime.diff(b1:bat[:timestamp],
b2:bat[:timestamp]):bat[:lng] ", "MTIMEtimestamp_diff_msec_bulk;",
"Difference of two sets of timestamp." ]
[ "batmtime", "hours", "command
batmtime.hours(d:bat[:daytime]):bat[:int] ",
"MTIMEdaytime_extract_hours_bulk;", "" ]
[ "batmtime", "minutes", "command
batmtime.minutes(d:bat[:daytime]):bat[:int] ",
"MTIMEdaytime_extract_minutes_bulk;", "" ]
@@ -16109,8 +16117,13 @@ stdout of test 'MAL-signatures` in direc
[ "batmtime", "quarter", "command
batmtime.quarter(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_quarter_bulk;", "" ]
[ "batmtime", "sql_seconds", "command
batmtime.sql_seconds(d:bat[:daytime]):bat[:int] ",
"MTIMEdaytime_extract_sql_seconds_bulk;", "" ]
[ "batmtime", "sql_seconds", "command
batmtime.sql_seconds(d:bat[:timestamp]):bat[:int] ",
"MTIMEtimestamp_sql_seconds_bulk;", "" ]
+[ "batmtime", "time_add_msec_interval", "command
batmtime.time_add_msec_interval(t:bat[:daytime], ms:bat[:lng]):bat[:daytime] ",
"MTIMEtime_add_msec_interval_bulk;", "" ]
+[ "batmtime", "time_sub_msec_interval", "command
batmtime.time_sub_msec_interval(t:bat[:daytime], ms:bat[:lng]):bat[:daytime] ",
"MTIMEtime_sub_msec_interval_bulk;", "" ]
+[ "batmtime", "timestamp_add_month_interval", "command
batmtime.timestamp_add_month_interval(t:bat[:timestamp],
s:bat[:int]):bat[:timestamp] ",
"MTIMEtimestamp_add_month_interval_bulk;", "" ]
[ "batmtime", "timestamp_add_msec_interval", "command
batmtime.timestamp_add_msec_interval(t:bat[:timestamp],
ms:bat[:lng]):bat[:timestamp] ",
"MTIMEtimestamp_add_msec_interval_bulk;", "" ]
+[ "batmtime", "timestamp_sub_month_interval", "command
batmtime.timestamp_sub_month_interval(t:bat[:timestamp],
s:bat[:int]):bat[:timestamp] ",
"MTIMEtimestamp_sub_month_interval_bulk;", "" ]
[ "batmtime", "timestamp_sub_msec_interval", "command
batmtime.timestamp_sub_msec_interval(t:bat[:timestamp],
ms:bat[:lng]):bat[:timestamp] ",
"MTIMEtimestamp_sub_msec_interval_bulk;", "" ]
+[ "batmtime", "weekofyear", "command
batmtime.weekofyear(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_weekofyear_bulk;", "" ]
[ "batmtime", "year", "command batmtime.year(d:bat[:date]):bat[:int] ",
"MTIMEdate_extract_year_bulk;", "" ]
[ "batpcre", "replace", "command batpcre.replace(orig:bat[:str],
pat:str, repl:str, flag:str):bat[:str] ", "PCREreplace_bat_wrap;",
"" ]
[ "batpcre", "replace_first", "command
batpcre.replace_first(orig:bat[:str], pat:str, repl:str, flag:str):bat[:str] ",
"PCREreplacefirst_bat_wrap;", "" ]
@@ -18190,7 +18203,7 @@ stdout of test 'MAL-signatures` in direc
[ "calc", "hge", "command calc.hge(s1:int, v:sht, d2:int, s2:int):hge ",
"sht_dec2dec_hge;", "cast decimal(sht) to decimal(hge) and check for
overflow" ]
[ "calc", "hge", "command calc.hge(v:sht, digits:int, scale:int):hge ",
"sht_num2dec_hge;", "cast number to decimal(hge) and check for overflow"
]
[ "calc", "hge", "command calc.hge(v:str, digits:int, scale:int):hge ",
"str_2dec_hge;", "cast to dec(hge) and check for overflow" ]
-[ "calc", "identity", "command calc.identity(X_0:any_2):oid ",
"SQLidentity;", "Returns a unique row identitfier." ]
+[ "calc", "identity", "command calc.identity(X_0:any):oid ",
"SQLidentity;", "Returns a unique row identitfier." ]
[ "calc", "ifthenelse", "pattern calc.ifthenelse(b:bit, t:any_1,
f:any_1):any_1 ", "CALCswitchbit;", "If VALUE is true return MIDDLE
else RIGHT" ]
[ "calc", "index", "command calc.index(v:str, u:bit):bte ",
"STRindex_bte;", "Return the offsets as an index bat" ]
[ "calc", "index", "command calc.index(v:str, u:bit):int ",
"STRindex_int;", "Return the offsets as an index bat" ]
@@ -19350,7 +19363,7 @@ stdout of test 'MAL-signatures` in direc
[ "mtime", "current_time", "command mtime.current_time():daytime ",
"MTIMEcurrent_time;", "" ]
[ "mtime", "current_timestamp", "command
mtime.current_timestamp():timestamp ", "MTIMEcurrent_timestamp;", "" ]
[ "mtime", "date_add_msec_interval", "command
mtime.date_add_msec_interval(t:date, ms:lng):date ",
"MTIMEdate_add_msec_interval;", "" ]
-[ "mtime", "date_sub_month_interval", "command
mtime.date_sub_month_interval(t:date, s:int):date ", "MTIMEdate_submonths;",
"Subtract months from a date" ]
+[ "mtime", "date_sub_month_interval", "command
mtime.date_sub_month_interval(t:date, months:int):date ",
"MTIMEdate_submonths;", "Subtract months from a date" ]
[ "mtime", "date_sub_msec_interval", "command
mtime.date_sub_msec_interval(t:date, ms:lng):date ",
"MTIMEdate_sub_msec_interval;", "" ]
[ "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 " ]
@@ -19672,7 +19685,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "export_table", "unsafe pattern sql.export_table(fname:str,
fmt:str, colsep:str, recsep:str, qout:str, nullrep:str, onclient:int,
tbl:bat[:str], attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int],
cols:bat[:any]...):int ", "mvc_export_table_wrap;", "Prepare a
table result set for the COPY INTO stream" ]
[ "sql", "first_value", "pattern sql.first_value(b:any_1, s:lng,
e:lng):any_1 ", "SQLfirst_value;", "return the first value of
groups" ]
[ "sql", "flush_log", "unsafe command sql.flush_log():void ",
"SQLflush_log;", "start flushing the write ahead log" ]
-[ "sql", "getVariable", "pattern sql.getVariable(mvc:int,
varname:str):any_1 ", "getVariable;", "Get the value of a session variable" ]
+[ "sql", "getVariable", "pattern sql.getVariable(mvc:int, sname:str,
varname:str):any_1 ", "getVariable;", "Get the value of a session
variable" ]
[ "sql", "getVersion", "command sql.getVersion(clientid:int):lng ",
"mvc_getVersion;", "Return the database version identifier for a client."
]
[ "sql", "get_value", "pattern sql.get_value(sname:str,
sequence:str):lng ", "mvc_get_value;", "return the current value of the
sequence" ]
[ "sql", "grow", "pattern sql.grow(tid:bat[:oid], X_0:any_1):int ",
"mvc_grow_wrap;", "Resize the tid column of a declared table." ]
@@ -19744,7 +19757,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "row_number", "pattern sql.row_number(b:any_1, p:bit,
o:bit):int ", "SQLrow_number;", "return the row_numer-ed groups"
]
[ "sql", "rt_credentials", "pattern
sql.rt_credentials(tablename:str) (uri:bat[:str], username:bat[:str],
hash:bat[:str]) ", "sql_rt_credentials_wrap;", "Return the remote
table credentials for the given table" ]
[ "sql", "sessions", "pattern sql.sessions() (id:bat[:int],
user:bat[:str], start:bat[:timestamp], idle:bat[:timestamp],
optmizer:bat[:str], stimeout:bat[:int], qtimeout:bat[:int], wlimit:bat[:int],
mlimit:bat[:int]) ", "sql_sessions_wrap;", "SQL export table of active
sessions, their timeouts and idle status" ]
-[ "sql", "setVariable", "unsafe pattern sql.setVariable(mvc:int,
varname:str, value:any_1):int ", "setVariable;", "Set the value of a
session variable" ]
+[ "sql", "setVariable", "unsafe pattern sql.setVariable(mvc:int,
sname:str, varname:str, value:any_1):int ", "setVariable;", "Set the value
of a session variable" ]
[ "sql", "shrink", "unsafe pattern sql.shrink(sch:str,
tbl:str):void ", "SQLshrink;", "Consolidate the deletion table over all
columns using shrinking" ]
[ "sql", "shutdown", "pattern sql.shutdown(delay:bte):str ",
"SQLshutdown_wrap;", "" ]
[ "sql", "shutdown", "pattern sql.shutdown(delay:bte, force:bit):str
", "SQLshutdown_wrap;", "" ]
@@ -19754,7 +19767,7 @@ stdout of test 'MAL-signatures` in direc
[ "sql", "shutdown", "pattern sql.shutdown(delay:sht, force:bit):str
", "SQLshutdown_wrap;", "" ]
[ "sql", "single", "pattern sql.single(x:any_2):bat[:any_2] ",
"CMDBATsingle;", "" ]
[ "sql", "sql_environment", "inline function sql.sql_environment()
(name:bat[:str], value:bat[:str]);", "", "" ]
-[ "sql", "sql_variables", "pattern sql.sql_variables():bat[:str]
", "sql_variables;", "return the table with session variables"
]
+[ "sql", "sql_variables", "pattern sql.sql_variables()
(sname:bat[:str], name:bat[:str], type:bat[:str], value:bat[:str]) ",
"sql_variables;", "return the table with session variables" ]
[ "sql", "stdev", "pattern sql.stdev(b:bte, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
[ "sql", "stdev", "pattern sql.stdev(b:dbl, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
[ "sql", "stdev", "pattern sql.stdev(b:flt, s:lng, e:lng):dbl ",
"SQLstddev_samp;", "return the standard deviation sample of groups"
]
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
@@ -452,6 +452,7 @@ int date_year(date dt) __attribute__((__
daytime daytime_add_usec(daytime tm, lng usec) __attribute__((__const__));
daytime daytime_add_usec_modulo(daytime tm, lng usec)
__attribute__((__const__));
daytime daytime_create(int hour, int minute, int second, int usec)
__attribute__((__const__));
+lng daytime_diff(daytime d1, daytime d2) __attribute__((__const__));
ssize_t daytime_fromstr(const char *buf, size_t *len, daytime **d, bool
external);
int daytime_hour(daytime tm) __attribute__((__const__));
int daytime_min(daytime tm) __attribute__((__const__));
@@ -1571,32 +1572,43 @@ str MTIMEanalyticalrangebounds(BAT *r, B
str MTIMEcurrent_date(date *ret);
str MTIMEcurrent_time(daytime *ret);
str MTIMEcurrent_timestamp(timestamp *ret);
-str MTIMEdate_add_msec_interval(date *ret, const date *d, const lng *ms);
-str MTIMEdate_addmonths(date *ret, const date *d, const int *m);
-str MTIMEdate_date(date *dst, const date *src);
+str MTIMEdate_add_msec_interval(date *ret, const date *v1, const lng *v2);
+str MTIMEdate_add_msec_interval_bulk(bat *ret, const bat *bid1, const bat
*bid2);
+str MTIMEdate_addmonths(date *ret, const date *v1, const int *v2);
+str MTIMEdate_addmonths_bulk(bat *ret, const bat *bid1, const bat *bid2);
+str MTIMEdate_date(date *ret, const date *src);
+str MTIMEdate_date_bulk(bat *ret, const bat *bid);
str MTIMEdate_diff(int *ret, const date *v1, const date *v2);
str MTIMEdate_diff_bulk(bat *ret, const bat *bid1, const bat *bid2);
str MTIMEdate_extract_century(int *ret, const date *src);
str MTIMEdate_extract_century_bulk(bat *ret, const bat *bid);
str MTIMEdate_extract_day(int *ret, const date *src);
str MTIMEdate_extract_day_bulk(bat *ret, const bat *bid);
-str MTIMEdate_extract_dayofweek(int *ret, const date *d);
-str MTIMEdate_extract_dayofyear(int *ret, const date *d);
+str MTIMEdate_extract_dayofweek(int *ret, const date *src);
+str MTIMEdate_extract_dayofweek_bulk(bat *ret, const bat *bid);
+str MTIMEdate_extract_dayofyear(int *ret, const date *src);
+str MTIMEdate_extract_dayofyear_bulk(bat *ret, const bat *bid);
str MTIMEdate_extract_decade(int *ret, const date *src);
str MTIMEdate_extract_decade_bulk(bat *ret, const bat *bid);
str MTIMEdate_extract_month(int *ret, const date *src);
str MTIMEdate_extract_month_bulk(bat *ret, const bat *bid);
str MTIMEdate_extract_quarter(int *ret, const date *src);
str MTIMEdate_extract_quarter_bulk(bat *ret, const bat *bid);
-str MTIMEdate_extract_weekofyear(int *ret, const date *d);
+str MTIMEdate_extract_weekofyear(int *ret, const date *src);
+str MTIMEdate_extract_weekofyear_bulk(bat *ret, const bat *bid);
str MTIMEdate_extract_year(int *ret, const date *src);
str MTIMEdate_extract_year_bulk(bat *ret, const bat *bid);
str MTIMEdate_fromstr(date *ret, const char *const *s);
-str MTIMEdate_sub_msec_interval(date *ret, const date *d, const lng *ms);
-str MTIMEdate_submonths(date *ret, const date *d, const int *m);
-str MTIMEdate_to_str(str *ret, const date *d, const char *const *format);
-str MTIMEdaytime_daytime(daytime *dst, const daytime *src);
-str MTIMEdaytime_diff_msec(lng *ret, const daytime *t1, const daytime *t2);
+str MTIMEdate_sub_msec_interval(date *ret, const date *v1, const lng *v2);
+str MTIMEdate_sub_msec_interval_bulk(bat *ret, const bat *bid1, const bat
*bid2);
+str MTIMEdate_submonths(date *ret, const date *v1, const int *v2);
+str MTIMEdate_submonths_bulk(bat *ret, const bat *bid1, const bat *bid2);
+str MTIMEdate_to_str(str *ret, const const date *v1, const const char *const
*v2);
+str MTIMEdate_to_str_bulk(bat *ret, const bat *bid1, const bat *bid2);
+str MTIMEdaytime_daytime(daytime *ret, const daytime *src);
+str MTIMEdaytime_daytime_bulk(bat *ret, const bat *bid);
+str MTIMEdaytime_diff_msec(lng *ret, const daytime *v1, const daytime *v2);
+str MTIMEdaytime_diff_msec_bulk(bat *ret, const bat *bid1, const bat *bid2);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
