Changeset: 9cc342a4a23a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9cc342a4a23a Modified Files: clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test clients/Tests/exports.stable.out cmake/monetdb-findpackages.cmake monetdb5/modules/atoms/json.c monetdb5/modules/atoms/json.h monetdb5/modules/mal/batExtensions.c monetdb5/modules/mal/tablet.c monetdb5/modules/mal/tablet.h monetdb5/optimizer/opt_emptybind.c monetdb5/optimizer/opt_support.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_execute.c sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_rank.c sql/backends/monet5/sql_result.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_statement.h sql/backends/monet5/sql_upgrades.c sql/backends/monet5/vaults/csv/csv.c sql/backends/monet5/vaults/json/json.c sql/backends/monet5/vaults/monetdb/monetdb.c sql/backends/monet5/vaults/odbc/odbc_loader.c sql/common/sql_types.c sql/rel.txt sql/server/rel_basetable.c sql/server/rel_distribute.c sql/server/rel_dump.c sql/server/rel_exp.c sql/server/rel_exp.h sql/server/rel_optimize_others.c sql/server/rel_optimize_proj.c sql/server/rel_optimize_sel.c sql/server/rel_optimizer.c sql/server/rel_optimizer_private.h sql/server/rel_prop.c sql/server/rel_prop.h sql/server/rel_propagate.c sql/server/rel_psm.c sql/server/rel_rel.c sql/server/rel_rel.h sql/server/rel_rewriter.c sql/server/rel_rewriter.h sql/server/rel_schema.c sql/server/rel_select.c sql/server/rel_statistics.c sql/server/rel_unnest.c sql/server/rel_updates.c sql/server/sql_mvc.c sql/server/sql_mvc.h sql/server/sql_parser.y sql/server/sql_privileges.c sql/server/sql_scan.c sql/server/sql_semantic.c sql/server/sql_symbol.c sql/server/sql_symbol.h sql/storage/bat/bat_logger.c sql/storage/bat/bat_storage.c sql/storage/sql_catalog.c sql/storage/sql_storage.h sql/storage/store.c sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 testing/sqllogictest.py testing/sqltest.py tools/monetdbe/monetdbe.c tools/mserver/mserver5.c Branch: nested Log Message:
merge with default diffs (truncated from 58388 to 300 lines): diff --git a/.hgeol b/.hgeol --- a/.hgeol +++ b/.hgeol @@ -21,4 +21,4 @@ **.zip = BIN # all the rest is text -** = native +** = LF diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -848,3 +848,4 @@ 6d5be335a6c739e61682366f7a84b67b0cfc0be6 a63e11c1fd1b2dfba2a0ed8a985455286bc023d3 Mar2025_11 00d41c24cb9d5c43bd35e9e02e6a739a65c02810 Mar2025_13 00d41c24cb9d5c43bd35e9e02e6a739a65c02810 Mar2025_SP2_release +2842c30252114ac29284da18825ed15f86bc507f Mar2025_15 diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -95,7 +95,7 @@ Group: Applications/Databases License: MPL-2.0 URL: https://www.monetdb.org/ BugURL: https://github.com/MonetDB/MonetDB/issues -Source: https://www.monetdb.org/downloads/sources/Mar2025-SP2/MonetDB-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Mar2025-SP3/MonetDB-%{version}.tar.bz2 # The Fedora packaging document says we need systemd-rpm-macros for # the _unitdir and _tmpfilesdir macros to exist; however on RHEL 7 @@ -1057,6 +1057,48 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd %endif %changelog +* Tue Nov 04 2025 Sjoerd Mullender <[email protected]> - 11.53.15-20251104 +- Rebuilt. +- GH#7662: Privilege Issue: MonetDB Mar2025-SP1 does not check the + permission of 'DROP ROLE' and 'DROP USER' statements +- GH#7663: Privilege Issue: the `ALTER USER ... DEFAULT ROLE` statement + misses permission checks, which can cause privilege escalation to get + other users' privileges +- GH#7664: Privilege Issue: the `SET SESSION AUTHORIZATION` statement will + enable any user to alter other users' MAX_WORKERS +- GH#7665: MonetDB dev-builds crashes at `sql_trans_drop_trigger()` +- GH#7666: MonetDB Mar2025-SP1 unexpectly shutdown with crafted `GLOBAL + TEMPORARY TABLE` and `ALTER TABLE` statements +- GH#7668: MonetDB Mar2025-SP1 crashes at `key_dup()` +- GH#7669: MonetDB Mar2025-SP1 crashes at `AUTHdecypherValue()` +- GH#7670: MonetDB Mar2025-SP1 crashes at `exp_subtype()` +- GH#7672: MonetDB Mar2025-SP1 crashes at `find_name()` +- GH#7673: MonetDB Mar2025-SP1 crashes at `rel_value_exp2()` +- GH#7674: MonetDB Mar2025-SP1 crashes at `rel_schemas()` +- GH#7689: Empty SQL result (no rows, no columns) +- GH#7699: The OPTIMIZER string value in CREATE USER statement is not + checked on validity. +- GH#7702: Invalid handling of WHERE conditions +- GH#7706: Role (bob) missing +- GH#7710: Monetdb crash when using char datatype +- GH#7730: Incorrect arithmetic in generate_series with month-based + intervals +- GH#7732: Missing column name in select expands to all columns in table +- GH#7733: mserver5 assertion failure when started with -d2 --in-memory +- GH#7734: 'epoch' function doesn't handle fractions with leading zeros + correctly +- GH#7735: crash in Monetdb +- GH#7736: crash in MonetDB +- GH#7737: SQL Query Optimizer / Performance Regression with Merge Tables + in MonetDB 11.53 +- GH#7742: crash in MonetDB + +* Thu Sep 11 2025 Sjoerd Mullender <[email protected]> - 11.53.15-20251104 +- clients: Changed the --describe (-D) option of msqldump to really mean (as it + says in the manual) do a dump without the data. Before, the output + looked like a dump, but could not necessarily be fed back into an + mserver5, i.e. it wasn't really a dump without data. + * Mon Sep 01 2025 Sjoerd Mullender <[email protected]> - 11.53.13-20250901 - Rebuilt. - GH#7692: Illegal argument on range select with equality diff --git a/clients/ChangeLog-Archive b/clients/ChangeLog-Archive --- a/clients/ChangeLog-Archive +++ b/clients/ChangeLog-Archive @@ -1,6 +1,12 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Thu Sep 11 2025 Sjoerd Mullender <[email protected]> - 11.53.15-20251104 +- Changed the --describe (-D) option of msqldump to really mean (as it + says in the manual) do a dump without the data. Before, the output + looked like a dump, but could not necessarily be fed back into an + mserver5, i.e. it wasn't really a dump without data. + * Thu Aug 28 2025 Sjoerd Mullender <[email protected]> - 11.53.13-20250901 - We now try to figure out the size of the terminal window on Windows. This means that mclient will, by default, format tabular output to diff --git a/clients/ChangeLog.Mar2025 b/clients/ChangeLog.Mar2025 --- a/clients/ChangeLog.Mar2025 +++ b/clients/ChangeLog.Mar2025 @@ -1,9 +1,3 @@ # ChangeLog file for clients # This file is updated with Maddlog -* Thu Sep 11 2025 Sjoerd Mullender <[email protected]> -- Changed the --describe (-D) option of msqldump to really mean (as it - says in the manual) do a dump without the data. Before, the output - looked like a dump, but could not necessarily be fed back into an - mserver5, i.e. it wasn't really a dump without data. - 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 @@ -1044,6 +1044,36 @@ command aggr.quantile_avg(X_0:bat[:any_1 AGGRquantile_avg_cst Quantile aggregate aggr +ripemd160 +command aggr.ripemd160(X_0:bat[:str]):str +AGGRripemd160 +Ungrouped RIPEMD160 +aggr +sha1 +command aggr.sha1(X_0:bat[:str]):str +AGGRsha1 +Ungrouped SHA1 +aggr +sha224 +command aggr.sha224(X_0:bat[:str]):str +AGGRsha224 +Ungrouped SHA224 +aggr +sha256 +command aggr.sha256(X_0:bat[:str]):str +AGGRsha256 +Ungrouped SHA256 +aggr +sha384 +command aggr.sha384(X_0:bat[:str]):str +AGGRsha384 +Ungrouped SHA384 +aggr +sha512 +command aggr.sha512(X_0:bat[:str]):str +AGGRsha512 +Ungrouped SHA512 +aggr stdev command aggr.stdev(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] AGGRstdev3_dbl @@ -1125,54 +1155,14 @@ ALGstdevp Gives the standard deviation of all tail values aggr str_group_concat -command aggr.str_group_concat(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1]):bat[:str] +command aggr.str_group_concat(X_0:bat[:str]):str AGGRstr_group_concat -Grouped string tail concat -aggr -str_group_concat -command aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bat[:oid], X_3:bat[:any_1]):bat[:str] -AGGRstr_group_concat_sep -Grouped string tail concat with custom separator -aggr -str_group_concat -pattern aggr.str_group_concat(X_0:bat[:str]):str -CMDBATstr_group_concat -Calculate aggregate string concatenate of B. -aggr -str_group_concat -pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:oid]):str -CMDBATstr_group_concat -Calculate aggregate string concatenate of B with candidate list. +Ungrouped string tail concat aggr str_group_concat -pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:oid], X_2:bit):str -CMDBATstr_group_concat -Calculate aggregate string concatenate of B with candidate list. -aggr -str_group_concat -pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str]):str -CMDBATstr_group_concat -Calculate aggregate string concatenate of B with separator SEP. -aggr -str_group_concat -pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bat[:oid]):str -CMDBATstr_group_concat -Calculate aggregate string concatenate of B with candidate list and separator SEP. -aggr -str_group_concat -pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bat[:oid], X_3:bit):str -CMDBATstr_group_concat -Calculate aggregate string concatenate of B with candidate list and separator SEP. -aggr -str_group_concat -pattern aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bit):str -CMDBATstr_group_concat -Calculate aggregate string concatenate of B with separator SEP. -aggr -str_group_concat -pattern aggr.str_group_concat(X_0:bat[:str], X_1:bit):str -CMDBATstr_group_concat -Calculate aggregate string concatenate of B. +command aggr.str_group_concat(X_0:bat[:str], X_1:bat[:str]):str +AGGRstr_group_concat_sep +Ungrouped string tail concat with custom separator aggr subCollect command aggr.subCollect(X_0:bat[:wkb], X_1:bat[:oid], X_2:bat[:oid], X_3:bit):bat[:wkb] @@ -2074,6 +2064,36 @@ command aggr.subquantile_avg(X_0:bat[:an AGGRsubquantilecand_avg Grouped quantile aggregate with candidate list aggr +subripemd160 +command aggr.subripemd160(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRripemd160grouped +Grouped RIPEMD160 +aggr +subsha1 +command aggr.subsha1(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha1grouped +Grouped SHA1 +aggr +subsha224 +command aggr.subsha224(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha224grouped +Grouped SHA224 +aggr +subsha256 +command aggr.subsha256(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha256grouped +Grouped SHA256 +aggr +subsha384 +command aggr.subsha384(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha384grouped +Grouped SHA384 +aggr +subsha512 +command aggr.subsha512(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:str] +AGGRsha512grouped +Grouped SHA512 +aggr substdev command aggr.substdev(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:dbl] AGGRsubstdev_dbl @@ -2224,16 +2244,6 @@ command aggr.substr_group_concat(X_0:bat AGGRsubstr_group_concat_sep Grouped string concat with custom separator aggr -substr_group_concat -command aggr.substr_group_concat(X_0:bat[:str], X_1:bat[:oid], X_2:bat[:any_1], X_3:bat[:oid], X_4:bit):bat[:str] -AGGRsubstr_group_concatcand -Grouped string concat with candidates list -aggr -substr_group_concat -command aggr.substr_group_concat(X_0:bat[:str], X_1:bat[:str], X_2:bat[:oid], X_3:bat[:any_1], X_4:bat[:oid], X_5:bit):bat[:str] -AGGRsubstr_group_concatcand_sep -Grouped string concat with candidates list with custom separator -aggr subsum command aggr.subsum(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:bit):bat[:bte] AGGRsubsum_bte @@ -50149,6 +50159,16 @@ pattern sql.importColumn(X_0:str, X_1:in mvc_bin_import_column_wrap Import a column from the given file sql +importNulTerminated +pattern sql.importNulTerminated(X_0:str, X_1:int, X_2:bat[:bte], X_3:oid) (X_4:bat[:any], X_5:oid) +mvc_bin_import_nul_terminated_wrap +Import a column from the bytes in the given bat +sql +importRaw +pattern sql.importRaw(X_0:str, X_1:int, X_2:oid) (X_3:bat[:any], X_4:oid) +mvc_bin_import_bytes_wrap +Import the raw bytes from the given file +sql include unsafe pattern sql.include(X_0:str):void SQLinclude diff --git a/clients/Tests/MAL-signatures.test b/clients/Tests/MAL-signatures.test --- a/clients/Tests/MAL-signatures.test +++ b/clients/Tests/MAL-signatures.test @@ -864,6 +864,36 @@ command aggr.quantile_avg(X_0:bat[:any_1 AGGRquantile_avg_cst Quantile aggregate aggr +ripemd160 +command aggr.ripemd160(X_0:bat[:str]):str +AGGRripemd160 +Ungrouped RIPEMD160 +aggr +sha1 +command aggr.sha1(X_0:bat[:str]):str +AGGRsha1 +Ungrouped SHA1 +aggr +sha224 +command aggr.sha224(X_0:bat[:str]):str +AGGRsha224 +Ungrouped SHA224 +aggr _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
