The MonetDB team at MonetDB Solutions BV is pleased to announce the Jan2022-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/documentation/admin-guide/release-notes/jan2022/.

As usual, the download location is https://www.monetdb.org/downloads/.

### Client Package

- Improved the handling of the \r (internal pager) command in mclient. It now properly counts the header of table, and when a (very) long table is being printed and aborted part way in the built-in pager, not all data is transferred to the client (and then discarded). Instead at most 1000 rows are transferred.

### MonetDB Common

- Improved speed of BATappend to empty varsized bat: we now just copy the heaps instead of inserting individual values.

- Improved speed of projection (BATproject) on varsized bats by sharing the data heap (vheap).

- Fixed a race condition which could cause a too large size being written for a .theap file to the BBP.dir file after the correct size file had been saved to disk.

- We now ignore the size and capacity columns in the BBP.dir file. These values are essential during run time, but not useful in the on-disk image of the database.

- Fixed a bug in the append code for msk (bit mask) bats.

- Conversions from floating point types to integral types that involve multiplication now use the "long double" as intermediate type, thereby loosing as few significant bits as is feasible.

- Found and fixed another source for the now infamous BBPcheckbats error that sometimes occurs at startup of the server.

### MonetDB5 Server

- Improved parsing speed of blob values, especially on Windows. On Windows, using the locale-aware functions isdigit and isxdigit is comparatively very slow, so we avoid them.

### Bug Fixes

- [7252](https://github.com/MonetDB/MonetDB/issues/7252): Segmentation fault on second run

- [7253](https://github.com/MonetDB/MonetDB/issues/7253): Extremely slow INSERT INTO <table> SELECT

- [7254](https://github.com/MonetDB/MonetDB/issues/7254): Commit with deletions is very slow

- [7263](https://github.com/MonetDB/MonetDB/issues/7263): PRIMARY KEY constraint is not persistent through server restarts

- [7267](https://github.com/MonetDB/MonetDB/issues/7267): Update after delete does not update some rows

- [7278](https://github.com/MonetDB/MonetDB/issues/7278): BUG when there is more than one field/filter in the having clause