Changeset: d6d36e72915a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d6d36e72915a Modified Files: MonetDB.spec cmake/monetdb-versions.cmake Branch: default Log Message:
Merge with Sep2022 branch. diffs (truncated from 2597 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -778,3 +778,4 @@ 3191fee438036ac0da1e6f31481b9681399123b5 3191fee438036ac0da1e6f31481b9681399123b5 Jan2022_SP4_release bdd04053973daa8a786a30e07b2bf1bd8aa6ebf1 Jul2021_27 bdd04053973daa8a786a30e07b2bf1bd8aa6ebf1 Jul2021_SP8_release +688ff09b2edc3d637f658f3e7ef3d5f07e3e8f9c Sep2022_1 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/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -81,7 +81,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-SP4/%{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 @@ -849,6 +849,215 @@ fi %endif %changelog +* 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 has an overload that takes a single string + argument which can be set to "min" 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. + +* 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 + index. Now they do return rows as expected. + +* Fri Aug 19 2022 Nuno Faria <nunofpfa...@gmail.com> - 11.45.1-20220913 +- sql: Added the UNLOGGED TABLE feature. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- gdk: The function BBPkeepref now gets a BAT pointer as argument instead of + a bat id. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- gdk: Get rid of macro Tsize, use ->twidth instead. +- gdk: Get rid of macro BUNlast, just use BATcount instead. + +* Fri Aug 19 2022 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.45.1-20220913 +- merovingian: Added "loglevel" property for monetdbd logging (to merovingian.log). + The loglevel can be set to: error or warning or information or debug. + The loglevel property can be changed dynamically via command: + monetdbd set loglevel=warning /path/to/dbfarm + Default the loglevel is set to: information + When loglevel is error, only errors are logged. + When loglevel is warning, errors and warnings are logged. + When loglevel is information, errors and warnings and information messages + are logged. When loglevel is debug, all messages are logged. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- merovingian: There is now a loadmodules property that can be used to add --loadmodule + arguments to the mserver5 command line. See the monetdb and mserver5 + manual pages. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- sql: Removed functions sys.index and sys.strings. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- gdk: The BLOB type has been moved into the GDK layer. + +* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.45.1-20220913 +- gdk: When adding or subtracting months from a date or timestamp value, + clamp the result to the calculated month instead of wrapping to the + beginning of the next month. See bug 7227. + * Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.21-20220819 - Rebuilt. @@ -1183,341 +1392,3 @@ fi - merovingian: Removed the deprecated monetdb commands `profilerstart` and `profilerstop`. -* Mon Dec 13 2021 Sjoerd Mullender <sjo...@acm.org> - 11.41.13-20211213 -- Rebuilt. -- GH#7163: Multiple sql.mvc() invocations in the same query -- GH#7167: sys.shutdown() problems -- GH#7184: Insert into query blocks all other queries -- GH#7185: GROUPING SETS on groups with aliases provided in the SELECT - returns empty result -- GH#7186: data files created with COPY SELECT .. INTO 'file.csv' fail to - be loaded using COPY INTO .. FROM 'file.csv' when double quoted string - data contains the field values delimiter character -- GH#7191: [MonetDBe] monetdbe_cleanup_statement() with bound NULLs on - variable-sized types bug -- GH#7196: BATproject2: does not match always -- GH#7198: Suboptimal query plan for query containing JSON access filter - and two negative string comparisons -- GH#7200: PRIMARY KEY unique constraint is violated with concurrent - inserts -- GH#7206: Python UDF fails when returning an empty table as a dictionary - -* Mon Dec 13 2021 Sjoerd Mullender <sjo...@acm.org> - 11.41.13-20211213 -- clients: Dumping the database now also dumps the read-only and insert-only - states of tables. - -* Mon Dec 13 2021 Sjoerd Mullender <sjo...@acm.org> - 11.41.13-20211213 -- gdk: Sometimes when the server was restarted, it wouldn't start anymore due - to an error from BBPcheckbats. We finally found and fixed a (hopefully - "the") cause of this problem. - -* Thu Oct 28 2021 Sjoerd Mullender <sjo...@acm.org> - 11.41.13-20211213 -- sql: Number parsing for SQL was fixed. If a number was immediately followed - by letters (i.e. without a space), the number was accepted and the - alphanumeric string starting with the letter was interpreted as an alias - (if aliases were allowed in that position). - -* Thu Sep 30 2021 Sjoerd Mullender <sjo...@acm.org> - 11.41.11-20210930 -- Rebuilt. - -* Tue Sep 28 2021 Sjoerd Mullender <sjo...@acm.org> - 11.41.9-20210928 -- Rebuilt. - -* Mon Sep 27 2021 Sjoerd Mullender <sjo...@acm.org> - 11.41.7-20210927 -- Rebuilt. -- GH#7140: SQL Query Plan Non Optimal with View -- GH#7162: Extend sys.var_values table -- GH#7165: `JOINIDX: missing '.'` when running distributed join query on - merged remote tables -- GH#7172: Unexpected query result with merge tables -- GH#7173: If truncate is in transaction then after restart of MonetDB the - table is empty -- GH#7178: Remote Table Throws Error - createExceptionInternal: !ERROR: - SQLException:RAstatement2:42000!The number of projections don't match - between the generated plan and the expected one: 1 != 1200 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
