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)