Changeset: b4c2936c46f2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b4c2936c46f2 Removed Files: ChangeLog.Mar2025 clients/ChangeLog.Mar2025 clients/mapilib/ChangeLog.Mar2025 clients/odbc/ChangeLog.Mar2025 common/stream/ChangeLog.Mar2025 gdk/ChangeLog.Mar2025 geom/ChangeLog.Mar2025 misc/ChangeLog.Mar2025 monetdb5/ChangeLog.Mar2025 sql/ChangeLog.Mar2025 testing/ChangeLog.Mar2025 tools/merovingian/ChangeLog.Mar2025 Modified Files: ChangeLog-Archive ChangeLog.Dec2025 MonetDB.spec clients/mapiclient/mclient.1 clients/odbc/ChangeLog-Archive clients/odbc/ChangeLog.Dec2025 debian/changelog gdk/ChangeLog-Archive gdk/ChangeLog.Dec2025 monetdb5/ChangeLog-Archive monetdb5/ChangeLog.Dec2025 sql/ChangeLog-Archive sql/ChangeLog.Dec2025 tools/merovingian/client/monetdb.1 tools/merovingian/daemon/monetdbd.1.in tools/mserver/mserver5.1.in Branch: Dec2025 Log Message:
Moved contents of ChangeLog.Mar2025 and ChangeLog.Dec2025 to MonetDB.spec, debian/changelog and ChangeLog-Archive. diffs (truncated from 1326 to 300 lines): diff --git a/ChangeLog-Archive b/ChangeLog-Archive --- a/ChangeLog-Archive +++ b/ChangeLog-Archive @@ -1,6 +1,15 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Tue Sep 16 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- This server is no longer compatible with the MonetDB Stethoscope. + +* Mon Apr 28 2025 Niels Nes <[email protected]> - 11.55.1-20251209 +- 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. + * Wed Aug 13 2025 Sjoerd Mullender <[email protected]> - 11.53.11-20250821 - It is now relatively easy to configure the location of the database farm (aka dbfarm) directory when using systemd. Just create an override diff --git a/ChangeLog.Dec2025 b/ChangeLog.Dec2025 --- a/ChangeLog.Dec2025 +++ b/ChangeLog.Dec2025 @@ -1,12 +1,3 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Tue Sep 16 2025 Sjoerd Mullender <[email protected]> -- This server is no longer compatible with the MonetDB Stethoscope. - -* Mon Apr 28 2025 Niels Nes <[email protected]> -- 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. - diff --git a/ChangeLog.Mar2025 b/ChangeLog.Mar2025 deleted file mode 100644 --- a/ChangeLog.Mar2025 +++ /dev/null @@ -1,3 +0,0 @@ -# ChangeLog file for devel -# This file is updated with Maddlog - diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -95,7 +95,7 @@ Group: Applications/Databases License: MPL-2.0 URL: https://www.monetdb.org/ BugURL: https://github.com/MonetDB/MonetDB/issues -Source: https://www.monetdb.org/downloads/sources/Mar2025-SP3/MonetDB-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Dec2025/MonetDB-%{version}.tar.bz2 # The Fedora packaging document says we need systemd-rpm-macros for # the _unitdir and _tmpfilesdir macros to exist; however on RHEL 7 @@ -1057,6 +1057,195 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd %endif %changelog +* Tue Dec 09 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- Rebuilt. +- GH#7635: Unexpected Inner Join Crash +- GH#7645: Unexpected Internal Error in Inner Join +- GH#7651: Incorrect Anti Join Result +- GH#7652: Incorrect Anti Join Result related to optimization +- GH#7653: Incorrect Inner Join Result +- GH#7667: MonetDB Mar2025-SP1 crashes at `rel_selects` with a circular + view +- GH#7677: Misleading error message "Could not allocate space" +- GH#7694: Unexpected execution result +- GH#7695: Unexpected execution result +- GH#7696: Unexpected execution result +- GH#7697: Unexpected execution result +- GH#7698: Unexpected Right Join Result +- GH#7701: Add possibility to set MAX_WORKERS to NO MAX_WORKERS in ALTER + USER +- GH#7703: Unexpected Left Join Result +- GH#7705: Unexpected Anti Join Result +- GH#7707: Unexpected Right Join Result +- GH#7708: Unexpected Join Result +- GH#7709: Monetdb crash when using field fcuntion +- GH#7711: Unexpected Crash +- GH#7712: Unexpected Out of Memory +- GH#7713: Monetdb crashes when using group by +- GH#7714: Monetdb crash when creating table using window function +- GH#7715: Unexpected Anti Join Result +- GH#7716: Unexpected Anti Join Result +- GH#7717: a crash when executing sql +- GH#7719: a crash using select +- GH#7720: MonetDB server (Mar2025-SP2-release) crashes at `stmt_cond` +- GH#7722: MonetDB server (Mar2025-SP2-release) crashes at `rel_with_query` +- GH#7725: MonetDB server (Mar2025-SP2-release) crashes at + `bin_find_smallest_column` +- GH#7727: MonetDB server (Mar2025-SP2-release) crashes at `exp_ref` +- GH#7739: Unexpected Crash in Left Join +- GH#7741: crash in MonetDB +- GH#7745: Unexpected Execution Results +- GH#7748: MonetDB server crashes with "unexpected end of file" on UPDATE + ... RETURNING with EXISTS subquery +- GH#7751: Continuation of Bug #7737 +- GH#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]); +- GH#7753: mserver5.exe crashes when executing a simple query +- GH#7763: MALexception throw in query with EXISTS and NULL + +* Mon Nov 10 2025 Joeri van Ruth <[email protected]> - 11.55.1-20251209 +- sql: Add functions to_hex(int) and to_hex(bigint). They return the + unsigned hexadecimal string representation of their argument. + +* Wed Nov 5 2025 Joeri van Ruth <[email protected]> - 11.55.1-20251209 +- sql: COPY BINARY has been optimized to be much faster when many string columns + are involved. +- sql: The performance of COPY BINARY of blob column has also been improved. +- sql: 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. +- sql: 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. +- sql: A new example tool 'backrefencode' has been added that can introduce these + back references or remove them again. +- sql: 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. + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- sql: 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. + +* Tue Nov 4 2025 Lucas Pereira <[email protected]> - 11.55.1-20251209 +- sql: 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. +- sql: The PLAN keyword has been removed. + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- monetdb5: We no longer persist querylog results. If you want to keep the data, + make a copy into an SQL table. + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- MonetDB: This server is no longer compatible with the MonetDB Stethoscope. + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- sql: 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. + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- monetdb5: The default_fast and minimal_fast optimizer pipelines have been + removed. The default_pipe and minimal_pipe optimizers now use the + "fast" path always. + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- sql: Removed table returning function sys.optimizer_stats(). + +* Tue Nov 4 2025 Lucas Pereira <[email protected]> - 11.55.1-20251209 +- gdk: 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). + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- sql: 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). + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- monetdb5: 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. + +* Tue Nov 4 2025 Martin van Dinther <[email protected]> - 11.55.1-20251209 +- sql: 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/ +- sql: 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/drop-statement/ +- sql: 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-types/serial-types/ + and + https://www.monetdb.org/documentation/user-guide/sql-manual/data-definition/privileges/ + +* Tue Nov 4 2025 Martin van Dinther <[email protected]> - 11.55.1-20251209 +- odbc: 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. + +* Tue Nov 4 2025 Joeri van Ruth <[email protected]> - 11.55.1-20251209 +- sql: 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. + +* Tue Nov 4 2025 Sjoerd Mullender <[email protected]> - 11.55.1-20251209 +- sql: 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. + +* Tue Nov 4 2025 Niels Nes <[email protected]> - 11.55.1-20251209 +- MonetDB: 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. + * Tue Nov 04 2025 Sjoerd Mullender <[email protected]> - 11.53.15-20251104 - Rebuilt. - GH#7662: Privilege Issue: MonetDB Mar2025-SP1 does not check the @@ -1379,335 +1568,3 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd - sql: Introduce division_min_scale SQL environment variable for specifying minimum scale of the division result. The default value is 3. -* Mon Dec 16 2024 Sjoerd Mullender <[email protected]> - 11.51.7-20241216 -- Rebuilt. -- GH#7112: Need keyboard shortcut to interrupt query execution rather than - session -- GH#7205: Unpredictable performance when performing joins over nested - queries -- GH#7574: Assertion failure at `rel2bin_select` when using `STARTSWITH` -- GH#7588: incorrect output with single row inputs for var_samp(c) over() -- GH#7589: "SELECT * FROM sessions" crashes monetdb/e -- GH#7593: A value is being returned with unnecessary scientific notation -- GH#7595: SQLTestCase leaks pymonetdb connections -- GH#7597: Upgrade + quick restart causes database inconsistency -- GH#7599: str_to_date fails when combined with SQL CASE clause -- GH#7602: COPY INTO from multiple files causes an assertion error. -- GH#7603: COPY INTO from three or more files crashes the server. -- GH#7604: file_loader() causes server crash when csv file contains too - few field separators or contains empty lines -- GH#7607: Adding a column of serial type fails with "Access denied for - <user> to schema 'sys'" - -* Thu Oct 24 2024 Sjoerd Mullender <[email protected]> - 11.51.5-20241024 -- Rebuilt. -- GH#7281: UDFs defined at compile time in a user schema should not become - system functions -- GH#7563: Unexpected result when using `IS DISTINCT FROM` in `VIEW` -- GH#7567: creating remote table from subquery crashes the server -- GH#7569: Column of temporary table changes when another is updated -- GH#7570: BUG in the "str_to_timestamp" function -- GH#7571: Crash when integer overflow in `ORDER BY` -- GH#7572: column max length is not stored as specified and accepted at - creation time -- GH#7575: Incorrect BAT properties after mmapped BAT "leaks" to disk with - restart. -- GH#7576: unescaping UTF-16 code units goes wrong in json.text -- GH#7577: Crash when using `CHECK` constraint -- GH#7580: statistics optimizer handles date difference incorrectly -- GH#7582: SIGSEGV when creating a SQL function with RETURN CASE WHEN - EXISTS (..) -- GH#7583: Query slowdown after deleting rows from large table -- GH#7584: SO_KEEPALIVE should be configured sensibly -- GH#7585: rel2bin_join: Assertion `sql->session->status == -10' failed. -- GH#7587: Line/row numbers get out of sync with COPY INTO .. BEST EFFORT - -* Mon Oct 21 2024 Lucas Pereira <[email protected]> - 11.51.5-20241024 -- sql: Improve casting to generic decimal type by choosing a better fit for _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
