Changeset: 35464e22972c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/35464e22972c Modified Files: monetdb5/modules/mal/pp_hash.c monetdb5/modules/mal/pp_hash.h sql/backends/monet5/rel_bin.c sql/backends/monet5/rel_physical.c sql/backends/monet5/rel_pphash.c sql/backends/monet5/sql_pp_statement.c sql/backends/monet5/sql_pp_statement.h sql/backends/monet5/sql_statement.c sql/server/rel_optimize_sel.c Branch: manti Log Message:
merged from default diffs (truncated from 119727 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -860,3 +860,4 @@ b4c2936c46f28ad6b3e59ed5a1a844726d521994 1d742c123cb0e622d9a137b10bfbd7e4c446fde2 Dec2025_7 1d742c123cb0e622d9a137b10bfbd7e4c446fde2 Dec2025_SP3_release bc5735402f969151c941c100a7552769c0e89a9a Dec2025_9 +bc5735402f969151c941c100a7552769c0e89a9a Dec2025_SP4_release diff --git a/ChangeLog b/ChangeLog --- a/ChangeLog +++ b/ChangeLog @@ -1,6 +1,11 @@ # ChangeLog file for devel # This file is updated with Maddlog +* Tue Oct 6 2026 Sjoerd Mullender <[email protected]> +- The function sys.local_timezone() has been renamed to + sys.system_timezone() since it returns the time zone of the server. + To get the client's time zone, use sys.current_timezone. + * Mon Sep 28 2026 Sjoerd Mullender <[email protected]> - The example udf extension module has been removed. For example extensions, see https://www.monetdb.org/hg/MonetDB-extend/. Note that diff --git a/clients/Tests/MAL-signatures-hge.test b/clients/Tests/MAL-signatures-hge.test --- a/clients/Tests/MAL-signatures-hge.test +++ b/clients/Tests/MAL-signatures-hge.test @@ -1,53796 +1,10763 @@ hash-threshold 100000 -query TTTTT nosort -select * from sys.malfunctions() order by module, "function", address, signature, comment ----- -aggr -Collect -command aggr.Collect(X_0:bat[:wkb]):wkb -wkbCollectAggr -TODO -aggr -MakeLine -command aggr.MakeLine(X_0:bat[:wkb]):wkb -wkbMakeLineAggr -Gets a BAT with point or linestring geometries and returns a single linestring geometry -aggr -all -command aggr.all(X_0:bat[:any_1]):any_1 -SQLall -if all values in b are equal return this, else nil -aggr -allnotequal -pattern aggr.allnotequal(X_0:bat[:any_1], X_1:bat[:any_1]):bit -SQLallnotequal -if all values in r are not equal to l, return true, else if r has nil, return nil, else return false -aggr -anyequal -pattern aggr.anyequal(X_0:any_1, X_1:any_1):bit -CMDvarEQ -(empty) -aggr -anyequal -pattern aggr.anyequal(X_0:bat[:any_1], X_1:bat[:any_1]):bit -SQLanyequal -if any value in r is equal to l, return true, else if r has nil, return nil, else return false -aggr -avg -command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl -Grouped tail average on bte -aggr -avg -command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl -Grouped tail average on dbl -aggr -avg -command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl -Grouped tail average on flt -aggr -avg -command aggr.avg(X_0:bat[:hge], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl -Grouped tail average on hge -aggr -avg -command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl -Grouped tail average on int -aggr -avg -command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl -Grouped tail average on lng -aggr -avg -command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl -Grouped tail average on sht -aggr -avg -command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl -Grouped tail average on bte -aggr -avg -command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl -Grouped tail average on dbl -aggr -avg -command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl -Grouped tail average on flt -aggr -avg -command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl -Grouped tail average on int -aggr -avg -command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl -Grouped tail average on lng -aggr -avg -command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl -Grouped tail average on sht -aggr -avg -command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl -Grouped tail average on bte, also returns count -aggr -avg -command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl -Grouped tail average on dbl, also returns count -aggr -avg -command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl -Grouped tail average on flt, also returns count -aggr -avg -command aggr.avg(X_0:bat[:hge], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl -Grouped tail average on hge, also returns count -aggr -avg -command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl -Grouped tail average on int, also returns count -aggr -avg -command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl -Grouped tail average on lng, also returns count -aggr -avg -command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl -Grouped tail average on sht, also returns count -aggr -avg -command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl -Grouped tail average on bte, also returns count -aggr -avg -command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl -Grouped tail average on dbl, also returns count -aggr -avg -command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl -Grouped tail average on flt, also returns count -aggr -avg -command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl -Grouped tail average on int, also returns count -aggr -avg -command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl -Grouped tail average on lng, also returns count -aggr -avg -command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl -Grouped tail average on sht, also returns count -aggr -avg -pattern aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bit) (X_3:bte, X_4:lng, X_5:lng) -CMDBATavg3 -Calculate aggregate average of B. -aggr -avg -pattern aggr.avg(X_0:bat[:hge], X_1:bat[:oid], X_2:bit) (X_3:hge, X_4:lng, X_5:lng) -CMDBATavg3 -Calculate aggregate average of B. -aggr -avg -pattern aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bit) (X_3:int, X_4:lng, X_5:lng) -CMDBATavg3 -Calculate aggregate average of B. -aggr -avg -pattern aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bit) (X_3:lng, X_4:lng, X_5:lng) -CMDBATavg3 -Calculate aggregate average of B. -aggr -avg -pattern aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bit) (X_3:sht, X_4:lng, X_5:lng) -CMDBATavg3 -Calculate aggregate average of B. -aggr -avg -pattern aggr.avg(X_0:bat[:bte], X_1:bat[:lng], X_2:bat[:lng]):bte -CMDBATavg3comb -Average aggregation combiner. -aggr -avg -pattern aggr.avg(X_0:bat[:hge], X_1:bat[:lng], X_2:bat[:lng]):hge -CMDBATavg3comb -Average aggregation combiner. -aggr -avg -pattern aggr.avg(X_0:bat[:int], X_1:bat[:lng], X_2:bat[:lng]):int -CMDBATavg3comb -Average aggregation combiner. -aggr -avg -pattern aggr.avg(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:lng]):lng -CMDBATavg3comb -Average aggregation combiner. -aggr -avg -pattern aggr.avg(X_0:bat[:sht], X_1:bat[:lng], X_2:bat[:lng]):sht -CMDBATavg3comb -Average aggregation combiner. -aggr -avg -pattern aggr.avg(X_0:bat[:any_1]):dbl -CMDcalcavg -Gives the avg of all tail values -aggr -avg -pattern aggr.avg(X_0:bat[:any_1], X_1:int):dbl -CMDcalcavg -Gives the avg of all tail values -aggr -cardinality -command aggr.cardinality(X_0:bat[:any_2]):lng -ALGcard -Return the cardinality of the BAT tail values. -aggr -corr -command aggr.corr(X_0:bat[:bte], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr -Correlation aggregate -aggr -corr -command aggr.corr(X_0:bat[:dbl], X_1:bat[:dbl], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr -Correlation aggregate -aggr -corr -command aggr.corr(X_0:bat[:flt], X_1:bat[:flt], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr -Correlation aggregate -aggr -corr -command aggr.corr(X_0:bat[:hge], X_1:bat[:hge], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr -Correlation aggregate -aggr -corr -command aggr.corr(X_0:bat[:int], X_1:bat[:int], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr -Correlation aggregate -aggr -corr -command aggr.corr(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr -Correlation aggregate -aggr -corr -command aggr.corr(X_0:bat[:sht], X_1:bat[:sht], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr -Correlation aggregate -aggr -corr -command aggr.corr(X_0:bat[:any_2], X_1:bat[:any_2]):dbl -ALGcorr -Gives the correlation of all tail values -aggr -count -command aggr.count(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:any_2], X_3:bit):bat[:lng] _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
