- developers-list - monetdb.org

Announcement: New Dec2025 Feature release of MonetDB suite
by Sjoerd Mullender 16 Dec '25

16 Dec '25

The MonetDB Foundation is pleased to announce the Dec2025 feature 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/dec2025/>. As usual, the download location is <https://www.monetdb.org/downloads/>. The Dec2025 documentation can be found [here](https://www.monetdb.org/documentation-Dec2025/). ## Dec2025 Feature Release (11.55.1) ### - This server is no longer compatible with the MonetDB Stethoscope. - Changed the way complex AND and OR expressions are handled. The new expression tree uses 2 new cmp flag (cmp_con/cmp_dis), both expressions hold lists of expressions. This structure reduces the need for stack space, allowing way larger expressions trees to be handled. ### ODBC Driver - Corrected SQLColAttribute() and SQLGetDescField() for when FieldIdentifier is SQL_DESC_LITERAL_PREFIX or SQL_DESC_LITERAL_SUFFIX. They will now return the correct literal prefix or suffix string instead of an empty string depending on the datatype of the column. ### MonetDB Common - log_tflush function, when flushnow flag is true, now passes bitmap array that indicates which bat id's need to be sync'ed to disk, instead of passing NULL which would trigger a sync of the full catalog. If new bats are added to the catalog, they will be sync'ed always (see maxupdated flag). ### MonetDB5 Server - We no longer persist querylog results. If you want to keep the data, make a copy into an SQL table. - The default_fast and minimal_fast optimizer pipelines have been removed. The default_pipe and minimal_pipe optimizers now use the "fast" path always. - The type "pcre" has been removed. There was no way to create a value of the type, and there was only one function that used a value of the type. That function (pcre.index) has also been removed. ### SQL Frontend - Add functions to_hex(int) and to_hex(bigint). They return the unsigned hexadecimal string representation of their argument. - COPY BINARY has been optimized to be much faster when many string columns are involved. - The performance of COPY BINARY of blob column has also been improved. - The performance of COPY BINARY ON CLIENT has been much improved. It used to be much slower than ON SERVER, now it's only a little slower. - The file format for COPY BINARY strings has been extended. If the same string occurs multiple times, later occurrences can refer back to earlier occurrences instead of including another copy of the string. This improves both file size and processing time. - A new example tool 'backrefencode' has been added that can introduce these back references or remove them again. - Experimental support for compressed ON CLIENT transfers has been added. If you write ON 'algo' CLIENT, with algo=lz4/gz/xz/b2, the server compresses downloaded data and decompresses uploaded data server-side using the given algorithm. It is up to the user to ensure that the uploaded data has indeed been compressed. This is not always easy because many clients automatically compress or decompress data when the file name contains .gz, .lz4, etc., which would lead to double compression and decompression. - Implemented aggregates sha1, sha224, sha256, sha384, sha512, and ripemd160 which calculate a checksum (digest) over a column of strings. It only makes sense to use these with an ordering, as `SELECT sha256(name ORDER BY id) FROM table`, since the ordering in which the values are fed into the digest algorithm is important and cannot otherwise be guaranteed. - EXPLAIN now supports a BEFORE/AFTER LOGICAL UNNEST/LOGICAL REWRITE/PHYSICAL clause to indicate which phase of query compilation to show. A plain EXPLAIN is equivalent to EXPLAIN AFTER REWRITE, which is what PLAN used to do. The old EXPLAIN is now EXPLAIN PHYSICAL. LOGICAL REWRITE also supports specifying two positive values, rewriter index number and optimizer loop cycle stop counter. SHOW DETAILS includes more information about properties, rewriters number of changes and time spent. - The PLAN keyword has been removed. - The TRACE prefix for SQL queries now no longer produces two result sets. Before, the first result set was the result of the query, and the second result set was timing information of the query execution. This second result set is no longer produced. Instead, use the (already existing) function sys.tracelog() or the view sys.tracelog to retrieve this information. As before, the table that is produced by the function/view is reset whenever a new TRACE prefixed query is executed. - Removed table returning function sys.optimizer_stats(). - There are new types "inet4" and "inet6" which can hold respectively IPv4 and IPv6 internet addresses without CIDR network mask information. Netmask information can be held in a separate column if they are needed. The 0 address (0.0.0.0 and ::) are used as NULL value and can therefore not be used as addresses. Bitwise operations (AND, OR, XOR, NOT) are supported on the addresses, and there are various functions to check whether an address is contained in a (sub)net (where an extra CIDR netmask column is also needed). - Added the possibility to specify IF NOT EXISTS for the following CREATE statements: CREATE SEQUENCE IF NOT EXISTS seq_name ... CREATE USER IF NOT EXISTS user_name ... CREATE ROLE IF NOT EXISTS role_name ... CREATE TYPE IF NOT EXISTS type_name ... CREATE INDEX IF NOT EXISTS index_name ON ... CREATE IMPRINTS INDEX IF NOT EXISTS index_name ON ... CREATE ORDERED INDEX IF NOT EXISTS index_name ON ... With IF NOT EXISTS specified these CREATE statements will not return an error when an object with the same name already exists. See doc: https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/ - Added the possibility to specify IF EXISTS for the following DROP statements: DROP SEQUENCE IF EXISTS seq_name ... DROP USER IF EXISTS user_name DROP ROLE IF EXISTS role_name DROP TYPE IF EXISTS type_name ... DROP INDEX IF EXISTS index_name With IF EXISTS specified these statements will not return an error when the object does not exists. See doc: https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition… - Added the possibility to specify IF EXISTS for two ALTER statements: ALTER SEQUENCE IF EXISTS seq_name ... ALTER USER IF EXISTS user_name ... With IF EXISTS specified these statements will not return an error when the object does not exists. See doc: https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition… and https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition… - It is now possible to change the type of a column by using a statement like ALTER TABLE t ALTER COLUMN c type;. The content of the column is converted to the new type using code similar to CAST(c AS type). If the conversion fails, the column type isn't changed. - With COPY INTO, the USING DELIMITERS, DECIMAL, ESCAPE, NULL, BEST EFFORT and FWF clauses can now be given in any order. If a clause occurs multiple times, the last instance wins. ### Bug Fixes - [7635](https://github.com/MonetDB/MonetDB/issues/7635): Unexpected Inner Join Crash - [7645](https://github.com/MonetDB/MonetDB/issues/7645): Unexpected Internal Error in Inner Join - [7651](https://github.com/MonetDB/MonetDB/issues/7651): Incorrect Anti Join Result - [7652](https://github.com/MonetDB/MonetDB/issues/7652): Incorrect Anti Join Result related to optimization - [7653](https://github.com/MonetDB/MonetDB/issues/7653): Incorrect Inner Join Result - [7663](https://github.com/MonetDB/MonetDB/issues/7663): Privilege Issue: the `ALTER USER ... DEFAULT ROLE` statement misses permission checks, which can cause privilege escalation to get other users' privileges - [7664](https://github.com/MonetDB/MonetDB/issues/7664): Privilege Issue: the `SET SESSION AUTHORIZATION` statement will enable any user to alter other users' MAX_WORKERS - [7665](https://github.com/MonetDB/MonetDB/issues/7665): MonetDB dev-builds crashes at `sql_trans_drop_trigger()` - [7666](https://github.com/MonetDB/MonetDB/issues/7666): MonetDB Mar2025-SP1 unexpectly shutdown with crafted `GLOBAL TEMPORARY TABLE` and `ALTER TABLE` statements - [7667](https://github.com/MonetDB/MonetDB/issues/7667): MonetDB Mar2025-SP1 crashes at `rel_selects` with a circular view - [7668](https://github.com/MonetDB/MonetDB/issues/7668): MonetDB Mar2025-SP1 crashes at `key_dup()` - [7669](https://github.com/MonetDB/MonetDB/issues/7669): MonetDB Mar2025-SP1 crashes at `AUTHdecypherValue()` - [7670](https://github.com/MonetDB/MonetDB/issues/7670): MonetDB Mar2025-SP1 crashes at `exp_subtype()` - [7672](https://github.com/MonetDB/MonetDB/issues/7672): MonetDB Mar2025-SP1 crashes at `find_name()` - [7673](https://github.com/MonetDB/MonetDB/issues/7673): MonetDB Mar2025-SP1 crashes at `rel_value_exp2()` - [7674](https://github.com/MonetDB/MonetDB/issues/7674): MonetDB Mar2025-SP1 crashes at `rel_schemas()` - [7677](https://github.com/MonetDB/MonetDB/issues/7677): Misleading error message "Could not allocate space" - [7689](https://github.com/MonetDB/MonetDB/issues/7689): Empty SQL result (no rows, no columns) - [7694](https://github.com/MonetDB/MonetDB/issues/7694): Unexpected execution result - [7695](https://github.com/MonetDB/MonetDB/issues/7695): Unexpected execution result - [7696](https://github.com/MonetDB/MonetDB/issues/7696): Unexpected execution result - [7697](https://github.com/MonetDB/MonetDB/issues/7697): Unexpected execution result - [7698](https://github.com/MonetDB/MonetDB/issues/7698): Unexpected Right Join Result - [7699](https://github.com/MonetDB/MonetDB/issues/7699): The OPTIMIZER string value in CREATE USER statement is not checked on validity. - [7701](https://github.com/MonetDB/MonetDB/issues/7701): Add possibility to set MAX_WORKERS to NO MAX_WORKERS in ALTER USER - [7702](https://github.com/MonetDB/MonetDB/issues/7702): Invalid handling of WHERE conditions - [7703](https://github.com/MonetDB/MonetDB/issues/7703): Unexpected Left Join Result - [7705](https://github.com/MonetDB/MonetDB/issues/7705): Unexpected Anti Join Result - [7706](https://github.com/MonetDB/MonetDB/issues/7706): Role (bob) missing - [7707](https://github.com/MonetDB/MonetDB/issues/7707): Unexpected Right Join Result - [7708](https://github.com/MonetDB/MonetDB/issues/7708): Unexpected Join Result - [7709](https://github.com/MonetDB/MonetDB/issues/7709): Monetdb crash when using field fcuntion - [7710](https://github.com/MonetDB/MonetDB/issues/7710): Monetdb crash when using char datatype - [7711](https://github.com/MonetDB/MonetDB/issues/7711): Unexpected Crash - [7712](https://github.com/MonetDB/MonetDB/issues/7712): Unexpected Out of Memory - [7713](https://github.com/MonetDB/MonetDB/issues/7713): Monetdb crashes when using group by - [7714](https://github.com/MonetDB/MonetDB/issues/7714): Monetdb crash when creating table using window function - [7715](https://github.com/MonetDB/MonetDB/issues/7715): Unexpected Anti Join Result - [7716](https://github.com/MonetDB/MonetDB/issues/7716): Unexpected Anti Join Result - [7717](https://github.com/MonetDB/MonetDB/issues/7717): a crash when executing sql - [7719](https://github.com/MonetDB/MonetDB/issues/7719): a crash using select - [7720](https://github.com/MonetDB/MonetDB/issues/7720): MonetDB server (Mar2025-SP2-release) crashes at `stmt_cond` - [7722](https://github.com/MonetDB/MonetDB/issues/7722): MonetDB server (Mar2025-SP2-release) crashes at `rel_with_query` - [7725](https://github.com/MonetDB/MonetDB/issues/7725): MonetDB server (Mar2025-SP2-release) crashes at `bin_find_smallest_column` - [7727](https://github.com/MonetDB/MonetDB/issues/7727): MonetDB server (Mar2025-SP2-release) crashes at `exp_ref` - [7730](https://github.com/MonetDB/MonetDB/issues/7730): Incorrect arithmetic in generate_series with month-based intervals - [7732](https://github.com/MonetDB/MonetDB/issues/7732): Missing column name in select expands to all columns in table - [7733](https://github.com/MonetDB/MonetDB/issues/7733): mserver5 assertion failure when started with -d2 --in-memory - [7734](https://github.com/MonetDB/MonetDB/issues/7734): 'epoch' function doesn't handle fractions with leading zeros correctly - [7735](https://github.com/MonetDB/MonetDB/issues/7735): crash in Monetdb - [7736](https://github.com/MonetDB/MonetDB/issues/7736): crash in MonetDB - [7737](https://github.com/MonetDB/MonetDB/issues/7737): SQL Query Optimizer / Performance Regression with Merge Tables in MonetDB 11.53 - [7739](https://github.com/MonetDB/MonetDB/issues/7739): Unexpected Crash in Left Join - [7741](https://github.com/MonetDB/MonetDB/issues/7741): crash in MonetDB - [7742](https://github.com/MonetDB/MonetDB/issues/7742): crash in MonetDB - [7745](https://github.com/MonetDB/MonetDB/issues/7745): Unexpected Execution Results - [7748](https://github.com/MonetDB/MonetDB/issues/7748): MonetDB server crashes with "unexpected end of file" on UPDATE ... RETURNING with EXISTS subquery - [7751](https://github.com/MonetDB/MonetDB/issues/7751): Continuation of Bug #7737 - [7752](https://github.com/MonetDB/MonetDB/issues/7752): Internal error when executing a simple SQL query: TypeException:user.main[29]:'mat.packIncrement' undefined in: X_39:any := mat.packIncrement(X_37:bat[:lng], X_38:bat[:bte]); - [7753](https://github.com/MonetDB/MonetDB/issues/7753): mserver5.exe crashes when executing a simple query - [7763](https://github.com/MonetDB/MonetDB/issues/7763): MALexception throw in query with EXISTS and NULL

1 0

New Dec2025 stable branch created
by Sjoerd Mullender 10 Nov '25

10 Nov '25

I have created a new stable branch for the next feature release. This branch was created in order to stabilize the code before the feature release. From now on *only* bug fixes may go to this new stable branch. I reserve the right to undo any changes that do not comply with this rule. I also reserve the right to admit changes that are not strictly bug fixes. The name for the branch is Dec2025. So in each of your stable checkout directories you can do hg pull hg update -rDec2025 to update to this new branch. -- Sjoerd Mullender

1 0

Announcement: New Mar2025-SP3 Bugfix release of MonetDB suite
by Sjoerd Mullender 10 Nov '25

10 Nov '25

The MonetDB Foundation is pleased to announce the Mar2025-SP3 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/mar2025/>. As usual, the download location is <https://www.monetdb.org/downloads/>. ### Client Package - Changed the --describe (-D) option of msqldump to really mean (as it says in the manual) do a dump without the data. Before, the output looked like a dump, but could not necessarily be fed back into an mserver5, i.e. it wasn't really a dump without data. ### Bug Fixes - [7662](https://github.com/MonetDB/MonetDB/issues/7662): Privilege Issue: MonetDB Mar2025-SP1 does not check the permission of 'DROP ROLE' and 'DROP USER' statements - [7663](https://github.com/MonetDB/MonetDB/issues/7663): Privilege Issue: the `ALTER USER ... DEFAULT ROLE` statement misses permission checks, which can cause privilege escalation to get other users' privileges - [7664](https://github.com/MonetDB/MonetDB/issues/7664): Privilege Issue: the `SET SESSION AUTHORIZATION` statement will enable any user to alter other users' MAX_WORKERS - [7665](https://github.com/MonetDB/MonetDB/issues/7665): MonetDB dev-builds crashes at `sql_trans_drop_trigger()` - [7666](https://github.com/MonetDB/MonetDB/issues/7666): MonetDB Mar2025-SP1 unexpectly shutdown with crafted `GLOBAL TEMPORARY TABLE` and `ALTER TABLE` statements - [7668](https://github.com/MonetDB/MonetDB/issues/7668): MonetDB Mar2025-SP1 crashes at `key_dup()` - [7669](https://github.com/MonetDB/MonetDB/issues/7669): MonetDB Mar2025-SP1 crashes at `AUTHdecypherValue()` - [7670](https://github.com/MonetDB/MonetDB/issues/7670): MonetDB Mar2025-SP1 crashes at `exp_subtype()` - [7672](https://github.com/MonetDB/MonetDB/issues/7672): MonetDB Mar2025-SP1 crashes at `find_name()` - [7673](https://github.com/MonetDB/MonetDB/issues/7673): MonetDB Mar2025-SP1 crashes at `rel_value_exp2()` - [7674](https://github.com/MonetDB/MonetDB/issues/7674): MonetDB Mar2025-SP1 crashes at `rel_schemas()` - [7689](https://github.com/MonetDB/MonetDB/issues/7689): Empty SQL result (no rows, no columns) - [7699](https://github.com/MonetDB/MonetDB/issues/7699): The OPTIMIZER string value in CREATE USER statement is not checked on validity. - [7702](https://github.com/MonetDB/MonetDB/issues/7702): Invalid handling of WHERE conditions - [7706](https://github.com/MonetDB/MonetDB/issues/7706): Role (bob) missing - [7710](https://github.com/MonetDB/MonetDB/issues/7710): Monetdb crash when using char datatype - [7730](https://github.com/MonetDB/MonetDB/issues/7730): Incorrect arithmetic in generate_series with month-based intervals - [7732](https://github.com/MonetDB/MonetDB/issues/7732): Missing column name in select expands to all columns in table - [7733](https://github.com/MonetDB/MonetDB/issues/7733): mserver5 assertion failure when started with -d2 --in-memory - [7734](https://github.com/MonetDB/MonetDB/issues/7734): 'epoch' function doesn't handle fractions with leading zeros correctly - [7735](https://github.com/MonetDB/MonetDB/issues/7735): crash in Monetdb - [7736](https://github.com/MonetDB/MonetDB/issues/7736): crash in MonetDB - [7737](https://github.com/MonetDB/MonetDB/issues/7737): SQL Query Optimizer / Performance Regression with Merge Tables in MonetDB 11.53 - [7742](https://github.com/MonetDB/MonetDB/issues/7742): crash in MonetDB

1 0

Announcement: New Mar2025-SP2 Bugfix release of MonetDB suite
by Sjoerd Mullender 04 Sep '25

04 Sep '25

The MonetDB Foundation is pleased to announce the Mar2025-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/release-notes/mar2025/>. As usual, the download location is <https://www.monetdb.org/downloads/>. ### - It is now relatively easy to configure the location of the database farm (aka dbfarm) directory when using systemd. Just create an override file for the monetdbd service and add an Environment entry for DBFARM pointing to the new directory. ### Client Package - We now try to figure out the size of the terminal window on Windows. This means that mclient will, by default, format tabular output to not wrap long lines, like is already done on Unix/Linux. ### MonetDB Common - The SIGUSR1 output now displays counts for memory sizes in a human-readable format next to the original byte counts. ### MonetDB5 Server - The PCRE module has been ported to the PCRE2 version of the library. The main difference is in the regexp_replace function which now no longer accepts \ to introduce replacements. Only $ is accepted (it was already accepted before). ### SQL Frontend - Fixed issue #7655, now the segments keep the number of deleted rows. Only search for reuse when deleted rows are available. ### Bug Fixes - [7643](https://github.com/MonetDB/MonetDB/issues/7643): Unable to process field with split_part(). Facing Issue "client4681: exp_bin: CRITICAL: Could not find (null).rate" - [7647](https://github.com/MonetDB/MonetDB/issues/7647): 'mat.packIncrement' undefined - [7648](https://github.com/MonetDB/MonetDB/issues/7648): Unexpected Right Join Assertion Error - [7649](https://github.com/MonetDB/MonetDB/issues/7649): Unexpected Inner Join Crash - [7650](https://github.com/MonetDB/MonetDB/issues/7650): Unexpected Right Join Crash - [7655](https://github.com/MonetDB/MonetDB/issues/7655): slow concurrent insert - [7656](https://github.com/MonetDB/MonetDB/issues/7656): Primary key reported as being a foreign key to itself - [7657](https://github.com/MonetDB/MonetDB/issues/7657): MonetDB Mar2025-SP1 crashes at `sqlparse()` with a crafted MERGE statement - [7659](https://github.com/MonetDB/MonetDB/issues/7659): MonetDB Mar2025-SP1 crashes at `rel_select_add_exp()` with a crafted CREATE TRIGGER statement - [7660](https://github.com/MonetDB/MonetDB/issues/7660): MonetDB Mar2025-SP1 crashes at `subrel_bin()` with a COPY statement - [7661](https://github.com/MonetDB/MonetDB/issues/7661): MonetDB Mar2025-SP1 crashes at `dlist_length()` with a crafted CREATE TRIGGER statement - [7671](https://github.com/MonetDB/MonetDB/issues/7671): MonetDB Mar2025-SP1 crashes at `BLOBlength()` - [7675](https://github.com/MonetDB/MonetDB/issues/7675): Debian service start on new install not getting environment variables from /etc/default/monetdb-sql - [7680](https://github.com/MonetDB/MonetDB/issues/7680): `UNION ALL` doesn't work as expected - [7681](https://github.com/MonetDB/MonetDB/issues/7681): Describe table feature not working correctly - [7682](https://github.com/MonetDB/MonetDB/issues/7682): replacing a login trigger crashes server - [7683](https://github.com/MonetDB/MonetDB/issues/7683): wrong Driver= and Setup= libary paths stored in /etc/odbcinst.ini after installation of MonetDB ODBC driver on ubuntu - [7686](https://github.com/MonetDB/MonetDB/issues/7686): DELETE FROM empty table should always be a no-op - [7688](https://github.com/MonetDB/MonetDB/issues/7688): exists with nulls gives incorrect result - [7692](https://github.com/MonetDB/MonetDB/issues/7692): Illegal argument on range select with equality - [7693](https://github.com/MonetDB/MonetDB/issues/7693): Obscure failure when running mserver5 on an older monetdbd release

1 0

Announcement: New Mar2025-SP1 Bugfix release of MonetDB suite
by Sjoerd Mullender 07 Jul '25

07 Jul '25

The MonetDB Foundation is pleased to announce the Mar2025-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/mar2025/>. As usual, the download location is <https://www.monetdb.org/downloads/>. ### - It is now possible to specify an idle timeout using --set idle_timeout=<seconds> (see mserver5 manual page) which gets triggered if a connection to the server is idle (i.e. does not send any queries to the server) while there is a SQL transaction active. ### Client Package - When connecting to a database, if there are multiple monetdbd servers running, mclient will try them all, and also both UNIX domain sockets and then TCP, in order to find a server that accepts the connection. However, when a server that handles the requested database does exist but refuses the connection for some other reason, mclient would continue searching. This has now been changed. If monetdbd reports an error other than database unknown, mclient will now stop looking and report the error. This is actually a change in the "mapi" library, so any program using the library gets the new behavior. - There is a new option --quiet (or just -q) in mclient. If used, the welcome message that is normally printed in an interactive invocation is suppressed. - There is now a \dm command in the interactive mclient to show information about merge tables. ### SQL Frontend - When a prepared statement is executed, sys.queue now shows the text of the original PREPARE statement along with the EXEC and its arguments. - Add optional parameters omit_unlogged (bool) and omit_table_ids (str) to sys.hot_snapshot(). If omit_unlogged is set to true, the data in UNLOGGED tables is omitted from the snapshot. If omit_table_ids is given, it must be a comma-separated list of table ids as found in sys.tables. The data in each of those tables will be omitted from the snapshot. - Empty BATs are omitted from the snapshot, the restored server will created them if necessary. - Corrected reading decimal type columns from external ODBC data sources via proto_loader('odbc:...'). Those columns were mapped to varchar type columns. Now they will be mapped to decimal type, when possible. ### Merovingian - When mserver5 is started by monetdbd due to an implicit request (application trying to connect to a database), and mserver5 crashes or exits before a connection can be established, monetdbd will stop trying to start the server after a few attempts. When using an explicit command to start the server (using monetdb start), monetdbd will always attempt to start the server. ### Bug Fixes - [7625](https://github.com/MonetDB/MonetDB/issues/7625): Missing entry in sys.table_types table for new LOCAL TEMPORARY VIEW - [7626](https://github.com/MonetDB/MonetDB/issues/7626): crash in window function with constant aggregation - [7627](https://github.com/MonetDB/MonetDB/issues/7627): Increased memory consumption, slowness and crash - [7629](https://github.com/MonetDB/MonetDB/issues/7629): monetdbd causes SELinux denial - [7632](https://github.com/MonetDB/MonetDB/issues/7632): Unexpected Left Join Crash - [7633](https://github.com/MonetDB/MonetDB/issues/7633): Unexpected Out of Memory of Inner Join - [7634](https://github.com/MonetDB/MonetDB/issues/7634): Join with subquery crash - [7636](https://github.com/MonetDB/MonetDB/issues/7636): Unexpected Anti Join Crash - [7638](https://github.com/MonetDB/MonetDB/issues/7638): PREPARE statement increases the memory use of the session even when DEALLOCATEd - [7644](https://github.com/MonetDB/MonetDB/issues/7644): Unexpected anti join crash - [7646](https://github.com/MonetDB/MonetDB/issues/7646): Unexpected Left Join Crash - [7654](https://github.com/MonetDB/MonetDB/issues/7654): Query remote table that targets remote server table not owned by monetdb default user

1 0

Announcement: New Mar2025 Feature release of MonetDB suite
by Sjoerd Mullender 27 Mar '25

27 Mar '25

The MonetDB Foundation is pleased to announce the Mar2025 feature 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/mar2025/>. As usual, the download location is <https://www.monetdb.org/downloads/>. The Mar2025 documentation can be found [here](https://www.monetdb.org/documentation-Mar2025/). ## Mar2025 Feature Release (11.53.3) ### - There is a new shared library called libmutils that contains some utility functions that are used by several programs. - Hot snapshot: allow member files larger than 64 GiB. By member files we mean the files inside the resulting .tar file, not the tar file itself. Huge member files are written using a GNU tar extension to the original tar format, which doesn't support more than 8 GiB. ### Client Package - Support for dumping databases from servers from before Jul2021 (11.41.X) has been removed. ### MonetDB Common - The implementation for the imprints index on numeric columns has been removed. It hasn't been used in years, and when it is enabled, it doesn't really make queries go faster. ### Geom Module - Removed type geometryA (geometry array). It was deprecated in the Jun2023 release (11.47.X) because there was no use for the type. ### MonetDB5 Server - Removed function bat.attach since it wasn't used. - Removed the MAL type "identifier" and supporting functions. There has never been an SQL interface to this type. - Removed the MAL type "color" and supporting functions. There has never been an SQL interface to this type. ### SQL Frontend - Added scalar functions: dayname(d date) and monthname(d date) returns varchar(10). - ranking window functions are now optimized into topn's For the grouped case we added the missing grouped/heap based topn implementation. - Added support for reading external data in a generic way via table returning function: proto_loader(string uri). The uri string value must start with the scheme name, ending with : character. Supported schemes are: monetdb: and odbc:. The monetdb scheme allows you to connect to a remote MonetDB server and retrieve the data of a specific table or view in a specific schema. The uri syntax: monetdb://[<host>[:<port>]]/<database>/<schema>/<table> Example: SELECT * FROM proto_loader('monetdb://127.0.0.1:50000/demo_db/sys/tables'); The odbc scheme allows you to connect to any ODBC data source via an ODBC driver and retrieve the data of a supplied query. The uri syntax: odbc:{{DSN|FILEDSN}=<data source name>|DRIVER=<path_to_driver>}; [<ODBC connection parameters>;]QUERY=<SQL query> For ODBC you normally configure a data source first. This is done using the ODBC administrator (on windows: odbcad32.exe, on linux: odbcinst). Once a data source for a specific ODBC driver has been setup using a unique name, you can reference it as: DSN=my_bigdata; or FILE_DSN=/home/usernm/dsns/my_bigdata.dsn; If you do not want to setup a data source, you can use DRIVER=...; to specify the ODBC driver program to use. However this also means you have to specify all the required connection parameters yourself, such as UID=...;PWD=...;DATABASE=...; etc. The QUERY=<SQL query> part is mandatory and must be specified at the end of the uri string, after the optional ODBC connection parameters. Examples: SELECT * FROM proto_loader( 'odbc:DSN=Postgres;UID=claude;PWD=monet;QUERY=SELECT * FROM customers'); SELECT * FROM proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so; Database=/home/martin/sqlite3/chinook.db;QUERY=SELECT * FROM customers'); Note that the 'odbc:' scheme is experimental and not enabled by default. To enable it, the MonetDB server has to be started with argument: --loadmodule odbc_loader - Extended the constant aggregate optimizer in order to eliminate aggregates with constant arguments whenever possible. - REMOTE TABLES and REPLICA TABLES now fully support the monetdb:// and monetdbs:// URL's introduced in Aug2024. Any mapi:monetdb:// URL's are normalized to the new style. - Add function sa_msettings_create() to allocate an msettings object using the arena allocator. - Unused helper function mapiuri_database() has been removed from rel_remote.h. - Added support for aggregates which order within the group such as quantile and which potentially order within the group such as group_concat. The ordering for such operators in now handled once in the relational plan. For this the create function statements can now have an optional order specification, using the keywords 'ORDERED' and 'WITH ORDER'. - Added support for recursive CTE's. - The SQL parser was cleaned up. This resulted in some keywords being used more strictly. If any of these keywords are to be used as column names, they have to be quoted using double quotes: AS, TABLE, COLUMN, DISTINCT, EXEC, EXECUTE. - Introduce the RETURNING clause for INSERT, UPDATE and DELETE statements. Specifying a RETURNING clause causes the SQL statement to return the modified records which can be queried using SELECT like expressions in the RETURNING clause. Aggregate functions are allowed. This is a common non-standard SQL extension. Examples: INSERT INTO foo values (1,10), (-1,-10) RETURNING i+2*j AS bar ---- 21 -21 UPDATE foo SET i = -i WHERE i >0 RETURNING sum(j), count(j) ---- -60|3 - Introduce division_min_scale SQL environment variable for specifying minimum scale of the division result. The default value is 3. ### Bug Fixes - [7101](https://github.com/MonetDB/MonetDB/issues/7101): Feature request: nextafter() in SQL - [7159](https://github.com/MonetDB/MonetDB/issues/7159): CREATE LOCAL TEMPORARY VIEW - [7331](https://github.com/MonetDB/MonetDB/issues/7331): Support RETURNING clause - [7578](https://github.com/MonetDB/MonetDB/issues/7578): explain result in Mal is truncated in large UDFs and their input bats is not shown - [7609](https://github.com/MonetDB/MonetDB/issues/7609): Upgrade 11.49.11 to 11.51.7 issues - [7611](https://github.com/MonetDB/MonetDB/issues/7611): Not possible to create table with multiple composite UNIQUE NULLS NOT DISTINCT constraints - [7614](https://github.com/MonetDB/MonetDB/issues/7614): Filter function creates a cartesian product when used with a view - [7615](https://github.com/MonetDB/MonetDB/issues/7615): Filter function creates a cartesian product when used with a view (2) - [7616](https://github.com/MonetDB/MonetDB/issues/7616): Filter function disappears - [7618](https://github.com/MonetDB/MonetDB/issues/7618): Tables loose their columns - [7619](https://github.com/MonetDB/MonetDB/issues/7619): Resource leak in prepared statements - [7621](https://github.com/MonetDB/MonetDB/issues/7621): crash on aggregate with case statement - [7622](https://github.com/MonetDB/MonetDB/issues/7622): In PREPARE queries with many parameters, information about parameters is truncated when sent to client. - [7623](https://github.com/MonetDB/MonetDB/issues/7623): Database crashed when using UPDATE xxx SET xxx RETURNING xx

1 0

New Mar2025 stable branch created
by Sjoerd Mullender 10 Feb '25

10 Feb '25

I have created a new stable branch for the next feature release. This branch was created in order to stabilize the code before the feature release. From now on *only* bug fixes may go to this new stable branch. I reserve the right to undo any changes that do not comply with this rule. I also reserve the right to admit changes that are not strictly bug fixes. The name for the branch is Mar2025. So in each of your stable checkout directories you can do hg pull hg update -rMar2025 to update to this new branch. -- Sjoerd Mullender, CTO, MonetDB Solutions sjoerd.mullender(a)monetdbsolutions.com https://www.monetdbsolutions.com/

1 0

Announcement: New Aug2024-SP2 Bugfix release of MonetDB suite
by Sjoerd Mullender 20 Dec '24

20 Dec '24

The MonetDB Foundation is pleased to announce the Aug2024-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/release-notes/aug2024/>. As usual, the download location is <https://www.monetdb.org/downloads/>. ### Bug Fixes - [7112](https://github.com/MonetDB/MonetDB/issues/7112): Need keyboard shortcut to interrupt query execution rather than session - [7205](https://github.com/MonetDB/MonetDB/issues/7205): Unpredictable performance when performing joins over nested queries - [7574](https://github.com/MonetDB/MonetDB/issues/7574): Assertion failure at `rel2bin_select` when using `STARTSWITH` - [7588](https://github.com/MonetDB/MonetDB/issues/7588): incorrect output with single row inputs for var_samp(c) over() - [7589](https://github.com/MonetDB/MonetDB/issues/7589): "SELECT * FROM sessions" crashes monetdb/e - [7593](https://github.com/MonetDB/MonetDB/issues/7593): A value is being returned with unnecessary scientific notation - [7595](https://github.com/MonetDB/MonetDB/issues/7595): SQLTestCase leaks pymonetdb connections - [7597](https://github.com/MonetDB/MonetDB/issues/7597): Upgrade + quick restart causes database inconsistency - [7599](https://github.com/MonetDB/MonetDB/issues/7599): str_to_date fails when combined with SQL CASE clause - [7602](https://github.com/MonetDB/MonetDB/issues/7602): COPY INTO from multiple files causes an assertion error. - [7603](https://github.com/MonetDB/MonetDB/issues/7603): COPY INTO from three or more files crashes the server. - [7604](https://github.com/MonetDB/MonetDB/issues/7604): file_loader() causes server crash when csv file contains too few field separators or contains empty lines - [7607](https://github.com/MonetDB/MonetDB/issues/7607): Adding a column of serial type fails with "Access denied for <user> to schema 'sys'"

1 0

Announcement: New Aug2024-SP1 Bugfix release of MonetDB suite
by Sjoerd Mullender 15 Nov '24

15 Nov '24

The MonetDB Foundation is pleased to announce the Aug2024-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/aug2024/>. As usual, the download location is <https://www.monetdb.org/downloads/>. ### MonetDB5 Server - The server prints out an informative message for the case of a graceful termination. ### SQL Frontend - Improve casting to generic decimal type by choosing a better fit for precision and scale instead of defaulting to 18 and 3, respectively. - When for whatever reason the upgrade code produces an error, we now exit the server. Before the server would limp on with what is basically a broken database. - Improved the violation message of CHECK constraints when violated. It now includes the schema name of the constraint and the check clause. - Increase the buffer size used by hot snapshot from 64kiB to 1MiB, and make it configurable through setting 'hot_snapshot_buffer_size'. It must be a multiple of 512. ### Merovingian - Tweak socket parameters to simulate network activity on client connections. This prevents firewalls from killing connections that seem idle but are actually waiting for a long-running query. Can be controlled with a new 'keepalive' option to monetdbd. ### Bug Fixes - [7281](https://github.com/MonetDB/MonetDB/issues/7281): UDFs defined at compile time in a user schema should not become system functions - [7563](https://github.com/MonetDB/MonetDB/issues/7563): Unexpected result when using `IS DISTINCT FROM` in `VIEW` - [7567](https://github.com/MonetDB/MonetDB/issues/7567): creating remote table from subquery crashes the server - [7569](https://github.com/MonetDB/MonetDB/issues/7569): Column of temporary table changes when another is updated - [7570](https://github.com/MonetDB/MonetDB/issues/7570): BUG in the "str_to_timestamp" function - [7571](https://github.com/MonetDB/MonetDB/issues/7571): Crash when integer overflow in `ORDER BY` - [7572](https://github.com/MonetDB/MonetDB/issues/7572): column max length is not stored as specified and accepted at creation time - [7575](https://github.com/MonetDB/MonetDB/issues/7575): Incorrect BAT properties after mmapped BAT "leaks" to disk with restart. - [7576](https://github.com/MonetDB/MonetDB/issues/7576): unescaping UTF-16 code units goes wrong in json.text - [7577](https://github.com/MonetDB/MonetDB/issues/7577): Crash when using `CHECK` constraint - [7580](https://github.com/MonetDB/MonetDB/issues/7580): statistics optimizer handles date difference incorrectly - [7582](https://github.com/MonetDB/MonetDB/issues/7582): SIGSEGV when creating a SQL function with RETURN CASE WHEN EXISTS (..) - [7583](https://github.com/MonetDB/MonetDB/issues/7583): Query slowdown after deleting rows from large table - [7584](https://github.com/MonetDB/MonetDB/issues/7584): SO_KEEPALIVE should be configured sensibly - [7585](https://github.com/MonetDB/MonetDB/issues/7585): rel2bin_join: Assertion `sql->session->status == -10' failed. - [7587](https://github.com/MonetDB/MonetDB/issues/7587): Line/row numbers get out of sync with COPY INTO .. BEST EFFORT

2 1

help services
by agata.cooper159＠gmail.com 28 Aug '24

28 Aug '24

In today's fast-paced academic environment, students often find themselves overwhelmed with assignments and tight deadlines. When it comes to complex subjects like finance, the pressure can be even greater. This is where professional services like https://writepaper.com/finance-essay-writing-services come in handy. These services offer expert assistance in writing high-quality finance essays, helping students to manage their workload more effectively and achieve better grades.

1 0