Changeset: 6c838c073f6e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6c838c073f6e Added Files: buildtools/selinux/ChangeLog.Jun2020 clients/odbc/ChangeLog-Archive debian/libmonetdb20.install documentation/source/manual_pages/README sql/server/cmp_exp_eval.h sql/server/rel_out2inner_join.txt sql/server/rel_outer_join_optimizer.h sql/test/Triggers/Tests/trigger_projection.sql.src sql/test/Triggers/Tests/trigger_projection.stable.err sql/test/Triggers/Tests/trigger_projection.stable.out sql/test/Triggers/trigger_projection.sql sql/test/Users/Tests/createUserRollback.SQL.py sql/test/Users/Tests/createUserRollback.stable.err sql/test/Users/Tests/createUserRollback.stable.out Removed Files: ChangeLog.Nov2019 buildtools/ChangeLog.Nov2019 clients/ChangeLog.Nov2019 clients/mapilib/ChangeLog.Nov2019 common/stream/ChangeLog.Nov2019 debian/libmonetdb19.install gdk/ChangeLog.Nov2019 geom/ChangeLog.Nov2019 monetdb5/ChangeLog.Nov2019 sql/ChangeLog.Nov2019 sql/test/miscellaneous/Tests/trigger_projection.sql sql/test/miscellaneous/Tests/trigger_projection.stable.err sql/test/miscellaneous/Tests/trigger_projection.stable.out testing/ChangeLog.Nov2019 tools/merovingian/ChangeLog.Nov2019 Modified Files: .hgtags ChangeLog-Archive ChangeLog.Jun2020 MonetDB.spec NT/monetdb_config.h.in NT/rules.msc buildtools/selinux/ChangeLog-Archive clients/ChangeLog-Archive clients/ChangeLog.Jun2020 clients/Tests/exports.stable.out clients/mapiclient/mclient.1 clients/mapiclient/msqldump.1 clients/mapilib/mapi.rc clients/odbc/ChangeLog.Jun2020 clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc debian/changelog debian/control documentation/source/manual_pages/mclient.rst documentation/source/manual_pages/monetdb.rst documentation/source/manual_pages/monetdbd.rst.in documentation/source/manual_pages/mserver5.rst.in documentation/source/manual_pages/msqldump.rst gdk/ChangeLog-Archive gdk/ChangeLog.Jun2020 gdk/gdk.h gdk/gdk_atoms.h gdk/gdk_batop.c gdk/gdk_hash.c gdk/gdk_join.c gdk/gdk_storage.c gdk/gdk_system.h gdk/gdk_utils.h gdk/libbat.rc geom/lib/libgeom.h geom/monetdb5/geom.c monetdb5/ChangeLog-Archive monetdb5/ChangeLog.Jun2020 monetdb5/extras/rapi/rapi.c monetdb5/mal/mal.h monetdb5/mal/mal_client.c monetdb5/mal/mal_runtime.c monetdb5/modules/mal/mkey.c monetdb5/optimizer/opt_mergetable.c monetdb5/optimizer/opt_mitosis.c monetdb5/tools/Tests/mserver5--help.stable.err monetdb5/tools/Tests/mserver5--help.stable.err.Windows monetdb5/tools/libmonetdb5.rc sql/ChangeLog-Archive sql/ChangeLog.Jun2020 sql/backends/monet5/UDF/pyapi3/Tests/pyloader3_01.stable.out sql/backends/monet5/UDF/pyapi3/pyheader.h sql/backends/monet5/sql_rank.c sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_upgrades.c sql/backends/monet5/sql_user.c sql/common/sql_types.c sql/include/sql_catalog.h sql/include/sql_relation.h sql/server/rel_dump.c sql/server/rel_exp.c sql/server/rel_optimizer.c sql/server/rel_rel.c sql/server/rel_select.c sql/server/rel_unnest.c sql/server/rel_updates.c sql/server/sql_partition.c sql/server/sql_query.c sql/server/sql_semantic.c sql/storage/bat/bat_logger.c sql/storage/bat/bat_storage.c sql/storage/sql_storage.h sql/storage/store.c sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out sql/test/BugTracker-2008/Tests/select_not_wrong_result.SF-2080151.stable.out sql/test/BugTracker-2009/Tests/join_topn.SF-2654133.stable.out sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.SQL.py sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.stable.out sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.single sql/test/Triggers/Tests/All sql/test/Triggers/run.all sql/test/Users/Tests/All sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.SQL.py sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/miscellaneous/Tests/All sql/test/miscellaneous/Tests/simple_selects.sql sql/test/miscellaneous/Tests/simple_selects.stable.out sql/test/subquery/Tests/subquery6.sql sql/test/subquery/Tests/subquery6.stable.out sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out sql/test/sys-schema/Tests/check_Not_Nullable_columns.stable.out sql/test/sys-schema/Tests/systemfunctions.stable.out sql/test/sys-schema/Tests/systemfunctions.stable.out.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 sql/test/wlcr/Tests/wlr110.py sql/test/wlcr/Tests/wlr35.py testing/Mtest.py.in tools/merovingian/ChangeLog-Archive tools/merovingian/ChangeLog.Jun2020 tools/merovingian/client/monetdb.1 tools/merovingian/daemon/handlers.c tools/merovingian/daemon/monetdbd.1.in tools/mserver/mserver5.1.in tools/mserver/mserver5.c Branch: mbedded Log Message:
merged with default diffs (truncated from 225773 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -764,3 +764,5 @@ 179977ed07cd8095f99a6a07968b8e9d1affa753 e1c7c70bceb205cf23b8a35179b628563871f949 Nov2019_SP3_release 179977ed07cd8095f99a6a07968b8e9d1affa753 Nov2019_SP3_release 6b76e1fa9b32421197acf26f63948c858e487d6a Jun2020_root +03ea637c10b5217782acf5db261b4cd71a9afb25 Jun2020_1 +03ea637c10b5217782acf5db261b4cd71a9afb25 Jun2020_release diff --git a/ChangeLog-Archive b/ChangeLog-Archive --- a/ChangeLog-Archive +++ b/ChangeLog-Archive @@ -1,6 +1,27 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Mon Apr 20 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- A new system to deal with debug output has been implemented. There is + now an option --dbtrace to mserver5 that takes a file argument to which + debug output is written. The default value is the file mdbtrace.log + inside the database directory. This option can also be set through + the monetdb program. +- The home directory of the automatically created monetdb user was + changed from /var/MonetDB to /var/lib/monetdb (RPM based systems + only). This home directory is (currently) not used for anything, + though. +- Python 2 support has been removed. There is now only support for + using Python 3. + +* Thu Jan 30 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- Removed support for bam and sam files. + +* Fri Dec 6 2019 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.37.1-20200511 +- Added mserver5 option (--set raw_strings=true|false) and monetdb + database property (raw_strings=yes|no) to control interpretation + of strings. + * Wed Oct 10 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.11-20181011 - Some subtle dependencies between RPMs have been fixed. diff --git a/ChangeLog.Jun2020 b/ChangeLog.Jun2020 --- a/ChangeLog.Jun2020 +++ b/ChangeLog.Jun2020 @@ -1,24 +1,3 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Mon Apr 20 2020 Sjoerd Mullender <sjo...@acm.org> -- A new system to deal with debug output has been implemented. There is - now an option --dbtrace to mserver5 that takes a file argument to which - debug output is written. The default value is the file mdbtrace.log - inside the database directory. This option can also be set through - the monetdb program. -- The home directory of the automatically created monetdb user was - changed from /var/MonetDB to /var/lib/monetdb (RPM based systems - only). This home directory is (currently) not used for anything, - though. -- Python 2 support has been removed. There is now only support for - using Python 3. - -* Thu Jan 30 2020 Sjoerd Mullender <sjo...@acm.org> -- Removed support for bam and sam files. - -* Fri Dec 6 2019 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> -- Added mserver5 option (--set raw_strings=true|false) and monetdb - database property (raw_strings=yes|no) to control interpretation - of strings. - diff --git a/ChangeLog.Nov2019 b/ChangeLog.Nov2019 deleted file mode 100644 --- a/ChangeLog.Nov2019 +++ /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 @@ -105,7 +105,7 @@ Group: Applications/Databases License: MPLv2.0 URL: https://www.monetdb.org/ BugURL: https://bugs.monetdb.org/ -Source: https://www.monetdb.org/downloads/sources/Nov2019-SP3/%{name}-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Jun2020/%{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 @@ -984,6 +984,280 @@ fi %postun -p /sbin/ldconfig %changelog +* Mon May 11 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- Rebuilt. +- BZ#6298: unexpectedly slow execution of SELECT length(fieldname) + FROM tablename LIMIT 1 queries +- BZ#6401: Suspected memory leak in mserver5 when creating/dropping tables +- BZ#6687: Count distinct very slow and use too much the hard drive +- BZ#6731: Add system view to allow querying of available prepared + statements and their parameters +- BZ#6732: Add SQL command to close a specific prepared statement +- BZ#6750: Executing a query on a non-existing column on a remote table + crashes the remote server +- BZ#6785: function sys.isaURL(url) should have been declared as + sys.isaURL(string) +- BZ#6808: reveal the alarm.sleep procedure in SQL +- BZ#6813: function not_uniques(bigint) returns error when called +- BZ#6818: usage of multiple column expressions in where-clause (f(a), + f(b)) in (select a, b) causes assertion failure on mserver5 +- BZ#6821: Failed to start monetdb with embedded python +- BZ#6828: Server crashes when executing a window query with ordering + by EXTRACT date +- BZ#6846: Global temporary table not accessible in other connections + / sessions +- BZ#6847: A simple way of speeding up impscheck for dense canditers +- BZ#6850: Idle timestamp not set +- BZ#6851: json parser doesn't parse integers correctly + +* Fri May 8 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- monetdb5: The mserver5 option --verbose (-v) was removed. A similar effect can + be had by issuing the query CALL logging.setcomplevel('SQL_TRANS', + 'INFO'); as the monetdb user. + +* Wed May 6 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- selinux: There was a problem with the MonetDB SELinux support on Fedora 32. + That is fixed in this release. In order to do a proper upgrade of + the package if you have already installed MonetDB-selinux on Fedora + 32, you may need to uninstall (dnf remove) the old package and then + install the new. + +* Tue Apr 28 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- gdk: The functions BATintersect, BATsemijoin, and BATsubcross have an + extra argument, bool max_one, which indicates that there must be no + more than one match in the join. + +* Tue Apr 28 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- monetdb5: The functions algebra.intersect, algebra.semijoin, and + algebra.crossproduct have an extra argument, bool max_one, which + indicates that there must be no more than one match in the join. + +* Thu Apr 23 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.37.1-20200511 +- sql: Updating the value of a sequence now requires privilege on its own + schema. + +* Mon Apr 20 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- clients: The monetdb-client-tools (Debian/Ubuntu) and MonetDB-client-tools + (Fedora/RH) containing the stethoscope, tachograph, and tomograph has + been removed. A completely new version of stethoscope will be released + to replace the old version. + +* Mon Apr 20 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- gdk: The "unique" property on BATs was removed. The property indicated + that all values in a BAT *had* to be distinct, but this was not + actually used. +- gdk: A new type of candidate list has been introduced. Candidate lists + are used internally to specify which rows of a column participate + in an operation. Before, candidate lists always contained a list of + candidate row IDs. The new candidate list type specifies a list of + row IDs that should NOT be considered (negative candidates). +- gdk: The maximum number of BATs in the system has been increased for 64 + bit architectures. +- gdk: The hash tables used internally by the system now uses a technique + based on Linear Hashing which allows them to grow gracefully. This + means that hash tables aren't removed and recreated nearly as often + anymore. This also meant that the hash table had to be split into + two files, which means that after an upgrade the hash tables have to + be recreated. + +* Mon Apr 20 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- merovingian: On Fedora and RHEL systems (not RHEL 6), if monetdbd runs under systemd, + when the package is updated, monetdbd (and hence any mserver5 process + it runs) is restarted. + +* Mon Apr 20 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- monetdb5: The example module opt_sql_append is not installed in the binary + packages anymore. + +* Mon Apr 20 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- MonetDB: A new system to deal with debug output has been implemented. There is + now an option --dbtrace to mserver5 that takes a file argument to which + debug output is written. The default value is the file mdbtrace.log + inside the database directory. This option can also be set through + the monetdb program. +- MonetDB: The home directory of the automatically created monetdb user was + changed from /var/MonetDB to /var/lib/monetdb (RPM based systems + only). This home directory is (currently) not used for anything, + though. +- MonetDB: Python 2 support has been removed. There is now only support for + using Python 3. + +* Mon Apr 20 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- odbc: The NUMERIC and FLOAT types are now handled fully. Before only DECIMAL, + FLOAT, and DOUBLE were handled fully. +- odbc: Some bugs were fixed in the passing back and forth between application + and server of values of type GUID (UUID). + +* Thu Apr 16 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- clients: Removed the possibility of using the MD5 checksum for authentication + purposes. It was never actively used but was there as an option. + Now the option has been removed. + +* Thu Apr 16 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- sql: The sys.querylog_enable(threshold integer) now actually enables the + querylog and uses a threshold in milliseconds. + +* Wed Apr 15 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.37.1-20200511 +- sql: Removed UNION JOIN statements. They were dropped by the SQL:2003 + standard, plus MonetDB implementation was not fully compliant. + +* Wed Apr 1 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- sql: The OFFSET value in the COPY INTO query now counts uninterpreted + newlines. Before it counted "unquoted record separators" which meant + that if you had a single quote on a line that you want to skip, you + could not use the feature. + +* Mon Mar 30 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- gdk: Implemented a version of BATproject, called BATproject2, with two + "right" arguments which conceptually follow each other. + +* Fri Mar 27 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.37.1-20200511 +- sql: Added support for FROM RANGE MINVALUE TO RANGE MAXVALUE and FROM RANGE + MINVALUE TO RANGE MAXVALUE WITH NULL VALUES cases in partitioned tables + by range (before they weren't). + +* Wed Mar 25 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- gdk: Removed MT_mmap and MT_munmap from the list of exported functions. + Use GDKmmap and GDKmunmap with the same parameters instead. + +* Fri Mar 20 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- gdk: Changed the interface of the atom "fix" and "unfix" functions. + They now return a value of type gdk_return to indicate success/failure. + +* Sat Feb 22 2020 Thodoris Zois <thodoris.z...@monetdbsolutions.com> - 11.37.1-20200511 +- merovingian: Added dbtrace mserver5 option to the daemon in order to set + mserver5's output directory for the produced traces. + +* Sat Feb 22 2020 Thodoris Zois <thodoris.z...@monetdbsolutions.com> - 11.37.1-20200511 +- monetdb5: Added mserver5 option (--dbtrace=<path>) in order to be able to + specify the output file any produced traces. + +* Sat Feb 22 2020 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.37.1-20200511 +- clients: Add port and host as fields in the .monetdb file. + +* Sat Feb 22 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- MonetDB: Removed support for bam and sam files. + +* Sat Feb 22 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.37.1-20200511 +- sql: Implemented 'covar_pop' and 'covar_samp' aggregate functions, as well + as their window function counterparts. Implemented 'stddev_samp', + 'stddev_pop', 'var_samp', 'var_pop', 'corr' and 'group_concat' + window function correspondents. +- sql: Extended SQL catalog with CREATE WINDOW syntax for user-defined + SQL:2003 window functions. At the moment, window functions must be + defined on the backend engine, i.e. on this case MAL. In the current + implementation, the backend code generation creates two additional + columns of type lng with the start and end offsets for each row. + +* Sat Feb 22 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- sql: Removed support for Python 2. Python 2 itself is no longer + supported. Use Python 3 instead. Functions that were declared as + LANGUAGE PYTHON2 or LANGUAGE PYTHON2_MAP are changed to LANGUAGE + PYTHON and LANGUAGE PYTHON_MAP respectively (without changing the + Python code). + +* Sat Feb 22 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.37.1-20200511 +- sql: Added prepared_statements_args view, which details the arguments for + the prepared statements created in the current session. + +* Sat Feb 22 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.37.1-20200511 +- sql: Added sys.prepared_statements view, which lists the available prepared + statements in the current session. +- sql: Added deallocate statements with the syntax 'DEALLOCATE [PREPARE] + { number | ALL }', to close an existing prepared statement or all, + through the SQL layer. Previously this feature was available via MAPI + exclusively with the "release" command. + +* Sat Feb 22 2020 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.37.1-20200511 +- MonetDB: Added mserver5 option (--set raw_strings=true|false) and monetdb + database property (raw_strings=yes|no) to control interpretation + of strings. + +* Sat Feb 22 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- gdk: Removed the tunique property. The tunique property indicated that + all values in the column had to be distinct. It was removed because + it wasn't used. + +* Sat Feb 22 2020 Sjoerd Mullender <sjo...@acm.org> - 11.37.1-20200511 +- monetdb5: Removed function bat.setKey(). + +* Sat Feb 22 2020 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.37.1-20200511 +- sql: Added support for raw strings using the syntax r'' or R''. This means + that C-like escapes will remain uninterpreted within those strings. For + instance SELECT r'\"' returns a string of length two. The user needs + to escape single quotes by doubling them: SELECT r''''. + +* Sat Feb 22 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.37.1-20200511 +- sql: Implemented ROLLUP, CUBE and GROUPING SETS from SQL:1999. They + define grouping subsets used with the GROUP BY clause in order to + compute partial groupings. Also, the GROUPING aggregate was + added. This aggregate is a bitmask identifying the grouping columns _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
