Changeset: cb17f8cc3731 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cb17f8cc3731 Added Files: debian/libmonetdb-client9.install debian/libmonetdb15.install sql/backends/monet5/Tests/pyloader08.sql sql/backends/monet5/Tests/pyloader08.stable.err sql/backends/monet5/Tests/pyloader08.stable.out sql/test/BugTracker-2017/Tests/groupby_assertion.Bug-6338.sql sql/test/BugTracker-2017/Tests/handle-values-subqueries.Bug-6336.sql sql/test/BugTracker-2017/Tests/handle-values-subqueries.Bug-6336.stable.err sql/test/BugTracker-2017/Tests/handle-values-subqueries.Bug-6336.stable.out sql/test/BugTracker-2017/Tests/multiplevalues.Bug-6336.sql sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.sql sql/test/BugTracker-2017/Tests/spurious_error.Bug-6344.sql Removed Files: debian/libmonetdb-client8.install debian/libmonetdb13.install Modified Files: .hgignore .hgtags ChangeLog-Archive ChangeLog.Jul2017 MonetDB.spec NT/monetdb_config.h.in NT/rules.msc clients/ChangeLog-Archive clients/ChangeLog.Jul2017 clients/mapiclient/eventparser.c clients/mapiclient/eventparser.h clients/mapiclient/mhelp.c clients/mapiclient/stethoscope.c clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc common/stream/stream.c common/stream/stream.h configure.ag debian/changelog debian/control gdk/ChangeLog-Archive gdk/ChangeLog.Jul2017 gdk/gdk_value.c gdk/libbat.rc libversions monetdb5/ChangeLog-Archive monetdb5/ChangeLog.Jul2017 monetdb5/mal/mal_interpreter.c monetdb5/mal/mal_profiler.c monetdb5/mal/mal_runtime.c monetdb5/mal/mal_type.c monetdb5/modules/mal/Tests/inspect00.stable.out monetdb5/modules/mal/calc.c monetdb5/modules/mal/remote.c monetdb5/optimizer/opt_dataflow.c monetdb5/optimizer/opt_mergetable.c monetdb5/optimizer/opt_pushselect.c monetdb5/tools/libmonetdb5.rc sql/ChangeLog-Archive sql/ChangeLog.Jul2017 sql/backends/monet5/Tests/pyloader01.stable.out sql/backends/monet5/Tests/pyloader02.stable.out sql/backends/monet5/Tests/pyloader03.stable.out sql/backends/monet5/Tests/pyloader04.stable.out sql/backends/monet5/Tests/pyloader05.stable.out sql/backends/monet5/UDF/pyapi/connection.c sql/backends/monet5/UDF/pyapi/connection.h sql/backends/monet5/UDF/pyapi/conversion.c sql/backends/monet5/UDF/pyapi/pyapi_locatepython.bat sql/backends/monet5/UDF/pyapi/pyloader.c sql/backends/monet5/UDF/pyapi/type_conversion.c sql/backends/monet5/mal_backend.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql.h sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_statement.c sql/backends/monet5/vaults/fits/fits.c sql/backends/monet5/vaults/netcdf/netcdf.c sql/common/sql_types.c sql/include/sql_catalog.h sql/server/rel_distribute.c sql/server/rel_distribute.h sql/server/rel_dump.c sql/server/rel_optimizer.c sql/server/rel_psm.c sql/server/rel_rel.c sql/server/rel_schema.c sql/server/rel_select.c sql/server/rel_select.h sql/server/rel_updates.c sql/server/sql_parser.y sql/storage/bat/bat_table.c sql/storage/store.c sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out.Windows sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out sql/test/BugTracker-2017/Tests/All sql/test/BugTracker-2017/Tests/crash-dce.Bug-6330.stable.out sql/test/BugTracker/Tests/explain.SF-1739353.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 sql/test/Tests/systemfunctions.stable.out.int128 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/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/select1.stable.out sql/test/leaks/Tests/select1.stable.out.int128 sql/test/leaks/Tests/select2.stable.out sql/test/leaks/Tests/select2.stable.out.int128 sql/test/leaks/Tests/temp1.stable.out sql/test/leaks/Tests/temp1.stable.out.int128 sql/test/mergetables/Tests/mergequery.stable.out sql/test/pg_regress/Tests/alter_table.stable.err sql/test/pg_regress/Tests/alter_table.stable.out sql/test/pg_regress/Tests/insert.stable.err tools/merovingian/ChangeLog-Archive tools/merovingian/ChangeLog.Jul2017 tools/merovingian/daemon/Makefile.ag vertoo.data Branch: stratified_sampling Log Message:
Merge with default. diffs (truncated from 46612 to 300 lines): diff --git a/.hgignore b/.hgignore --- a/.hgignore +++ b/.hgignore @@ -63,6 +63,10 @@ lex.yy.c *.dll # other files we don't want +GTAGS +gtags.files +GPATH +GRTAGS TAGS tags *.pyo diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -673,3 +673,5 @@ c57454c6c6f6e77fbbdf70de32a7cc845b67d1dd 05f4e62bc67911a25f19be7fe742009ab1ee41c7 Dec2016_SP4_release 8b3d3f7c487cb6e34dab1167797a61862cba2124 Dec2016_23 8b3d3f7c487cb6e34dab1167797a61862cba2124 Dec2016_SP5_release +e6552cdd3180bcd35f959954807cab986a6042a5 Jul2017_1 +e6552cdd3180bcd35f959954807cab986a6042a5 Jul2017_release diff --git a/ChangeLog-Archive b/ChangeLog-Archive --- a/ChangeLog-Archive +++ b/ChangeLog-Archive @@ -1,6 +1,31 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Thu Apr 13 2017 Mark Raasveldt <m.raasve...@cwi.nl> - 11.27.1-20170705 +- Added a new server-side protocol implementation. The new protocol + is backwards compatible with the old protocol. Clients can choose + whether they want to use the old or the new protocol during the initial + handshake with the server. The new protocol is a binary column-based + protocol that is significantly faster than the old protocol when + transferring large result sets. In addition, the new protocol supports + compression using Snappy or LZ4. + +* Mon Feb 20 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- Moved the sphinx extension module to its own repository. + See https://dev.monetdb.org/hg/MonetDB-sphinx/. + +* Thu Feb 16 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- Removed GSL module: it's now a separate (extension) package. + See https://dev.monetdb.org/hg/MonetDB-gsl/. +- The PCRE library is now optional for systems that support POSIX regular + expressions. + +* Thu Jan 12 2017 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.27.1-20170705 +- Added 5 new sys schema tables: function_languages, function_types, + key_types, index_types and privilege_codes. They are pre-loaded with + static content and contain descriptive names for the various integer + type and code values. See also sql/scripts/51_sys_schema_extension.sql + * Thu Sep 22 2016 Sjoerd Mullender <sjo...@acm.org> - 11.25.1-20161214 - The Perl, PHP, and Python clients, and the JDBC driver each now have their own repositories and release cycles. The Python client is diff --git a/ChangeLog.Jul2017 b/ChangeLog.Jul2017 --- a/ChangeLog.Jul2017 +++ b/ChangeLog.Jul2017 @@ -1,27 +1,3 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Thu Apr 13 2017 Mark Raasveldt <m.raasve...@cwi.nl> -- Added a new server-side protocol implementation. The new protocol - is backwards compatible with the old protocol. Clients can choose - whether they want to use the old or the new protocol during the initial - handshake with the server. The new protocol is a binary column-based - protocol that is significantly faster than the old protocol when - transferring large result sets. In addition, the new protocol supports - compression using Snappy or LZ4. - -* Mon Feb 20 2017 Sjoerd Mullender <sjo...@acm.org> -- Moved the sphinx extension module to its own repository. - See https://dev.monetdb.org/hg/MonetDB-sphinx/. - -* Thu Feb 16 2017 Sjoerd Mullender <sjo...@acm.org> -- Removed GSL module: it's now a separate (extension) package. - See https://dev.monetdb.org/hg/MonetDB-gsl/. -- The PCRE library is now optional for systems that support POSIX regular - expressions. - -* Thu Jan 12 2017 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> -- Added 5 new sys schema tables: function_languages, function_types, - key_types, index_types and privilege_codes. They are pre-loaded with - static content and contain descriptive names for the various integer - type and code values. See also sql/scripts/51_sys_schema_extension.sql diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -132,7 +132,7 @@ Vendor: MonetDB BV <i...@monetdb.org> Group: Applications/Databases License: MPLv2.0 URL: https://www.monetdb.org/ -Source: https://www.monetdb.org/downloads/sources/Dec2016-SP5/%{name}-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Jul2017/%{name}-%{version}.tar.bz2 # we need systemd for the _unitdir macro to exist %if %{?rhel:0}%{!?rhel:1} || 0%{?rhel} >= 7 @@ -407,7 +407,7 @@ Recommends: perl-DBD-monetdb >= 1.0 Recommends: php-monetdb >= 1.0 %endif Requires: %{name}-SQL-server5%{?_isa} = %{version}-%{release} -Requires: python-pymonetdb >= 1.0 +Requires: python-pymonetdb >= 1.0.6 %description client-tests MonetDB is a database management system that is developed from a @@ -591,6 +591,8 @@ Recommends: MonetDB5-server-hugeint%{?_i %endif Suggests: %{name}-client%{?_isa} = %{version}-%{release} %endif +# versions up to 1.0.5 don't accept the queryid field in the result set +Conflicts: python-pymonetdb < 1.0.6 %description -n MonetDB5-server MonetDB is a database management system that is developed from a @@ -781,7 +783,7 @@ systemd-tmpfiles --create %{_sysconfdir} # no _unitdir macro %exclude %{_prefix}/lib/systemd/system/monetdbd.service %endif -%config(noreplace) %{_localstatedir}/monetdb5/dbfarm/.merovingian_properties +%config(noreplace) %attr(664,monetdb,monetdb) %{_localstatedir}/monetdb5/dbfarm/.merovingian_properties %{_libdir}/monetdb5/autoload/??_sql.mal %{_libdir}/monetdb5/lib_sql.so %{_libdir}/monetdb5/*.sql @@ -958,6 +960,153 @@ rm -f %{buildroot}%{_bindir}/Maddlog %postun -p /sbin/ldconfig %changelog +* Wed Jul 05 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- Rebuilt. +- BZ#3465: Request: add support for CREATE VIEW with ORDER BY clause +- BZ#3545: monetdb commands don't work with -h -P -p options (locally + and remotely) +- BZ#3996: select * from sys.connections always returns 0 rows. Expected + to see at least one row for the active connection. +- BZ#6187: Nested WITH queries not supported +- BZ#6225: Order of evaluation of the modulo operator +- BZ#6289: Crashes and hangs with remote tables +- BZ#6292: Runaway SQL optimizer in too many nested operators +- BZ#6310: Name resolution error (sqlsmith) +- BZ#6312: Object not found in LIMIT clause (sqlsmith) +- BZ#6313: Null type resolution in disjunction fails (sqlsmith) +- BZ#6319: Server crash on LATERAL (sqlsmith) +- BZ#6322: Crash on disjunction with LIMIT (sqlsmith) +- BZ#6323: Deadlock calling sys.bbp() +- BZ#6324: Sqlitelogictest crash in a IN query (8th) +- BZ#6327: The daemon does not respect the actual name of the mserver5 + executable +- BZ#6330: Sqlitelogictest crash on a complex SELECT query +- BZ#6331: sys.statistics column "nils" always contains 0. Expected a + positive value for columns that have one or more nils/NULLs +- BZ#6332: Sqlitelogictest crash related to an undefined MAL function + +* Mon May 29 2017 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.27.1-20170705 +- merovingian: Added handling of a dbextra property per database at the daemon + level. The user can set the dbextra property for a database using the + command: $ monetdb set dbextra=<path> <database> and the daemon will + make sure to start the new server using the correct + --dbextra parameter. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- monetdb5: The "sub" prefix of many functions, both at the MAL and the C level, + has been removed. + +* Mon May 29 2017 Mark Raasveldt <m.raasve...@cwi.nl> - 11.27.1-20170705 +- MonetDB: Added a new server-side protocol implementation. The new protocol + is backwards compatible with the old protocol. Clients can choose + whether they want to use the old or the new protocol during the initial + handshake with the server. The new protocol is a binary column-based + protocol that is significantly faster than the old protocol when + transferring large result sets. In addition, the new protocol supports + compression using Snappy or LZ4. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- gdk: Improved error checking in the logger code (dealing with the write-ahead + log); changed return types a several functions from int to gdk_return + (i.e., they now return GDK_SUCCEED or GDK_FAIL). The logger no longer + calls GDKfatal on error. Instead the caller is responsible for dealing + with errors. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- sql: Made the operator precedence of % equal to those of * and /. All three + are evaluated from left to right. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- MonetDB: Moved the sphinx extension module to its own repository. + See https://dev.monetdb.org/hg/MonetDB-sphinx/. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- gdk: BATsort may now create an order index as a by product. +- gdk: Quantile calculations now use the order index if available (and use + BATsort otherwise, producing an order index). +- gdk: Quantiles calculate a position in the sorted column. If this position + is not an integer, we now choose the nearest position, favoring the + lower if the distance to the two adjacent positions is equal (round + down to nearest integer). + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- MonetDB: Removed GSL module: it's now a separate (extension) package. + See https://dev.monetdb.org/hg/MonetDB-gsl/. +- MonetDB: The PCRE library is now optional for systems that support POSIX regular + expressions. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- sql: Removed table sys.connections. It was a remnant of an experimental + change that had already been removed in 2012. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- gdk: Removed function BATprintf. Use BATprint or BATprintcolumns instead. +- gdk: Removed BATsave from the list of exported functions. + +* Mon May 29 2017 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.27.1-20170705 +- MonetDB: Added 5 new sys schema tables: function_languages, function_types, + key_types, index_types and privilege_codes. They are pre-loaded with + static content and contain descriptive names for the various integer + type and code values. See also sql/scripts/51_sys_schema_extension.sql + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- monetdb5: Changed the interfaces of the AUTH* functions: pass values, not pointers + to values. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- gdk: Replaced BBPincref/BBPdecref with BBPfix/BBPunfix for physical reference + count and BBPretain/BBPrelease for logical reference count maintenance. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- gdk: Removed automatic conversion of 32-bit OIDs to 64 bits on 64-bit + architectures. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- gdk: Removed functions OIDbase() and OIDnew(). +- gdk: Removed talign field from BAT descriptor. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- monetdb5: Removed calc.setoid(). +- monetdb5: group.subgroup is now called group.group if it is not refining a group. + Both group.group and group.subgroup now also have variants with a + candidate list. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- clients: The mclient and msqldump programs lost compatibility with old + mserver5 versions (pre 2014) which didn't have a "system" column in + the sys.schemas table. +- clients: The mclient and msqldump programs lost compatibility with ancient + mserver5 versions (pre 2011) which didn't have the sys.systemfunctions + table. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- gdk: BATappend now takes an optional (NULL if not used) candidate list for + the to-be-appended BAT. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- gdk: New function BATkeyed(BAT *b) that determines (possibly using a hash + table) whether all values in b are distinct. + +* Mon May 29 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- clients: Removed the "array" and "quick" functions from the mapi library. + To be precise, the removed functions are: mapi_execute_array, + mapi_fetch_field_array, mapi_prepare_array, mapi_query_array, + mapi_quick_query, mapi_quick_query_array, and mapi_quick_response. + +* Mon May 29 2017 Martin Kersten <m...@cwi.nl> - 11.27.1-20170705 +- monetdb5: The allocation schemes for MAL blocks and Variables has been turned + into block-based. This reduces the number of malloc()/free() calls. + +* Mon May 29 2017 Martin Kersten <m...@cwi.nl> - 11.27.1-20170705 +- sql: Protect against runaway profiler events If you hit a barrier block + during profiling, the JSON event log may quickly become unwieldy. Event + production is protected using a high water mark, which ensures that + never within the single execution of MAL block the instruction causes + excessive event records. + +* Mon May 29 2017 Martin Kersten <m...@cwi.nl> - 11.27.1-20170705 +- clients: Added a more elaborate \help command for SQL expressions. + * Mon May 29 2017 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.25.23-20170529 - Rebuilt. - BZ#6290: Crash (and assertion failure) with a correlated subquery with diff --git a/clients/ChangeLog-Archive b/clients/ChangeLog-Archive --- a/clients/ChangeLog-Archive +++ b/clients/ChangeLog-Archive @@ -1,6 +1,23 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Mon Dec 12 2016 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- The mclient and msqldump programs lost compatibility with old + mserver5 versions (pre 2014) which didn't have a "system" column in + the sys.schemas table. +- The mclient and msqldump programs lost compatibility with ancient + mserver5 versions (pre 2011) which didn't have the sys.systemfunctions + table. + +* Wed Nov 16 2016 Sjoerd Mullender <sjo...@acm.org> - 11.27.1-20170705 +- Removed the "array" and "quick" functions from the mapi library. + To be precise, the removed functions are: mapi_execute_array, _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
