The MonetDB Foundation is pleased to announce the Aug2024-SP1 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at https://www.monetdb.org/. For details on this release, please see the release notes at https://www.monetdb.org/release-notes/aug2024/. As usual, the download location is https://www.monetdb.org/downloads/. ### MonetDB5 Server - The server prints out an informative message for the case of a graceful termination. ### SQL Frontend - Improve casting to generic decimal type by choosing a better fit for precision and scale instead of defaulting to 18 and 3, respectively. - When for whatever reason the upgrade code produces an error, we now exit the server. Before the server would limp on with what is basically a broken database. - Improved the violation message of CHECK constraints when violated. It now includes the schema name of the constraint and the check clause. - Increase the buffer size used by hot snapshot from 64kiB to 1MiB, and make it configurable through setting 'hot_snapshot_buffer_size'. It must be a multiple of 512. ### Merovingian - Tweak socket parameters to simulate network activity on client connections. This prevents firewalls from killing connections that seem idle but are actually waiting for a long-running query. Can be controlled with a new 'keepalive' option to monetdbd. ### Bug Fixes - [7281](https://github.com/MonetDB/MonetDB/issues/7281): UDFs defined at compile time in a user schema should not become system functions - [7563](https://github.com/MonetDB/MonetDB/issues/7563): Unexpected result when using `IS DISTINCT FROM` in `VIEW` - [7567](https://github.com/MonetDB/MonetDB/issues/7567): creating remote table from subquery crashes the server - [7569](https://github.com/MonetDB/MonetDB/issues/7569): Column of temporary table changes when another is updated - [7570](https://github.com/MonetDB/MonetDB/issues/7570): BUG in the "str_to_timestamp" function - [7571](https://github.com/MonetDB/MonetDB/issues/7571): Crash when integer overflow in `ORDER BY` - [7572](https://github.com/MonetDB/MonetDB/issues/7572): column max length is not stored as specified and accepted at creation time - [7575](https://github.com/MonetDB/MonetDB/issues/7575): Incorrect BAT properties after mmapped BAT "leaks" to disk with restart. - [7576](https://github.com/MonetDB/MonetDB/issues/7576): unescaping UTF-16 code units goes wrong in json.text - [7577](https://github.com/MonetDB/MonetDB/issues/7577): Crash when using `CHECK` constraint - [7580](https://github.com/MonetDB/MonetDB/issues/7580): statistics optimizer handles date difference incorrectly - [7582](https://github.com/MonetDB/MonetDB/issues/7582): SIGSEGV when creating a SQL function with RETURN CASE WHEN EXISTS (..) - [7583](https://github.com/MonetDB/MonetDB/issues/7583): Query slowdown after deleting rows from large table - [7584](https://github.com/MonetDB/MonetDB/issues/7584): SO_KEEPALIVE should be configured sensibly - [7585](https://github.com/MonetDB/MonetDB/issues/7585): rel2bin_join: Assertion `sql->session->status == -10' failed. - [7587](https://github.com/MonetDB/MonetDB/issues/7587): Line/row numbers get out of sync with COPY INTO .. BEST EFFORT