Changeset: 471c071577fb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/471c071577fb Modified Files: sql/backends/monet5/sql_result.c Branch: resource_management Log Message:
merge upstream diffs (truncated from 4800 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -841,3 +841,6 @@ fd30df6fc710aa7615a995dd826389a67cddd47f 11a26808ab1bc96546077899924e5c31d7f2553c Mar2025_1 ad290be8174693266b1e4eeab06af0266686af38 Mar2025_3 ad290be8174693266b1e4eeab06af0266686af38 Mar2025_release +53b71d71caccc81358785cb852a186500fc95b08 Mar2025_5 +77b1be95dc79fe61215a34b84ed67e7097323977 Mar2025_7 +6d5be335a6c739e61682366f7a84b67b0cfc0be6 Mar2025_9 diff --git a/ChangeLog-Archive b/ChangeLog-Archive --- a/ChangeLog-Archive +++ b/ChangeLog-Archive @@ -1,6 +1,12 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Thu May 8 2025 Sjoerd Mullender <[email protected]> - 11.53.5-20250627 +- It is now possible to specify an idle timeout using --set + idle_timeout=<seconds> (see mserver5 manual page) which gets triggered + if a connection to the server is idle (i.e. does not send any queries + to the server) while there is a SQL transaction active. + * Tue Mar 11 2025 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 - There is a new shared library called libmutils that contains some utility functions that are used by several programs. diff --git a/ChangeLog.Mar2025 b/ChangeLog.Mar2025 --- a/ChangeLog.Mar2025 +++ b/ChangeLog.Mar2025 @@ -1,9 +1,3 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Thu May 8 2025 Sjoerd Mullender <[email protected]> -- It is now possible to specify an idle timeout using --set - idle_timeout=<seconds> (see mserver5 manual page) which gets triggered - if a connection to the server is idle (i.e. does not send any queries - to the server) while there is a SQL transaction active. - 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/MonetDB-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Mar2025-SP1/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 @@ -964,6 +964,7 @@ sed -i 's/1\.2/1.1/' misc/selinux/monetd %endif %cmake3 \ + -DCMAKE_BUILD_TYPE=Release \ -DCMAKE_INSTALL_RUNSTATEDIR=/run \ -DRELEASE_VERSION=ON \ -DASSERT=OFF \ @@ -1056,6 +1057,81 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd %endif %changelog +* Fri Jul 04 2025 Sjoerd Mullender <[email protected]> - 11.53.9-20250704 +- Rebuilt. +- GH#7629: monetdbd causes SELinux denial +- GH#7654: Query remote table that targets remote server table not owned + by monetdb default user + +* Mon Jun 30 2025 Sjoerd Mullender <[email protected]> - 11.53.7-20250630 +- Rebuilt. + +* Fri Jun 27 2025 Sjoerd Mullender <[email protected]> - 11.53.5-20250627 +- Rebuilt. +- GH#7625: Missing entry in sys.table_types table for new LOCAL TEMPORARY + VIEW +- GH#7626: crash in window function with constant aggregation +- GH#7627: Increased memory consumption, slowness and crash +- GH#7632: Unexpected Left Join Crash +- GH#7633: Unexpected Out of Memory of Inner Join +- GH#7634: Join with subquery crash +- GH#7636: Unexpected Anti Join Crash +- GH#7638: PREPARE statement increases the memory use of the session even + when DEALLOCATEd +- GH#7644: Unexpected anti join crash +- GH#7646: Unexpected Left Join Crash + +* Thu Jun 19 2025 Lucas Pereira <[email protected]> - 11.53.5-20250627 +- sql: When a prepared statement is executed, sys.queue now shows the text + of the original PREPARE statement along with the EXEC and its arguments. + +* Fri Jun 13 2025 Joeri van Ruth <[email protected]> - 11.53.5-20250627 +- sql: Add optional parameters omit_unlogged (bool) and omit_table_ids (str) to + sys.hot_snapshot(). If omit_unlogged is set to true, the data in UNLOGGED + tables is omitted from the snapshot. If omit_table_ids is given, it must + be a comma-separated list of table ids as found in sys.tables. The data in + each of those tables will be omitted from the snapshot. +- sql: Empty BATs are omitted from the snapshot, the restored server will created + them if necessary. + +* Tue Jun 3 2025 Sjoerd Mullender <[email protected]> - 11.53.5-20250627 +- clients: When connecting to a database, if there are multiple monetdbd servers + running, mclient will try them all, and also both UNIX domain + sockets and then TCP, in order to find a server that accepts the + connection. However, when a server that handles the requested + database does exist but refuses the connection for some other + reason, mclient would continue searching. This has now been + changed. If monetdbd reports an error other than database unknown, + mclient will now stop looking and report the error. This is + actually a change in the "mapi" library, so any program using the + library gets the new behavior. +- clients: There is a new option --quiet (or just -q) in mclient. If used, the + welcome message that is normally printed in an interactive invocation + is suppressed. + +* Thu May 22 2025 Sjoerd Mullender <[email protected]> - 11.53.5-20250627 +- merovingian: When mserver5 is started by monetdbd due to an implicit request + (application trying to connect to a database), and mserver5 crashes + or exits before a connection can be established, monetdbd will stop + trying to start the server after a few attempts. When using an explicit + command to start the server (using monetdb start), monetdbd will always + attempt to start the server. + +* Wed May 14 2025 Martin van Dinther <[email protected]> - 11.53.5-20250627 +- sql: Corrected reading decimal type columns from external ODBC data sources + via proto_loader('odbc:...'). Those columns were mapped to varchar type + columns. Now they will be mapped to decimal type, when possible. + +* Fri May 9 2025 Sjoerd Mullender <[email protected]> - 11.53.5-20250627 +- clients: There is now a \dm command in the interactive mclient to show + information about merge tables. + +* Thu May 8 2025 Sjoerd Mullender <[email protected]> - 11.53.5-20250627 +- MonetDB: It is now possible to specify an idle timeout using --set + idle_timeout=<seconds> (see mserver5 manual page) which gets triggered + if a connection to the server is idle (i.e. does not send any queries + to the server) while there is a SQL transaction active. + * Mon Mar 24 2025 Sjoerd Mullender <[email protected]> - 11.53.3-20250324 - Rebuilt. - GH#7622: In PREPARE queries with many parameters, information about diff --git a/clients/ChangeLog-Archive b/clients/ChangeLog-Archive --- a/clients/ChangeLog-Archive +++ b/clients/ChangeLog-Archive @@ -1,6 +1,25 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Tue Jun 3 2025 Sjoerd Mullender <[email protected]> - 11.53.5-20250627 +- When connecting to a database, if there are multiple monetdbd servers + running, mclient will try them all, and also both UNIX domain + sockets and then TCP, in order to find a server that accepts the + connection. However, when a server that handles the requested + database does exist but refuses the connection for some other + reason, mclient would continue searching. This has now been + changed. If monetdbd reports an error other than database unknown, + mclient will now stop looking and report the error. This is + actually a change in the "mapi" library, so any program using the + library gets the new behavior. +- There is a new option --quiet (or just -q) in mclient. If used, the + welcome message that is normally printed in an interactive invocation + is suppressed. + +* Fri May 9 2025 Sjoerd Mullender <[email protected]> - 11.53.5-20250627 +- There is now a \dm command in the interactive mclient to show + information about merge tables. + * Tue Feb 18 2025 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 - Support for dumping databases from servers from before Jul2021 (11.41.X) has been removed. diff --git a/clients/ChangeLog.Mar2025 b/clients/ChangeLog.Mar2025 --- a/clients/ChangeLog.Mar2025 +++ b/clients/ChangeLog.Mar2025 @@ -1,22 +1,3 @@ # ChangeLog file for clients # This file is updated with Maddlog -* Tue Jun 3 2025 Sjoerd Mullender <[email protected]> -- When connecting to a database, if there are multiple monetdbd servers - running, mclient will try them all, and also both UNIX domain - sockets and then TCP, in order to find a server that accepts the - connection. However, when a server that handles the requested - database does exist but refuses the connection for some other - reason, mclient would continue searching. This has now been - changed. If monetdbd reports an error other than database unknown, - mclient will now stop looking and report the error. This is - actually a change in the "mapi" library, so any program using the - library gets the new behavior. -- There is a new option --quiet (or just -q) in mclient. If used, the - welcome message that is normally printed in an interactive invocation - is suppressed. - -* Fri May 9 2025 Sjoerd Mullender <[email protected]> -- There is now a \dm command in the interactive mclient to show - information about merge tables. - 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 @@ -49129,6 +49129,16 @@ unsafe pattern sql.hot_snapshot(X_0:str, SQLhot_snapshot Write db snapshot to the given tar(.gz/.lz4/.bz/.xz) file on either server or client sql +hot_snapshot +unsafe pattern sql.hot_snapshot(X_0:str, X_1:bit, X_2:bit):void +SQLhot_snapshot +Write db snapshot to the given tar(.gz/.lz4/.bz/.xz) file on either server or client, omitting some bats +sql +hot_snapshot +unsafe pattern sql.hot_snapshot(X_0:str, X_1:bit, X_2:bit, X_3:str):void +SQLhot_snapshot +Write db snapshot to the given tar(.gz/.lz4/.bz/.xz) file on either server or client, omitting some bats +sql importColumn pattern sql.importColumn(X_0:str, X_1:int, X_2:bit, X_3:str, X_4:int, X_5:oid) (X_6:bat[:any], X_7:oid) mvc_bin_import_column_wrap 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 @@ -37584,6 +37584,16 @@ unsafe pattern sql.hot_snapshot(X_0:str, SQLhot_snapshot Write db snapshot to the given tar(.gz/.lz4/.bz/.xz) file on either server or client sql +hot_snapshot +unsafe pattern sql.hot_snapshot(X_0:str, X_1:bit, X_2:bit):void +SQLhot_snapshot +Write db snapshot to the given tar(.gz/.lz4/.bz/.xz) file on either server or client, omitting some bats +sql +hot_snapshot +unsafe pattern sql.hot_snapshot(X_0:str, X_1:bit, X_2:bit, X_3:str):void +SQLhot_snapshot +Write db snapshot to the given tar(.gz/.lz4/.bz/.xz) file on either server or client, omitting some bats +sql importColumn pattern sql.importColumn(X_0:str, X_1:int, X_2:bit, X_3:str, X_4:int, X_5:oid) (X_6:bat[:any], X_7:oid) mvc_bin_import_column_wrap 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 @@ -215,6 +215,9 @@ gdk_return BATupdatepos(BAT *b, const oi BBPrec *BBP[N_BBPINIT]; gdk_return BBPaddfarm(const char *dirname, uint32_t rolemask, bool logerror); void BBPcold(bat i); +gdk_return BBPdir_first(bool subcommit, lng logno, FILE **obbpfp, FILE **nbbpfp); +gdk_return BBPdir_last(int n, char *buf, size_t bufsize, FILE *obbpf, FILE *nbbpf); +bat BBPdir_step(bat bid, BUN size, int n, char *buf, size_t bufsize, FILE **obbpfp, FILE *nbbpf, BATiter *bi, int *nbatp); int BBPfix(bat b); unsigned BBPheader(FILE *fp, int *lineno, bat *bbpsize, lng *logno, bool allow_hge_upgrade); bat BBPindex(const char *nme); diff --git a/clients/odbc/driver/ODBCDbc.c b/clients/odbc/driver/ODBCDbc.c --- a/clients/odbc/driver/ODBCDbc.c +++ b/clients/odbc/driver/ODBCDbc.c @@ -97,10 +97,10 @@ newODBCDbc(ODBCEnv *env) * and save usage of the handle and prevent crashes as much as possible. * * Precondition: none - * Postcondition: returns 1 if it is a valid connection handle, - * returns 0 if is invalid and thus an unusable handle. + * Postcondition: returns true if it is a valid connection handle, + * returns false if is invalid and thus an unusable handle. */ -int +bool isValidDbc(ODBCDbc *dbc) { #ifdef ODBCDEBUG diff --git a/clients/odbc/driver/ODBCDbc.h b/clients/odbc/driver/ODBCDbc.h --- a/clients/odbc/driver/ODBCDbc.h +++ b/clients/odbc/driver/ODBCDbc.h @@ -93,10 +93,10 @@ ODBCDbc *newODBCDbc(ODBCEnv *env); * and save usage of the handle and prevent crashes as much as possible. * * Precondition: none - * Postcondition: returns 1 if it is a valid connection handle, - * returns 0 if is invalid and thus an unusable handle. + * Postcondition: returns true if it is a valid connection handle, + * returns false if is invalid and thus an unusable handle. */ -int isValidDbc(ODBCDbc *dbc); +bool isValidDbc(ODBCDbc *dbc); /* diff --git a/clients/odbc/driver/ODBCDesc.c b/clients/odbc/driver/ODBCDesc.c --- a/clients/odbc/driver/ODBCDesc.c +++ b/clients/odbc/driver/ODBCDesc.c @@ -52,10 +52,10 @@ newODBCDesc(ODBCDbc *dbc) * and save usage of the handle and prevent crashes as much as possible. * * Precondition: none - * Postcondition: returns 1 if it is a valid statement handle, - * returns 0 if is invalid and thus an unusable handle. + * Postcondition: returns true if it is a valid statement handle, + * returns false if is invalid and thus an unusable handle. */ -int +bool isValidDesc(ODBCDesc *desc) { #ifdef ODBCDEBUG _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
