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
