Changeset: 9556ac2e8241 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/9556ac2e8241 Modified Files: clients/Tests/exports.stable.out gdk/gdk.h monetdb5/extras/rapi/rapi.c monetdb5/mal/mal_instruction.c monetdb5/optimizer/opt_pushselect.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql_scenario.c sql/server/rel_basetable.c sql/server/sql_parser.y sql/storage/bat/bat_storage.c sql/storage/store.c sql/test/Tests/sessioncontrol.test Branch: resource_management Log Message:
merge with default diffs (truncated from 22926 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -830,3 +830,6 @@ 9a694c41042503a22d6c92aeab5bc4ca1912b62e e1e9e22bf3d734dc50b56151c657a57c18f56561 Aug2024_root cde7d8f7c99540a8c95856df052a9f123b0c1643 Dec2023_11 cde7d8f7c99540a8c95856df052a9f123b0c1643 Dec2023_SP4_release +ae474f7fda0a3f2ebefc6c0b2cd969ef0854fad1 Aug2024_1 +dce400b68239412b1835fb28bd183bf50f5e8692 Aug2024_3 +dce400b68239412b1835fb28bd183bf50f5e8692 Aug2024_release 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,7 +0,0 @@ -# ChangeLog file for devel -# This file is updated with Maddlog - -* Tue Aug 6 2024 Sjoerd Mullender <sjo...@acm.org> -- The CMake configuration files for building extensions have now been - included in the various MonetDB development RPMs and debs. - 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 @@ -711,6 +711,9 @@ 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 @@ -986,6 +989,267 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd %endif %changelog +* Mon Aug 19 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.3-20240819 +- Rebuilt. +- GH#7562: Assertion failure when comparing `INTERVAL` value +- GH#7566: After a while, all new sessions (connections) may get refused + +* 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. + +* Sat Jun 29 2024 Niels Nes <ni...@cwi.nl> - 11.51.1-20240812 +- sql: Extended sys.generate_series() to generate dates. Added 2 new functions: + sys.generate_series(first date, "limit" date, stepsize interval month) and + sys.generate_series(first date, "limit" date, stepsize interval day). + +* Sat Jun 29 2024 Niels Nes <ni...@cwi.nl> - 11.51.1-20240812 +- sql: Added support for select exp, count(*) group by 1 order by 1; + ie. using numeric references in group by clause. +- sql: Added support for GROUP BY ALL. This finds all expressions from the + selections which aren't aggregations and groups on those. + At least one aggregation must be specified. + The ALL keyword can also be replaced by '*', so: GROUP BY *. +- sql: Added support for ORDER BY ALL. This orders on all columns of the selection. + The ALL keyword can also be replaced by '*', so: ORDER BY *. + +* Sat Jun 29 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- MonetDB: 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. +- MonetDB: 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-*. +- 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. + +* Sat Jun 29 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- gdk: Various changes were made having to do with things like case-insensitive + comparisons and converting to upper or lower case. Case insensitive + comparison (i.e. the ILIKE operator) uses case folding which is similar + to converting to lower case, but changes more characters, also sometimes + to multiple characters (e.g. German sharp s (ß) compares equal to SS). + +* Sat Jun 29 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 +- stream: ICONV support has been removed from the stream library. The server + itself only needs UTF-8 support. The client (mclient) does have + iconv support. + +* Sat Jun 29 2024 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.51.1-20240812 +- sql: Removed the obsolete ANALYZE statement syntax options: SAMPLE nn and + MINMAX. Both options have been ignored since release Jan2022. Now they + are no longer accepted in the ANALYZE statement. +- sql: The ANALYZE statement can now be used in procedures, functions and triggers. + +* Sat Jun 29 2024 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.51.1-20240812 +- sql: Make schema renaming more permissive. A schema can be renamed if it + does not contain objects that are a dependency for objects outside + the schema. If such dependencies exist, they are shown in the + table sys.dependencies. + +* Sat Jun 29 2024 Sjoerd Mullender <sjo...@acm.org> - 11.51.1-20240812 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
