Changeset: 18362b41ae58 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/18362b41ae58 Branch: strimps_v3 Log Message:
Merge with default branch. diffs (truncated from 13323 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -830,3 +830,4 @@ 9a694c41042503a22d6c92aeab5bc4ca1912b62e e1e9e22bf3d734dc50b56151c657a57c18f56561 Aug2024_root cde7d8f7c99540a8c95856df052a9f123b0c1643 Dec2023_11 cde7d8f7c99540a8c95856df052a9f123b0c1643 Dec2023_SP4_release +ae474f7fda0a3f2ebefc6c0b2cd969ef0854fad1 Aug2024_1 diff --git a/ChangeLog-Archive b/ChangeLog-Archive --- a/ChangeLog-Archive +++ b/ChangeLog-Archive @@ -1,6 +1,24 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Tue Aug 6 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- The CMake configuration files for building extensions have now been + included in the various MonetDB development RPMs and debs. + +* Tue Jun 25 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- Removed upgrade code for versions before Jul2021. + +* Wed May 8 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- The shared library (.dll aka .so files) now have the version number + as part of the name. This should allow the building of compatibility + versions that can be installed in parallel to the latest version. +- Some of the Debian/Ubuntu packages have been renamed. The old monetdb5 + names have been changed to plain monetdb, and libmonetdb5-server-* + packages have been renamed monetdb-*. +- The names of some of the provided RPM files have been changed. + References to the old MonetDB5 name have been removed. All packages + are now just MonetDB. + * Thu Jan 11 2024 Sjoerd Mullender <sjo...@acm.org> - 11.49.3-20240304 - The copyright for the MonetDB software has been transferred to the newly established MonetDB Foundation, a not-for-profit foundation with the diff --git a/ChangeLog.Aug2024 b/ChangeLog.Aug2024 --- a/ChangeLog.Aug2024 +++ b/ChangeLog.Aug2024 @@ -1,17 +1,3 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Tue Jun 25 2024 Sjoerd Mullender <sjo...@acm.org> -- Removed upgrade code for versions before Jul2021. - -* Wed May 8 2024 Sjoerd Mullender <sjo...@acm.org> -- The shared library (.dll aka .so files) now have the version number - as part of the name. This should allow the building of compatibility - versions that can be installed in parallel to the latest version. -- Some of the Debian/Ubuntu packages have been renamed. The old monetdb5 - names have been changed to plain monetdb, and libmonetdb5-server-* - packages have been renamed monetdb-*. -- The names of some of the provided RPM files have been changed. - References to the old MonetDB5 name have been removed. All packages - are now just MonetDB. - diff --git a/ChangeLog.Dec2023 b/ChangeLog.Dec2023 deleted file mode 100644 --- a/ChangeLog.Dec2023 +++ /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/Dec2023-SP4/MonetDB-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Aug2024/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 @@ -211,6 +211,12 @@ functionality of MonetDB. %{_includedir}/monetdb/monet*.h %{_libdir}/libbat*.so %{_libdir}/pkgconfig/monetdb-gdk.pc +%dir %{_datadir}/monetdb +%dir %{_datadir}/monetdb/cmake +%{_datadir}/monetdb/cmake/gdkTargets*.cmake +%{_datadir}/monetdb/cmake/matomicTargets.cmake +%{_datadir}/monetdb/cmake/mstringTargets.cmake +%{_datadir}/monetdb/cmake/monetdb_config_headerTargets.cmake %endif %package stream @@ -258,6 +264,7 @@ library. %{_includedir}/monetdb/stream.h %{_includedir}/monetdb/stream_socket.h %{_libdir}/pkgconfig/monetdb-stream.pc +%{_datadir}/monetdb/cmake/streamTargets*.cmake %endif %package client-lib @@ -338,6 +345,7 @@ This package contains the files needed t %{_includedir}/monetdb/mapi*.h %{_includedir}/monetdb/msettings.h %{_libdir}/pkgconfig/monetdb-mapi.pc +%{_datadir}/monetdb/cmake/mapiTargets*.cmake %endif %if %{without compat} @@ -644,6 +652,7 @@ used from the MAL level. %{_includedir}/monetdb/mel.h %{_libdir}/libmonetdb5*.so %{_libdir}/pkgconfig/monetdb5.pc +%{_datadir}/monetdb/cmake/monetdb5Targets*.cmake %endif %package SQL @@ -701,6 +710,10 @@ Summary: MonetDB SQL server modules deve Group: Applications/Databases Requires: %{name}-SQL%{?_isa} = %{version}-%{release} Requires: %{name}-server-devel%{?_isa} = %{version}-%{release} +Requires: %{name}-embedded-devel%{?_isa} = %{version}-%{release} +Obsoletes: %{name}-SQL-server5-devel < 11.50.0 +Provides: %{name}-SQL-server5-devel = %{version}-%{release} +Provides: %{name}-SQL-server5-devel%{?_isa} = %{version}-%{release} %description SQL-devel MonetDB is a database management system that is developed from a @@ -716,6 +729,8 @@ This package contains files needed to de %{_includedir}/monetdb/rel_*.h %{_includedir}/monetdb/sql*.h %{_includedir}/monetdb/store_*.h +%{_datadir}/monetdb/cmake/MonetDBConfig*.cmake +%{_datadir}/monetdb/cmake/sqlTargets*.cmake %endif %if %{without compat} @@ -759,6 +774,7 @@ program that uses MonetDB as an embeddab %{_libdir}/libmonetdbe.so %{_includedir}/monetdb/monetdbe.h %{_libdir}/pkgconfig/monetdbe.pc +%{_datadir}/monetdb/cmake/monetdbeTargets*.cmake %package embedded-tests Summary: MonetDBe tests package @@ -938,7 +954,6 @@ rm -f "${RPM_BUILD_ROOT}"%{_libdir}/mone rm -f "${RPM_BUILD_ROOT}"%{_libdir}/monetdb5*/lib_microbenchmark*.so rm -f "${RPM_BUILD_ROOT}"%{_libdir}/monetdb5*/lib_udf*.so rm -f "${RPM_BUILD_ROOT}"%{_bindir}/monetdb_mtest.sh -rm -rf "${RPM_BUILD_ROOT}"%{_datadir}/monetdb # /cmake if [ -x /usr/sbin/hardlink ]; then /usr/sbin/hardlink -cv "${RPM_BUILD_ROOT}"%{_datadir}/selinux @@ -974,6 +989,262 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd %endif %changelog +* Mon Aug 12 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- Rebuilt. +- GH#7045: A value filtered in a subquery finds its way to a later filter + in the outer query +- GH#7097: Add an 'ANY' or 'ARBITRARY' aggregate function +- GH#7245: monetdbe silently importing 0 rows, at random +- GH#7265: COPY INTO Not Reading in all records of fixed width delimited + file +- GH#7272: Missed rewrite to bulk operators in simple SQL UDF +- GH#7312: Test Button for ODBC Driver +- GH#7332: Support IS [NOT] DISTINCT FROM predicate +- GH#7353: INTERVAL SECOND columns become incorrect when an INTERVAL HOUR + column is present +- GH#7367: Libraries linked more than once? +- GH#7370: timestamp_to_str function not aware of timezone +- GH#7374: Different date and time returns +- GH#7392: Evaluate Profile-Guided Optimization +- GH#7424: Performance issue in select-joins +- GH#7459: Crash when using `CONTAINS` in `ORDER BY` clause +- GH#7460: Crash when using `CAST` and `BETWEEN AND` +- GH#7463: Unexpected result when using `CONTAINS` and type casting +- GH#7466: Crash when `INNER JOIN` with `CONTAINS` +- GH#7467: Conversion TIMESTAMPTZ to TIME does not take session TZ into + account +- GH#7474: MonetDB server crashes in `VLTgenerator_table_` +- GH#7475: MonetDB server crashes in `__nss_database_lookup` +- GH#7476: MonetDB server crashes in `subrel_bin` +- GH#7477: MonetDB server crashes in `atom_cmp` +- GH#7480: MonetDB server crashes in `get_rel_count` +- GH#7481: MonetDB server crashes in `mvc_row_result_wrap` +- GH#7482: MonetDB server crashes in `bin_find_smallest_column` +- GH#7483: MonetDB server crashes in `rel_get_statistics_` +- GH#7484: MonetDB server crashes in `rel_optimize_projections_` +- GH#7485: MonetDB server crashes in `exp_setalias` +- GH#7486: MonetDB server crashes in `ALGgroupby` +- GH#7488: MonetDB server crashes in `strCmp` +- GH#7497: Multi-column IN clause with value list produces syntax error +- GH#7500: request: ANALYZE statement should be allowed to be used in the + body of a procedure or function or trigger. +- GH#7514: Nonexistent window function raises + `ParseException:SQLparser:42000!Query too complex: running out of stack + space` +- GH#7517: UNLOGGED tables don't get cleaned up properly when DROPped. +- GH#7521: Unexpected result when using `IS DISTINCT FROM` +- GH#7522: Crash when creating view with `HAVING` +- GH#7523: Assertion failure when using `CONTAINS` +- GH#7524: Unexpected error when using `NATURAL RIGHT JOIN` +- GH#7525: Related to bug #7422 (variadic arguments in aggregate UDFs) +- GH#7527: Unexpected result when using `IS DISTINCT FROM` with `RIGHT + JOIN` +- GH#7528: Assertion failure when using `JAROWINKLER` in `ORDER BY` clause +- GH#7529: Finding minimum value in reverse sorted column with NULL values + at the end gives wrong result. +- GH#7530: Assertion failure when using `JAROWINKLER` with empty string +- GH#7533: DROP of a schema with CASCADE option drops tables, but bats are + not removed. +- GH#7534: Unexpected result when using `IS DISTINCT FROM` with `AND` +- GH#7535: Assertion failure when using `GROUP BY` when `CREATE VIEW` +- GH#7538: BUG with decimal values +- GH#7539: Crash when using `IS DISTINCT FROM` with `SIN` +- GH#7540: Assertion failure when using `STARTSWITH` +- GH#7542: Nested query triggers an assert +- GH#7543: Unexpected result when using `IS DISTINCT FROM` with constants +- GH#7544: Unexpected result when using `STARTSWITH` +- GH#7545: Crash when creating view with `GROUP BY` +- GH#7547: drop login trigger causes server crash +- GH#7550: non-admin user can no longer query sys.statistics or + information_schema.tables +- GH#7552: Unexpected result when using `NULL` constant in comparison +- GH#7553: Assertion failure when using `INNER JOIN` on `STARTSWITH` +- GH#7554: Unexpected result when using range comparison with `NULL` +- GH#7555: Unexpected result when casting integer to boolean in comparison +- GH#7556: Assertion failure when using `STARTSWITH` with view + +* Wed Aug 7 2024 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.51.1-20240812 +- odbc: Extended ODBC Data Source Setup program on Windows with fields to specify + optional Client Information such as Application Name and Client Remark. + +* Tue Aug 6 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- MonetDB: The CMake configuration files for building extensions have now been + included in the various MonetDB development RPMs and debs. + +* Thu Aug 1 2024 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.51.1-20240812 +- odbc: Extended ODBC Data Source Setup program on Windows with fields to specify + new TLS Connection settings. +- odbc: Extended ODBC Data Source Setup program on Windows with a Test-button + to quickly test connectivity to a MonetDB server. + +* Tue Jul 16 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- sql: The "phash" column in the sys.storage() table now indicates whether a + hash exists. If the hash is not loaded but there is a hash available + on disk, the phash value is "true", but the "hashes" value is 0. + +* Thu Jul 11 2024 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.51.1-20240812 +- sql: Added execution privilege on all sys.generate_series(first, limit) + and sys.generate_series(first, limit, stepsize) functions to public, + so all users can now call these table producing generator functions. + +* Sat Jun 29 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- MonetDB: Removed upgrade code for versions before Jul2021. + +* Sat Jun 29 2024 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> - 11.51.1-20240812 +- mapilib: Add new columns to sys.sessions. Column 'language' is usually 'sql'. + Column 'peer' is the network address of the client (something like + '[::1]:46558' or '<UNIX SOCKET>'). Columns 'hostname', 'application', + 'client', 'clientpid' and 'remark' can be set by the client. + Libmapi/mclient, pymonetdb and monetdb-java have been modified to fill + in sensible default values. + +* Sat Jun 29 2024 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> - 11.51.1-20240812 +- sql: Extend CREATE USER MAX_MEMORY and ALTER USER MAX_MEMORY to accept + strings of the form '10MiB', '10G', etc. + +* Sat Jun 29 2024 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> - 11.51.1-20240812 +- sql: Extended view sys.sessions and function sys.sessions() with new columns: + language, peer, hostname, application, client, clientpid and remark. +- sql: All users now have SELECT privilege on view sys.sessions, but non-admin + users only see their own sessions. +- sql: Added procedure sys.setclientinfo(property string, value string) + to allow the client application to set a specific client info property. +- sql: Added system table sys.clientinfo_properties that lists the supported + client info properties and their associated column name in sys.sessions view. + It contains property names: ClientHostname, ApplicationName, + ClientLibrary, ClientPid and ClientRemark. + +* Sat Jun 29 2024 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> - 11.51.1-20240812 +- odbc: ODBC now supports TLS. It can be configured through the following + DSN- or Connection String attributes (canonical name / user friendly name): + TLS / Encrypt = ON/OFF + CERT / Server Certificate = PATH + CERTHASH / Server Certificate Hash = sha256:HEXDIGITS + CLIENTKEY / Client Key = PATH + CLIENTCERT / Client Certificate = PATH +- odbc: Several more connection properties have been made configurable: + SCHEMA / Schema = NAME + TIMEZONE / Time Zone = Minutes East Of UTC + REPLYSIZE / Reply Size = NUMBER + LOGFILE / Log File = PATH + LOGINTIMEOUT / Login Timeout = MILLISECONDS + CONNECTIONTIMEOUT / Connection Timeout = MILLISECONDS + AUTOCOMMIT / Autocommit = ON/OFF + SOCK / Unix Socket = PATH (unix only) +- odbc: SQLBrowseConnect() adds On/Off suggestions to boolean settings + and prioritizes the DATABASE attribute if it notices monetdbd + requires one. Apart from that only UID/User and PWD/Password + are required, all others have sensible defaults. _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
