Changeset: 0fc8e4621eea for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0fc8e4621eea Modified Files: sql/server/sql_symbol.c Branch: nested Log Message:
merged with default diffs (truncated from 452 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -841,3 +841,4 @@ fd30df6fc710aa7615a995dd826389a67cddd47f 11a26808ab1bc96546077899924e5c31d7f2553c Mar2025_1 ad290be8174693266b1e4eeab06af0266686af38 Mar2025_3 ad290be8174693266b1e4eeab06af0266686af38 Mar2025_release +53b71d71caccc81358785cb852a186500fc95b08 Mar2025_5 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 @@ -1056,6 +1056,72 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd %endif %changelog +* 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/cmake/monetdb-versions.cmake b/cmake/monetdb-versions.cmake --- a/cmake/monetdb-versions.cmake +++ b/cmake/monetdb-versions.cmake @@ -43,21 +43,21 @@ set(MONETDB_VERSION "${MONETDB_VERSION_M # version of the GDK library (subdirectory gdk; also includes # common/options and common/utils) set(GDK_VERSION_MAJOR "30") -set(GDK_VERSION_MINOR "0") -set(GDK_VERSION_PATCH "1") +set(GDK_VERSION_MINOR "1") +set(GDK_VERSION_PATCH "0") set(GDK_VERSION "${GDK_VERSION_MAJOR}.${GDK_VERSION_MINOR}.${GDK_VERSION_PATCH}") # version of the MAPI library (subdirectory clients/mapilib) set(MAPI_VERSION_MAJOR "28") set(MAPI_VERSION_MINOR "0") -set(MAPI_VERSION_PATCH "0") +set(MAPI_VERSION_PATCH "1") set(MAPI_VERSION "${MAPI_VERSION_MAJOR}.${MAPI_VERSION_MINOR}.${MAPI_VERSION_PATCH}") # version of the MONETDB5 library (subdirectory monetdb5, not including # extras, and tools/utils/msabaoth.[ch]) set(MONETDB5_VERSION_MAJOR "37") set(MONETDB5_VERSION_MINOR "0") -set(MONETDB5_VERSION_PATCH "0") +set(MONETDB5_VERSION_PATCH "1") set(MONETDB5_VERSION "${MONETDB5_VERSION_MAJOR}.${MONETDB5_VERSION_MINOR}.${MONETDB5_VERSION_PATCH}") # version of the MONETDBE library (subdirectory tools/monetdbe) @@ -69,17 +69,17 @@ set(MONETDBE_VERSION "${MONETDBE_VERSION # version of the MUTILS library (subdirectory common/utils) set(MUTILS_VERSION_MAJOR "1") set(MUTILS_VERSION_MINOR "0") -set(MUTILS_VERSION_PATCH "0") +set(MUTILS_VERSION_PATCH "1") set(MUTILS_VERSION "${MUTILS_VERSION_MAJOR}.${MUTILS_VERSION_MINOR}.${MUTILS_VERSION_PATCH}") # version of the SQL library (subdirectory sql) set(SQL_VERSION_MAJOR "16") set(SQL_VERSION_MINOR "1") -set(SQL_VERSION_PATCH "0") +set(SQL_VERSION_PATCH "1") set(SQL_VERSION "${SQL_VERSION_MAJOR}.${SQL_VERSION_MINOR}.${SQL_VERSION_PATCH}") # version of the STREAM library (subdirectory common/stream) set(STREAM_VERSION_MAJOR "28") set(STREAM_VERSION_MINOR "0") -set(STREAM_VERSION_PATCH "0") +set(STREAM_VERSION_PATCH "1") set(STREAM_VERSION "${STREAM_VERSION_MAJOR}.${STREAM_VERSION_MINOR}.${STREAM_VERSION_PATCH}") diff --git a/debian/changelog b/debian/changelog --- a/debian/changelog +++ b/debian/changelog @@ -1,3 +1,93 @@ +monetdb (11.53.5) unstable; urgency=low + + * 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 + + -- Sjoerd Mullender <[email protected]> Fri, 27 Jun 2025 09:25:39 +0200 + +monetdb (11.53.5) unstable; urgency=low + + * 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. + + -- Lucas Pereira <[email protected]> Thu, 19 Jun 2025 09:25:39 +0200 + +monetdb (11.53.5) unstable; urgency=low + + * 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. + + -- Joeri van Ruth <[email protected]> Fri, 13 Jun 2025 09:25:39 +0200 + +monetdb (11.53.5) unstable; urgency=low + + * 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. + + -- Sjoerd Mullender <[email protected]> Tue, 3 Jun 2025 09:25:39 +0200 + +monetdb (11.53.5) unstable; urgency=low + + * 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. + + -- Sjoerd Mullender <[email protected]> Thu, 22 May 2025 09:25:39 +0200 + +monetdb (11.53.5) unstable; urgency=low + + * sql: Corrected reading decimal type columns from external ODBC data sources _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
