Changeset: cab15f594070 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cab15f594070 Modified Files: ChangeLog clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test clients/Tests/exports.stable.out gdk/gdk.h monetdb5/mal/mal_client.c monetdb5/mal/mal_dataflow.c monetdb5/modules/atoms/mtime.c sql/backends/monet5/rel_bin.c sql/backends/monet5/rel_physical.c sql/backends/monet5/sql_result.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_time.c sql/common/sql_types.c sql/server/rel_select.c sql/server/sql_env.c sql/server/sql_mvc.c sql/server/sql_mvc.h sql/server/sql_parser.y sql/server/sql_semantic.c sql/server/sqlparse.c sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 Branch: default Log Message:
Moved client timezone information into the query context. This makes it easily available everywhere. diffs (truncated from 115303 to 300 lines): 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,10764 @@ 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] -AGGRcount3 -(empty) -aggr -count -command aggr.count(X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:any_2]):bat[:lng] -AGGRcount3nils -Grouped count -aggr _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
