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