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`