Changeset: 4237b6ee7478 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4237b6ee7478 Removed Files: debian/libmonetdb25.install Modified Files: .hgtags MonetDB.spec debian/changelog debian/control debian/libmonetdb26.install gdk/CMakeLists.txt gdk/gdk.h gdk/gdk_align.c gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_bbp.c gdk/gdk_private.h gdk/gdk_storage.c geom/monetdb5/geomBulk.c misc/packages/deb/changelog misc/packages/rpm/changelog monetdb5/optimizer/opt_mitosis.c monetdb5/optimizer/opt_prelude.c monetdb5/optimizer/opt_prelude.h sql/backends/monet5/sql_upgrades.c sql/backends/monet5/vaults/shp/shp.c sql/storage/objectset.c Branch: geo-update Log Message:
Merge with default. diffs (truncated from 242552 to 300 lines): diff --git a/.bumpversion.cfg b/.bumpversion.cfg --- a/.bumpversion.cfg +++ b/.bumpversion.cfg @@ -1,5 +1,5 @@ [bumpversion] -current_version = 11.44.0 +current_version = 11.46.0 commit = False tag = False diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -769,3 +769,19 @@ 1252291e5c0ddc91ccb16d612d04e34e6a7d3bc3 1252291e5c0ddc91ccb16d612d04e34e6a7d3bc3 Jun2020_SP2_release 59de1ee118d4eccc072c0cf3938f90635a7db311 Jan2022_15 59de1ee118d4eccc072c0cf3938f90635a7db311 Jan2022_SP3_release +38ba6e40ba9148c762fe4a4b40f4937f86e516b6 Jul2021_25 +38ba6e40ba9148c762fe4a4b40f4937f86e516b6 Jul2021_SP7_release +470e524a786ee0e94c7901ec98d95ac351a0e472 Sep2022_root +9785fa2a471fe32495e07479edf110335ddaa750 Jan2022_17 +26ffeb5af5240c807a6583fd6eb4ee2c9cd210d2 Jan2022_19 +3191fee438036ac0da1e6f31481b9681399123b5 Jan2022_21 +3191fee438036ac0da1e6f31481b9681399123b5 Jan2022_SP4_release +bdd04053973daa8a786a30e07b2bf1bd8aa6ebf1 Jul2021_27 +bdd04053973daa8a786a30e07b2bf1bd8aa6ebf1 Jul2021_SP8_release +688ff09b2edc3d637f658f3e7ef3d5f07e3e8f9c Sep2022_1 +ea797696d5e8d8d550f21f09b98d3bcade1d001d Sep2022_3 +68c0e35095ad6a58766c6c1e77229d73148433e2 Sep2022_5 +47675351fec22d5d5dc81eec03dfa08f505afc99 Sep2022_7 +47675351fec22d5d5dc81eec03dfa08f505afc99 Sep2022_release +44e45c9a451f6afd933773094ec25723f713d3be Jan2022_23 +44e45c9a451f6afd933773094ec25723f713d3be Jan2022_SP5_release diff --git a/ChangeLog.Jan2022 b/ChangeLog.Jan2022 deleted file mode 100644 --- a/ChangeLog.Jan2022 +++ /dev/null @@ -1,3 +0,0 @@ -# ChangeLog file for devel -# This file is updated with Maddlog - diff --git a/ChangeLog b/ChangeLog.Sep2022 copy from ChangeLog copy to ChangeLog.Sep2022 diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -1,5 +1,11 @@ +# This Source Code Form is subject to the terms of the Mozilla Public +# License, v. 2.0. If a copy of the MPL was not distributed with this +# file, You can obtain one at http://mozilla.org/MPL/2.0/. +# +# Copyright 1997 - July 2008 CWI, August 2008 - 2022 MonetDB B.V. + %global name MonetDB -%global version 11.44.0 +%global version 11.46.0 %{!?buildno: %global buildno %(date +%Y%m%d)} # Use bcond_with to add a --with option; i.e., "without" is default. @@ -81,7 +87,7 @@ Group: Applications/Databases License: MPLv2.0 URL: https://www.monetdb.org/ BugURL: https://bugs.monetdb.org/ -Source: https://www.monetdb.org/downloads/sources/Jan2022-SP3/%{name}-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Sep2022/%{name}-%{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 @@ -355,6 +361,9 @@ developer. %files client-tests %defattr(-,root,root) +%{_bindir}/ODBCStmtAttr +%{_bindir}/ODBCgetInfo +%{_bindir}/ODBCmetadata %{_bindir}/arraytest %{_bindir}/bincopydata %{_bindir}/odbcsample1 @@ -366,8 +375,6 @@ developer. %{_bindir}/smack01 %{_bindir}/streamcat %{_bindir}/testcondvar -%{_bindir}/testgetinfo -%{_bindir}/testStmtAttr %{_bindir}/malsample.pl %{_bindir}/sqlsample.php %{_bindir}/sqlsample.pl @@ -826,7 +833,6 @@ install -d -m 0775 %{buildroot}%{_rundir rm -f %{buildroot}%{_libdir}/*.la rm -f %{buildroot}%{_libdir}/monetdb5/*.la rm -f %{buildroot}%{_libdir}/monetdb5/lib_opt_sql_append.so -rm -f %{buildroot}%{_libdir}/monetdb5/lib_run_*.so rm -f %{buildroot}%{_libdir}/monetdb5/lib_microbenchmark*.so rm -f %{buildroot}%{_libdir}/monetdb5/lib_udf*.so rm -f %{buildroot}%{_bindir}/monetdb_mtest.sh @@ -849,6 +855,322 @@ fi %endif %changelog +* Fri Sep 23 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.7-20220923 +- Rebuilt. + +* Thu Sep 22 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.5-20220922 +- Rebuilt. + +* Wed Sep 21 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.3-20220921 +- Rebuilt. + +* Wed Sep 21 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.3-20220921 +- clients: Dumping of function GRANTs was improved by adding the types of the + function (and procedure) arguments. + +* Wed Sep 21 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.3-20220921 +- sql: The function sys.tracelog is now executable by anyone. The function + (and view of the same name) returns the tracing information of a query + that was prepended with the TRACE keyword. + +* Mon Sep 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.3-20220921 +- gdk: Fixed a bug in ORDER BY with both NULLS LAST and LIMIT when the ordering + was on an interger or integer-like column and NULL values are present. + +* Mon Sep 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.3-20220921 +- sql: Fixed a bug in COPY BINARY INTO where the input wasn't checked + thoroughly enough. + +* Tue Sep 13 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.3-20220921 +- gdk: The median_avg and quantile_avg returned bogus results in the + non-grouped case (i.e. something like SELECT sys.median_avg(i) FROM t). + +* Tue Sep 13 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- Rebuilt. +- GH#6982: Wrong constraint name in error message of constraint violation +- GH#7209: Configuration option for merovingian.log +- GH#7225: Invalid memory access when extending a BAT during appends +- GH#7227: Date calculations, bug or feature +- GH#7273: Concurrent reads and writes causes "BATproject2: does not match + always" error +- GH#7282: call sys.dump_table_data(); fails +- GH#7285: C-UDFs: aggr_group.count has wrong value (number of input rows + instead of number of groups). +- GH#7296: Implictly cast a timestamp string to DATE when appropriate +- GH#7297: Parsing partial dates behaves unpredictable +- GH#7306: ODBC Driver Assertion `stmt->Dbc->FirstStmt' Failed +- GH#7314: ODBC Driver : please mask/hide password +- GH#7318: distinct in a subquery not working properly + +* Thu Sep 1 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Improved SQLSetPos(). It now allows RowNumber to be 0 when Operation + is SQL_POSITION. + +* Fri Aug 26 2022 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.45.1-20220913 +- sql: Extended the built-in profiler to emit non-MAL events related to query + compilation, optimization, transactions and client connections. To + minimize, simplify and optimize the process of generating and processing + profiler output, only the events marking the end of an operation are + emitted in most cases and the emitted json messages themselves are + trimmed down to their essential fields. Furthermore, the MAL instruction + profiler.openstream now requires an integer as a single argument, "0" for + default behaviour or "4" to turn on the profiler in minimal mode, + which causes it to only emit general events and excludes individual MAL + instruction execution events from the profiler streams. + The MAL instruction profiler.openstream with zero arguments is deprecated. + +* Thu Aug 25 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- sql: Extended system view sys.users with columns: schema_path, max_memory, + max_workers, optimizer and default_role. + Extended system table sys.db_user_info with columns: schema_path, + max_memory, max_workers, optimizer, default_role and password. + The password is encrypted. This table can only be queried when the + user has been granted the select privilege from monetdb. + +* Wed Aug 24 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- gdk: The median_avg and quantile_avg returned bogus results in the + non-grouped case (i.e. something like SELECT sys.median_avg(i) FROM t). + +* Wed Aug 24 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- merovingian: In certain cases (when an mserver5 process exits right after producing + a message) the log message was logged over and over again, causing + monetdbd to use 100% CPU. This has been fixed. + +* Fri Aug 19 2022 svetlin <svetlin.stali...@monetdbsolutions.com> - 11.45.1-20220913 +- sql: CREATE USER statement has been extended to take more optional arguments + like MAX_MEMORY, MAX_WORKERS, OPTIMIZER, DEFAULT ROLE. ALTER USER statement + has also been extended with DEFAULT ROLE. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- sql: A new function sys.url_extract_host(string, bool) which returns the + host name from the given URL has been implemented. The bool argument, + if true, causes the www. prefix to be removed. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- gdk: The abort_on_error parameter of all GDK-level functions has been removed. + Errors (e.g. overflow) now also results in an error. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- sql: The user authentication tables are now administered by the SQL layer + instead of the MAL layer. This means that changing (adding, dropping, + altering) user and role information is now transaction-safe. + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Improved ODBC Error/Warning messages. They now include the name of the + Data Source as required by the ODBC specification: + [MonetDB][ODBC driver VERSION][data-source-name] data-source-supplied-text + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Improved MonetDB ODBC Data Source Configuration dialog on MS Windows by + hiding the typed in password text. It now shows dots for the characters. + This fixes request https://github.com/MonetDB/MonetDB/issues/7314 + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Changed output of TABLE_CAT or PROCEDURE_CAT result columns as returned + by ODBC functions: SQLTables(), SQLColumns(), SQLPrimaryKeys(), + SQLForeignKeys(), SQLStatistics(), SQLTablePrivileges(), + SQLColumnPrivileges(), SQLProcedures() and SQLProcedureColumns(). + They used to return the static database name but now they will return + NULL as MonetDB does not support CATALOG objects or qualifiers. + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Removed the possibility to retrieve or set the CURRENT_CATALOG + via SQLGetConnectAttr(hdbc, SQL_ATTR_CURRENT_CATALOG, ...) and + SQLSetConnectAttr(hdbc, SQL_ATTR_CURRENT_CATALOG, ...) as MonetDB does + not support CATALOG objects (no SQL support for: CREATE CATALOG abc + or SET CATALOG abc) and therefore there is no CURRENT_CATALOG. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- gdk: Implemented BC/AD (and BCE/CE) suffixes when parsing dates. + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Corrected ODBC functions SQLTablePrivileges() and SQLColumnPrivileges() + for local temporary tables located in schema tmp. They did not return + any rows when the temporary table had privileges set. Now they do return + rows as expected. + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Improved SQLProcedures() and SQLProcedureColumns(). They now list + information also for all built-in system procedures and functions, not + only those created via SQL. Also corrected the value of ORDINAL_POSITION + for scalar function arguments. It would start at 2 instead of 1. +- odbc: Extended output of SQLProcedures() and SQLProcedureColumns() resultsets + with an extra column SPECIFIC_NAME. This column contains the name which + uniquely identifies this procedure or function within its schema. As + MonetDB supports overloaded procedures and functions, the combination of + PROCEDURE_SCHEM and PROCEDURE_NAME is not enough to uniquely identify + a procedure or function. This extra column allows you to correctly + match the corresponding rows returned by SQLProcedureColumns() with the + specific rows of SQLProcedures(). This extra column SPECIFIC_NAME is + implemented similar to the JDBC DatabaseMetaData methods getProcedures() + and getProcedureColumns(). + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: For SQLForeignKeys() corrected the output of columns UPDATE_RULE and + DELETE_RULE. These columns used to always return 3 (= SQL_NO_ACTION) + but now they will report the action codes as specified in the FOREIGN KEY + CONSTRAINT construction. + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Fixed issue in function SQLProcedureColumns(). When the argument ColumnName + was not empty it generated an invalid SQL query which failed with error: + SELECT: no such column 'c.name'. This has been resolved. +- odbc: Corrected implementation of SQLGetInfo(hdbc, SQL_MAX_DRIVER_CONNECTIONS, ...). + It used to always return 64. Now it returns the value from the MonetDB server. +- odbc: Changed the column names case of the result sets as returned by + SQLTables(), SQLColumns(), SQLSpecialColumns(), SQLPrimaryKeys(), + SQLForeignKeys(), SQLStatistics(), SQLTablePrivileges(), + SQLColumnPrivileges(), SQLProcedures() and SQLProcedureColumns(). The + column names where all in lowercase but the ODBC specification defines + them in uppercase, so changed them to uppercase. + +* Fri Aug 19 2022 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.45.1-20220913 +- gdk: The interface for using strimps has not changed (create an imprint index + on a column of a read only table), but now construction happens at the + beginning of the first query that uses the strimp and is performed in + a multithreaded manner. + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Corrected SQLSpecialColumns(..., SQL_BEST_ROWID, ...). Previously it only + returned rows when the table had a primary key. Now it also returns + rows when a table has a unique constraint. +- odbc: Corrected SQLStatistics(..., SQL_INDEX_ALL, ...). Previously it only + returned rows when the table had a primary or unique key. Now it also + returns rows for indices which are not based on a key. +- odbc: Corrected SQLStatistics(..., SQL_ENSURE). It now returns CARDINALITY + information for columns based on a primary/unique key. Previously it + always returned NULL for the CARDINALITY result column. + +* Fri Aug 19 2022 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.45.1-20220913 +- gdk: Implemented the use of strimps for NOT LIKE queries. The idea is to + run the corresponding LIKE query using strimps and take the complement + of the result. We keep around NULL values both during strimp filtering + and during the pcre part of the LIKE query so that they get discarded + automatically when we take the complement. + +* Fri Aug 19 2022 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.45.1-20220913 +- monetdb5: Disabled volcano pipeline due to known issues. + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- odbc: Corrected ODBC functions SQLPrimaryKeys(), SQLSpecialColumns() and + SQLStatistics() for local temporary tables located in schema tmp. They did + not return any rows when the temp table had a primary or unique key or _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
