The MonetDB team at MonetDB Solutions BV is pleased to announce the Jun2023-SP2 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/jun2023/.
As usual, the download location is https://www.monetdb.org/downloads/.
###
- Fixed an installation issue on Debian and Ubuntu introduced in the last build.
- Do a lot more error checking, mostly for allocation failures. More is still needed, though.
- Improve performance of the ILIKE operator when the pattern contains only ASCII characters. In this case we do not need to treat any characters as UTF-8 and we can use much faster routines that perform byte comparisons.
### MonetDB Common
- Fixed a number of data races (race conditions).
- Fixed a reference counting problem when a BAT could nog be loaded, e.g. because of resource limitations.
- Only check for virtual memory limits when creating or growing bats, not for general memory allocations. There is (still) too much code that doesn't properly handle failing allocations, so we need to avoid those as much as possible. This has mostly an effect if there are virtual memory size restrictions imposed by cgroups (memory.swap.max in cgroups v2, memory.memsw.limit_in_bytes in cgroups v1).
- The low-level commit turned out to always commit every persistent bat in the system. There is no need for that, it should only commit bats that were changed. This has now been fixed.
- Implemented timeout/exit checks in a bunch more operators. Long(er) running operators occasionally check whether they're taking too long (past a user-specified timeout) or whether the server is exiting. This is now done in more places.
### Bug Fixes
- [7094](https://github.com/MonetDB/MonetDB/issues/7094): Drop remote tables in transactions and rollback
- [7303](https://github.com/MonetDB/MonetDB/issues/7303): Improve the performance of multi-column filters
- [7400](https://github.com/MonetDB/MonetDB/issues/7400): VM max memory is not check correctly for cgroups v2
- [7401](https://github.com/MonetDB/MonetDB/issues/7401): Column aliases used incorrectly in UNION subqueries
- [7402](https://github.com/MonetDB/MonetDB/issues/7402): Privileges on merge table not propagated to partition tables