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