Changeset: 11a26808ab1b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/11a26808ab1b Removed Files: ChangeLog.Aug2024 clients/ChangeLog.Aug2024 clients/mapilib/ChangeLog.Aug2024 clients/odbc/ChangeLog.Aug2024 common/stream/ChangeLog.Aug2024 gdk/ChangeLog.Aug2024 geom/ChangeLog.Aug2024 misc/ChangeLog.Aug2024 monetdb5/ChangeLog.Aug2024 sql/ChangeLog.Aug2024 testing/ChangeLog.Aug2024 tools/merovingian/ChangeLog.Aug2024 Modified Files: ChangeLog-Archive ChangeLog.Mar2025 MonetDB.spec clients/ChangeLog-Archive clients/ChangeLog.Mar2025 clients/mapiclient/mclient.1 debian/changelog gdk/ChangeLog-Archive gdk/ChangeLog.Mar2025 geom/ChangeLog-Archive geom/ChangeLog.Mar2025 monetdb5/ChangeLog-Archive monetdb5/ChangeLog.Mar2025 sql/ChangeLog-Archive sql/ChangeLog.Mar2025 tools/merovingian/client/monetdb.1 tools/merovingian/daemon/monetdbd.1.in tools/mserver/mserver5.1.in Branch: Mar2025 Log Message:
Moved contents of ChangeLog.Aug2024 and ChangeLog.Mar2025 to MonetDB.spec, debian/changelog and ChangeLog-Archive. diffs (truncated from 1146 to 300 lines): diff --git a/ChangeLog-Archive b/ChangeLog-Archive --- a/ChangeLog-Archive +++ b/ChangeLog-Archive @@ -1,6 +1,16 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Tue Mar 11 2025 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- There is a new shared library called libmutils that contains some + utility functions that are used by several programs. + +* Mon Sep 16 2024 Joeri van Ruth <[email protected]> - 11.53.1-20250317 +- 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. + * Tue Aug 6 2024 Sjoerd Mullender <[email protected]> - 11.51.1-20240812 - The CMake configuration files for building extensions have now been included in the various MonetDB development RPMs and debs. diff --git a/ChangeLog.Aug2024 b/ChangeLog.Aug2024 deleted file mode 100644 --- a/ChangeLog.Aug2024 +++ /dev/null @@ -1,3 +0,0 @@ -# ChangeLog file for devel -# This file is updated with Maddlog - diff --git a/ChangeLog.Mar2025 b/ChangeLog.Mar2025 --- a/ChangeLog.Mar2025 +++ b/ChangeLog.Mar2025 @@ -1,13 +1,3 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Tue Mar 11 2025 Sjoerd Mullender <[email protected]> -- There is a new shared library called libmutils that contains some - utility functions that are used by several programs. - -* Mon Sep 16 2024 Joeri van Ruth <[email protected]> -- 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. - 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/Aug2024-SP2/MonetDB-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Mar2025/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 @@ -1056,6 +1056,142 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd %endif %changelog +* Mon Mar 17 2025 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- Rebuilt. +- GH#7101: Feature request: nextafter() in SQL +- GH#7159: CREATE LOCAL TEMPORARY VIEW +- GH#7331: Support RETURNING clause +- GH#7578: explain result in Mal is truncated in large UDFs and their + input bats is not shown +- GH#7609: Upgrade 11.49.11 to 11.51.7 issues +- GH#7611: Not possible to create table with multiple composite UNIQUE + NULLS NOT DISTINCT constraints +- GH#7614: Filter function creates a cartesian product when used with a + view +- GH#7615: Filter function creates a cartesian product when used with a + view (2) +- GH#7616: Filter function disappears +- GH#7618: Tables loose their columns +- GH#7619: Resource leak in prepared statements +- GH#7621: crash on aggregate with case statement + +* Tue Mar 11 2025 Niels Nes <[email protected]> - 11.53.1-20250317 +- sql: ranking window functions are now optimized into topn's + For the grouped case we added the missing grouped/heap based topn + implementation. + +* Tue Mar 11 2025 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- MonetDB: There is a new shared library called libmutils that contains some + utility functions that are used by several programs. + +* Wed Mar 5 2025 Martin van Dinther <[email protected]> - 11.53.1-20250317 +- sql: 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 + +* Tue Feb 18 2025 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- clients: Support for dumping databases from servers from before Jul2021 (11.41.X) + has been removed. + +* Mon Feb 10 2025 stefanos mavros <[email protected]> - 11.53.1-20250317 +- sql: Extended the constant aggregate optimizer in order to eliminate + aggregates with constant arguments whenever possible. + +* Wed Jan 29 2025 Joeri van Ruth <[email protected]> - 11.53.1-20250317 +- sql: 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. +- sql: Add function sa_msettings_create() to allocate an msettings object + using the arena allocator. +- sql: Unused helper function mapiuri_database() has been removed from + rel_remote.h. + +* Mon Jan 13 2025 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- monetdb5: Removed function bat.attach since it wasn't used. + +* Fri Dec 20 2024 Niels Nes <[email protected]> - 11.53.1-20250317 +- sql: 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'. + +* Fri Dec 20 2024 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- sql: Added support for recursive CTE's. +- sql: 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. + +* Mon Dec 16 2024 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- geom: Removed type geometryA (geometry array). It was deprecated in the + Jun2023 release (11.47.X) because there was no use for the type. + +* Mon Dec 16 2024 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- monetdb5: Removed the MAL type "identifier" and supporting functions. There has + never been an SQL interface to this type. +- monetdb5: Removed the MAL type "color" and supporting functions. There has + never been an SQL interface to this type. + +* Mon Dec 16 2024 Yunus Koning <[email protected]> - 11.53.1-20250317 +- sql: 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 + +* Mon Dec 16 2024 Joeri van Ruth <[email protected]> - 11.53.1-20250317 +- MonetDB: 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. + +* Mon Dec 16 2024 Sjoerd Mullender <[email protected]> - 11.53.1-20250317 +- gdk: 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. + +* Mon Dec 16 2024 Lucas Pereira <[email protected]> - 11.53.1-20250317 +- 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 @@ -1388,316 +1524,3 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd - sql: Add a DECIMAL AS clause to COPY INTO that configures the decimal separator and thousands separator for decimals, temporal types and floats. -* Sat Jun 29 2024 Sjoerd Mullender <[email protected]> - 11.49.11-20240629 -- Rebuilt. -- GH#7509: MonetDB Dec2023-SP2 crashes at `sql_init_subtype` -- GH#7511: MonetDB Dec2023-SP2 crashes with the `PASSWORD_HASH` function -- GH#7512: MonetDB Dec2023-SP2 crashes with the - `GET_MERGE_TABLE_PARTITION_EXPRESSIONS` function -- GH#7513: MonetDB Dec2023-SP2 crashes with the `GETHOST` function -- GH#7518: mserver reports errors when starting if geom module is enabled - but database was created without -- GH#7526: deadlock, causing new connections to hang indefinitely -- GH#7531: loading more than 2147483647 rows gives issue. -- GH#7536: Truncated file when dumping a table from mclient into a gzipped - file -- GH#7537: MonetDB crashes with a SIGSEGV due to a null pointer - dereference when using prepared statements -- GH#7541: Unexpected result when using `LEVENSHTEIN` -- GH#7546: monetdbd leaks file descriptors when starting mserver5. - -* Sat Jun 29 2024 Sjoerd Mullender <[email protected]> - 11.49.11-20240629 -- monetdb5: The mserver5 program has a new option: --without-geom. If the server - was compiled with geom support (or the geom module was installed in a - binary distribution), this option allows the server to start without - the geom module, so that it can proceed with a database that was - created without geom. - -* Wed May 15 2024 Sjoerd Mullender <[email protected]> - 11.49.11-20240629 -- sql: When sys.persist_unlogged is called for a table, it may return that - zero rows were persisted. If this is because the call was done too - early, i.e. the table was recently created and the write-ahead log - where this was logged has not been processed yet, the call will - request an immediate write-ahead log rotation. This means that the - WAL will be processed as soon as possible and a new call to - sys.persist_unlogged soon after will likely return a positive result. - -* Thu May 02 2024 Sjoerd Mullender <[email protected]> - 11.49.9-20240502 -- Rebuilt. -- GH#7422: Aggregate functions with variadic arguments -- GH#7472: MonetDB server crashes in `tail_type` -- GH#7473: MonetDB server crashes in `SQLunionfunc` -- GH#7478: MonetDB server crashes in `exp_equal` -- GH#7496: Query on view fails to produce a resultset. Assertion triggered - in rel2bin_select. -- GH#7499: create schema + set schema inside a transaction that is rolled - back causes the connection to be aborted -- GH#7501: files remain in backup causing problems at restart -- GH#7503: MonetDB server crashes using `WHEN MATCHED THEN UPDATE` -- GH#7504: possible deadlock when a bat is made persistent when it is also - getting unloaded -- GH#7506: MonetDB Dec2023-SP2 crashes at `rel_value_exp2` -- GH#7507: BBPextend: ERROR: trying to extend BAT pool beyond the limit - (163840000) -- GH#7508: MonetDB Dec2023-SP2 crashes at `exp_ref` - -* Tue Apr 09 2024 Sjoerd Mullender <[email protected]> - 11.49.7-20240409 -- Rebuilt. -- GH#7469: Crash when using `CONTAINS` -- GH#7479: MonetDB server crashes in `exp_ref` -- GH#7490: commonTerms optimizer no longer works -- GH#7495: Crash when simultaneously querying and updating a string column. - -* Thu Mar 28 2024 Sjoerd Mullender <[email protected]> - 11.49.7-20240409 -- gdk: Threads have their own list of free bats. The list was not returned - to the system when a thread exited, meaning that the free bats that - were in the list would not be reused by any thread. This has been - fixed. - -* Tue Mar 19 2024 Sjoerd Mullender <[email protected]> - 11.49.7-20240409 -- monetdb5: Fixed interaction between mserver5 and remote mserver5 when only one - of the two has 128 bit integer support. - -* Tue Mar 19 2024 Sjoerd Mullender <[email protected]> - 11.49.7-20240409 -- sql: Fixed issue where equal column aliases were created. When those - aliases were parsed on the remote side it could give crashes. - -* Mon Mar 18 2024 Sjoerd Mullender <[email protected]> - 11.49.7-20240409 -- gdk: Fixed a couple of deadlock situations, one actually observed, one - never observed. - -* Tue Mar 12 2024 Sjoerd Mullender <[email protected]> - 11.49.5-20240312 -- Rebuilt. -- GH#7390: Some MonetDB Server crashes found -- GH#7465: Unexpected result when using `NULL` in `BETWEEN` - -* Fri Mar 8 2024 Sjoerd Mullender <[email protected]> - 11.49.5-20240312 -- gdk: 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. - -* Thu Mar 7 2024 Lucas Pereira <[email protected]> - 11.49.5-20240312 -- sql: performance improvement of 'startswith' and 'endswith' filter functions - for join operators - -* Wed Mar 6 2024 Sjoerd Mullender <[email protected]> - 11.49.5-20240312 -- clients: Fixed an issue where mclient wouldn't exit if the server it had - connected to exited for whatever reason while the client was waiting _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
