The MonetDB team at MonetDB Solutions BV is pleased to announce the
Sep2022-SP1 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/>.
### Client Package
- Also dump the new options of CREATE USER.
### ODBC Driver
- Fixed issue with generated raw strings prefix when ODBC driver is used
against a server older than Jun2020 (11.37).
### MonetDB Common
- On Windows, use the wide-character interface of system calls when
dealing with the environment (i.e. file names and getenv()).
- Memory leaks have been fixed.
- Improved maintenance of the estimated number of distinct values in BATs.
The estimate helps in deciding which low-level algorithm to use.
- Offset heaps (.tailN files) were growing too fast and unnecessarily
under certain conditions. This has been fixed. Also, when such too
large files are now loaded into the system, it is recognized they are
too large and they are truncated to a more reasonable size.
### MonetDB5 Server
- Fixed a crash when the server runs out of client contexts (i.e. more
concurrent clients than the server is configured to handle).
- A race condition in the SHA hash code was fixed which resulted in
occasional failed connection attempts when they occurred concurrently.
- Fix a bug where the MAL optimizer would use the starttime of the
previous query to determine whether a query timeout occurred.
### SQL Frontend
- Improved the handling of the "idle" value in the sys.sessions function
and view.
### Merovingian
- Stop logging references to monetdbd's logfile in said logfile.
### Bug Fixes
- [7330](https://github.com/MonetDB/MonetDB/issues/7330): Creating temporary table fails after reconnect
- [7333](https://github.com/MonetDB/MonetDB/issues/7333): DLLs fail to load on Windows with accented characters in path
- [7336](https://github.com/MonetDB/MonetDB/issues/7336): Selecting from a literal-value table returns wrong values
- [7339](https://github.com/MonetDB/MonetDB/issues/7339): MonetDB corrupted state after SIGKILL
- [7342](https://github.com/MonetDB/MonetDB/issues/7342): column which datatype is double couldn't group or aggregation in version 11.45.7