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