The MonetDB team at MonetDB Solutions BV is pleased to announce the
Sep2022-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/sep2022/>.
As usual, the download location is <https://www.monetdb.org/downloads/>.
### ODBC Driver
- A crash in the ODBC driver was fixed when certain unsupported functions
where used in a {fn ...} escape.
- Prepare of a query where the sum of the number of parameters (question
marks in the query) and the number of output columns is larger than
100 could fail with an unexpected error. This has been fixed.
### MonetDB Common
- Fixed a race condition that could lead to a bat being added to the SQL
catalog but nog being made persistent, causing a subsequent restart
of the system to fail (and crash).
- Fixed a race condition where a hash could have been created on a
bat using the old bat count while in another thread the bat count
got updated. This would make the hash be based on too small a size,
causing failures later on.
- When extending a bat failed, the capacity had been updated already and
was therefore too large. This could then later cause a crash. This has
been fixed by only updating the capacity if the extend succeeded.
### SQL Frontend
- Fixed a regression where when there are multiple concurrent
transactions, the dependencies weren't checked properly.
- Added some error checking to prevent crashes. Errors would mainly
occur under memory pressure.
- Fixed cleanup after a failed allocation where the data being cleaned
up was unitialized but still used as pointers to memory that also had
to be freed.
- Fixed a double cleanup after a failed allocation in COPY INTO. The
double cleanup could cause a crash due to a race condition it enabled.
### Bug Fixes
- [7343](https://github.com/MonetDB/MonetDB/issues/7343): GDKmmap requesting 0 virtual memory
- [7347](https://github.com/MonetDB/MonetDB/issues/7347): A bug where an exception occurs even though it is a query with normal syntax (Merge Table)