The MonetDB Foundation is pleased to announce the Dec2023-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/dec2023/.
As usual, the download location is https://www.monetdb.org/downloads/.
###
- The copyright for the MonetDB software has been transferred to the newly established MonetDB Foundation, a not-for-profit foundation with the express goal of furthering the MonetDB database system. The license for the software does not change: MonetDB remains fully open source.
### Client Package
- Fixed an issue where mclient wouldn't exit if the server it had connected to exited for whatever reason while the client was waiting for a query result.
### MonetDB Common
- The internal hash function for floating point types has been changed. It is now no longer based on the bit representation, but on the value, meaning that +0 and -0 (yes, they both exist in floating point) now hash to the same value.
- Fixed a regression where bats weren't always cleaned up when they weren't needed anymore. In particular, after a DELETE FROM table query without a WHERE clause (which deletes all rows from the table), the bats for the table get replaced by new ones, and the old, now unused, bats weren't removed from the database.
### Geom Module
- We switched over to using the reentrant interface of the geos library. This fixed a number of bugs that would occur sporadically.
### SQL Frontend
- performance improvement of 'startswith' and 'endswith' filter functions for join operators
- The function json.isvalid(json) incorrectly returned true if the argument was null. It should return null.
### Bug Fixes
- [6800](https://github.com/MonetDB/MonetDB/issues/6800): Please add information_schema (ANSI SQL norm)
- [7152](https://github.com/MonetDB/MonetDB/issues/7152): Occasional dbfarm corruption upon database restart
- [7390](https://github.com/MonetDB/MonetDB/issues/7390): Some MonetDB Server crashes found
- [7412](https://github.com/MonetDB/MonetDB/issues/7412): MonetDB server crashes in `vscanf`
- [7415](https://github.com/MonetDB/MonetDB/issues/7415): MonetDB server crashes in `HEAP_malloc`
- [7416](https://github.com/MonetDB/MonetDB/issues/7416): MonetDB server crashes in `atom_get_int`
- [7417](https://github.com/MonetDB/MonetDB/issues/7417): MonetDB server crashes in `trimchars`.
- [7418](https://github.com/MonetDB/MonetDB/issues/7418): MonetDB server crashes in `bind_col_exp`
- [7420](https://github.com/MonetDB/MonetDB/issues/7420): Performance issue with lower(string)
- [7425](https://github.com/MonetDB/MonetDB/issues/7425): The last statement, execution error, is a false positive?
- [7426](https://github.com/MonetDB/MonetDB/issues/7426): Unexpected result for INNER JOIN with IS NOT NULL
- [7428](https://github.com/MonetDB/MonetDB/issues/7428): Unexpected result when using BETWEEN operator
- [7429](https://github.com/MonetDB/MonetDB/issues/7429): Unexpected result when using `CASE WHEN`
- [7430](https://github.com/MonetDB/MonetDB/issues/7430): Unexpected result when using `AND` and `IS NOT NULL`
- [7431](https://github.com/MonetDB/MonetDB/issues/7431): [bug] Error code found, please confirm
- [7432](https://github.com/MonetDB/MonetDB/issues/7432): MonetDB server crashes in `dameraulevenshtein`
- [7433](https://github.com/MonetDB/MonetDB/issues/7433): MonetDB server crashes in `exp_atom`
- [7434](https://github.com/MonetDB/MonetDB/issues/7434): MonetDB server crashes in `exp_bin`
- [7435](https://github.com/MonetDB/MonetDB/issues/7435): MonetDB server crashes in `exp_copy`
- [7436](https://github.com/MonetDB/MonetDB/issues/7436): MonetDB server crashes in `exp_ref`
- [7437](https://github.com/MonetDB/MonetDB/issues/7437): MonetDB server crashes in `exp_values_set_supertype`
- [7438](https://github.com/MonetDB/MonetDB/issues/7438): MonetDB server crashes in `exps_bind_column`
- [7439](https://github.com/MonetDB/MonetDB/issues/7439): MonetDB server crashes in `exps_card`
- [7440](https://github.com/MonetDB/MonetDB/issues/7440): MonetDB server crashes in `gc_col`
- [7441](https://github.com/MonetDB/MonetDB/issues/7441): MonetDB server crashes in `is_column_unique`
- [7442](https://github.com/MonetDB/MonetDB/issues/7442): MonetDB server crashes in `mat_join2`
- [7443](https://github.com/MonetDB/MonetDB/issues/7443): MonetDB server crashes in `merge_table_prune_and_unionize`
- [7444](https://github.com/MonetDB/MonetDB/issues/7444): [bug] the table cannot be created because the reserved word is incorrectly set
- [7447](https://github.com/MonetDB/MonetDB/issues/7447): Unexpected result when using `BETWEEN` in `INNER JOIN`
- [7448](https://github.com/MonetDB/MonetDB/issues/7448): Unexpected result when using `AND`/`OR` chain
- [7450](https://github.com/MonetDB/MonetDB/issues/7450): Unexpected result when `CREATE VIEW` with `WHERE NULL`
- [7451](https://github.com/MonetDB/MonetDB/issues/7451): Unexpected result when using `BETWEEN` and `CAST`
- [7453](https://github.com/MonetDB/MonetDB/issues/7453): Cannot recover an msqldump
- [7455](https://github.com/MonetDB/MonetDB/issues/7455): Unexpected result when using `BETWEEN` with `BOOLEAN` values
- [7456](https://github.com/MonetDB/MonetDB/issues/7456): Crash when `INNER JOIN` with `VIEW`
- [7457](https://github.com/MonetDB/MonetDB/issues/7457): Unexpected result when using `AND` with `INTEGER`
- [7458](https://github.com/MonetDB/MonetDB/issues/7458): Unexpected result when using `SIGN`
- [7461](https://github.com/MonetDB/MonetDB/issues/7461): Crash by potentially use of bad escape characters
- [7462](https://github.com/MonetDB/MonetDB/issues/7462): Crash when using `BETWEEN AND`
- [7465](https://github.com/MonetDB/MonetDB/issues/7465): Unexpected result when using `NULL` in `BETWEEN`