Changeset: abdcbeeebb4a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=abdcbeeebb4a Added Files: debian/libmonetdb-client8.install debian/libmonetdb-stream8.install debian/libmonetdb13.install Removed Files: buildtools/ChangeLog.Jul2015 clients/ChangeLog.Jul2015 clients/mapilib/ChangeLog.Jul2015 clients/python2/ChangeLog.Jul2015 clients/python3/ChangeLog.Jul2015 common/stream/ChangeLog.Jul2015 debian/libmonetdb-client7.install debian/libmonetdb-stream7.install debian/libmonetdb12.install gdk/ChangeLog.Jul2015 geom/ChangeLog.Jul2015 java/ChangeLog.Jul2015 monetdb5/ChangeLog.Jul2015 sql/ChangeLog.Jul2015 testing/ChangeLog.Jul2015 tools/merovingian/ChangeLog.Jul2015 Modified Files: .hgtags MonetDB.spec buildtools/ChangeLog-Archive buildtools/ChangeLog.Jun2016 clients/ChangeLog-Archive clients/ChangeLog.Jun2016 debian/changelog debian/control gdk/ChangeLog-Archive gdk/ChangeLog.Jun2016 geom/ChangeLog-Archive geom/ChangeLog.Jun2016 java/ChangeLog-Archive java/ChangeLog.Jun2016 java/Makefile.ag java/build.properties java/pom.xml java/release.txt libversions monetdb5/ChangeLog-Archive monetdb5/ChangeLog.Jun2016 sql/ChangeLog-Archive sql/ChangeLog.Jun2016 Branch: default Log Message:
Merge with Jun2016 branch. diffs (truncated from 1812 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -622,3 +622,5 @@ ee54e50fccb17db48bbfd983882e8491a869131c ee54e50fccb17db48bbfd983882e8491a869131c Jul2015_SP3_release 51322027cb7e7c27f03fc7c3cab4db4fd4cd4446 Jul2015_19 51322027cb7e7c27f03fc7c3cab4db4fd4cd4446 Jul2015_SP4_release +192e3168234a5f9f8a4d1c4ce17805f608f001c3 Jun2016_1 +192e3168234a5f9f8a4d1c4ce17805f608f001c3 Jun2016_release diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -110,7 +110,7 @@ Vendor: MonetDB BV <i...@monetdb.org> Group: Applications/Databases License: MPLv2.0 URL: http://www.monetdb.org/ -Source: http://dev.monetdb.org/downloads/sources/Jul2015-SP4/%{name}-%{version}.tar.bz2 +Source: http://dev.monetdb.org/downloads/sources/Jun2016/%{name}-%{version}.tar.bz2 # we need systemd for the _unitdir macro to exist %if %{?rhel:0}%{!?rhel:1} || 0%{?rhel} >= 7 @@ -1013,6 +1013,337 @@ rm -f %{buildroot}%{_bindir}/Maddlog %postun -p /sbin/ldconfig %changelog +* Wed Jun 01 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- Rebuilt. +- BZ#2407: Merovingian: allow binds to given ip/interface +- BZ#2815: No SRID support +- BZ#3460: incomplete implementation of JDBC driver supportsConvert(), + supportsConvert(int fromType, int toType) methods in + MonetDatabaseMetaData.java +- BZ#3711: JDBC connection using jdbcclient.jar is very slow +- BZ#3877: MonetDBLite should allow close then re-open databases? + without restarting R +- BZ#3911: Invalid connect() call in 'redirect' mode +- BZ#3920: query with DISTINCT and correlated scalar subquery in SELECT + list causes Assertion failure and crash of mserver5 +- BZ#3927: COUNT( distinct my_clob ) , QUANTILE( my_double , number ) + fails in dev build +- BZ#3956: MonetDBLite unable to execute LIMIT 1 statement +- BZ#3972: Drastic Memory leak of 600GBs while generating plan for Query + with 25 joins +- BZ#3974: Prepared statement rel_bin.c:2378: rel2bin_project: Assertion + `0' failed. +- BZ#3975: Suspicious code in store_manager() on exit path +- BZ#3978: SQL returns TypeException 'aggr.subcorr' undefined for + sys.corr function +- BZ#3980: JOIN with references on both sides crashes mserver +- BZ#3981: Incorrect LEFT JOIN when FROM clause contains nested subqueries +- BZ#3983: Creation of a Foreign Key which partially maps to a primary + key is accepted without a warning +- BZ#3984: Multiple paths in the .profile +- BZ#3985: ruby-monetdb-sql gem fails for negative timezone offset + (USA, etc.) +- BZ#3987: Segfault on malformed csv import +- BZ#3991: MonetDBLite feature request: default monetdb.sequential to + FALSE on windows +- BZ#3994: MonetDBLite dbDisconnect with shutdown=TRUE freezes the + console on windows +- BZ#3995: NullPointerException when calling getObject() +- BZ#3997: calling scalar functions sys.isaUUID(str) or sys.isaUUID(uuid) + fail +- BZ#3999: length() returns wrong length for strings which have spaces + at the end of the string +- BZ#4010: RELEASE SAVEPOINT after ALTER TABLE crashes mserver5 +- BZ#4011: sys.sessions.user column always shows 'monetdb' +- BZ#4013: GDKextendf does not free up memory when it fails due to + insufficient resources + +* Thu May 26 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Fixed problem in DatabaseMetaData.getUDTs() when it was called with + types parameter filled. It used to throw SQException with message: + SELECT: identifier 'DATA_TYPE' unknown. Now it returns the UDTs which + match the provided array of data types. + +* Thu May 19 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Implemented MonetDatabaseMetaData.supportsConvert() and + MonetDatabaseMetaData.supportsConvert(int fromType, int toType) methods. + It used to always return false. Now it returns true for the supported conversions. + This fixes Bug 3460. + +* Thu May 12 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Corrected MonetResultSet.getObject(String columnName). It no longer + throws a NullPointerException in cases where internally a + MonetVirtualResultSet is used. + +* Thu May 12 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Improved JdbcClient program when presenting query data to console. + It used to send an SQL catalog query for each query result column + which slowed down the interactive response considerably. + These additional SQL catalog queries have been eliminated. + +* Sun May 8 2016 Jennie Zhang <y.zh...@cwi.nl> - 11.23.1-20160601 +- java: Fixed Connection.isValid(): this method should never attempt to + close the connection, even if an error has occurred. + +* Sun May 8 2016 Jennie Zhang <y.zh...@cwi.nl> - 11.23.1-20160601 +- java: ResultSet.setFetchSize(): added a dummy implementation to get rid + of the SQLFeatureNotSupportedException. In MonetDB, it does not + make sense to set the fetch size of a result set. If one really + wants to set the fetch size, one should use Statement.setFetchSize() + instead. + +* Thu Apr 21 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Fixed resource leak in ResultSetMetaData. It created and cached a ResultSet + object for each column but never closed the ResultSet objects. + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Corrected DatabaseMetaData methods which accept a catalog filter argument. + Those methods will now filter the results on the specified catalog name, + whereas previously the catalog filter argument was ignored. +- java: Corrected output of column KEY_SEQ of DatabaseMetaData methods: + getPrimaryKeys(), getImportedKeys(), getExportedKeys() and + getCrossReference(). It now starts at 1 instead of 0 previously. + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Corrected DatabaseMetaData.getSchemas() by returning 2 instead of 3 columns. +- java: Improved DatabaseMetaData.getColumns() by returning two additional + columns: IS_AUTOINCREMENT and IS_GENERATEDCOLUMN. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: Removed BATconst. Use BATconstant instead. +- gdk: Changed BATconstant. It now has a new first argument with the seqbase + for the head column. + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Improved DatabaseMetaData.getTypeInfo(). It now returns better information + on LITERAL_PREFIX, LITERAL_SUFFIX, CREATE_PARAMS, CASE_SENSITIVE, + FIXED_PREC_SCALE and MAXIMUM_SCALE for some data types. Also the returned rows + are now ordered by DATA_TYPE, TYPE_NAME, PRECISION as required by the specs. + Also corrected output column names "searchable" into "SEARCHABLE" and + "MAXIMUM SCALE" into "MAXIMUM_SCALE" to match the JDBC specification. +- java: Corrected DatabaseMetaData.getPseudoColumns(). It used to return 12 empty rows. + Now it returns no rows as MonetDB does not have pseudo columns. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- clients: The Ruby client is now in a separate repository + (http://dev.monetdb.org/hg/monetdb-ruby) and released independently. + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Implemented method DatabaseMetaData.getClientProperties(). It used to always + return a resultset with 4 completely empty rows. It now returns a + resultset with the possible connection properties. +- java: Implemented method DatabaseMetaData.getUDTs(). It used to return an empty + resultset. Now it returns the User Defined Types such as inet, json, url and uuid. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- buildtools: A new package MonetDB-lidar (Fedora) or libmonetdb5-server-lidar + (Debian/Ubuntu) has been created to work with LiDAR data. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- geom: The geom module has been completely overhauled. Types are now specified + as GEOMETRY(POINT) instead of POINT, old functions have been removed, + new ones introduced. However, even with all the changes, a database + upgrade should still be possible (as always, make a backup first). + +* Tue Apr 5 2016 Martin Kersten <m...@cwi.nl> - 11.23.1-20160601 +- monetdb5: Extended the storage() table producing function to also accept + storage([schemaname [, tablename [, columnname]]]) + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Corrected the returned table types in DatabaseMetaData.getTableTypes(). + It now returns all 10 table types (as stored in sys.table_types) instead + of the previously 8 hardcoded table types. + For old MonetDB servers which do not have the sys.table_types table, + the old behavior is retained. + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Implemented methods DatabaseMetadata.getProcedures() and + DatabaseMetadata.getProcedureColumns(). They used to return an empty resultset. + Now they return the expected Procedures and ProcedureColumns. + Also getProcedureColumns() now returns a resultset with all 20 columns + instead of 13 columns previously. + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Method getFunctionColumns() in DatabaseMetadata used to throw an + SQLException: getFunctionColumns(String, String, String, String) is + not implemented. + This method is now implemented and returns a resultset. + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Method getFunctions() in DatabaseMetadata used to throw an SQLException: + SELECT: no such column 'functions.sql' + This has been corrected. It now returns a resultset as requested. +- java: The resultsets of DatabaseMetadata methods now no longer return a + value for the *_CAT columns as MonetDB does not support Catalogs. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- buildtools: Implemented a systemd configuration file for a monetdbd.service + on systems that support it (Fedora, newer Ubuntu). + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: Removed BATmmap. It was no longer used. + +* Tue Apr 5 2016 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.23.1-20160601 +- java: Fixed a memory leak in MonetDatabaseMetaData.java for a static cache + which kept references to closed Connection objects. + +* Tue Apr 5 2016 Martin Kersten <m...@cwi.nl> - 11.23.1-20160601 +- monetdb5: The :bat[:oid,:any] type descriptor has been turned into its columnar + version :bat[:any] + +* Tue Apr 5 2016 Martin Kersten <m...@cwi.nl> - 11.23.1-20160601 +- monetdb5: Converted the *.mal scripts into *.malC versions to prepare for removal + of the mserver console. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: BUNdelete and BATdel don't accept a foce argument and only allow + deleting values that have not yet been committed. BUNdelete exchanges + the deleted value with the last value (if the deleted value isn't the + last value). BATdel compacts the BAT by shifting values after the + deleted values up. The list of to-be-deleted values in BATdel must + be sorted and unique. +- gdk: Removed BUNreplace from list of exported functions. It wasn't used, + and there is still BUNinplace and void_inplace that do more-or-less + the same thing. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: Changed BATderiveHeadProps to BATderiveTailProps (and it now works on + the tail column). +- gdk: Removed unused functions BATalpha, BATdelta, and BATprev. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- monetdb5: Removed functions mat.hasMoreElements, mat.info, mat.mergepack, + mat. newIterator, mat.project, mat.pack2, mat.sortReverse, mat.sort, + and mat.slice. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: Removed function VIEWcombine. Use BATdense instead. +- gdk: Removed "left" parameter from BUNinplace. It wasn't used since the + BAT it works on is dense headed. +- gdk: Created function BATdense to easily create a [void,void] BAT with + specified seqbases for head and tail and a count. +- gdk: Removed function BATmark. When all head columns are dense, BATmark + basically only created a new [void,void] BAT. +- gdk: Renamed BATsubsort to BATsort. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- monetdb5: Removed grouped aggregate functions from the aggr module in which the + groups were indicated by the head column of the bat to be aggregated. + Use the interface with a separate group bat instead. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- monetdb5: The server now stops executing a query when the client disconnects. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: Removed "sub" from the names of the function BATsubselect, + BATthetasubselect, BATsubcross, BATsubleftjoin, BATsubouterjoin, + BATsubthetajoin, BATsubsemijoin, BATsubdiff, BATsubjoin, BATsubbandjoin, + BATsubrangejoin, and BATsubunique. +- gdk: Removed BATsubleftfetchjoin: it was not used. +- gdk: Removed BATcross1. Use BATsubcross instead. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- monetdb5: Removed algebra.join. Use algebra.subjoin instead. +- monetdb5: Removed algebra.antijoin. Use algebra.subantijoin or + algebra.subthetajoin instead. + +* Tue Apr 5 2016 Martin Kersten <m...@cwi.nl> - 11.23.1-20160601 +- monetdb5: The MAL function 'leftfetchjoin' is renamed to its relational algebra + version 'projection' + +* Tue Apr 5 2016 Martin Kersten <m...@cwi.nl> - 11.23.1-20160601 +- monetdb5: The generic property handling scheme has been removed. It was used in + just a few places, for widely different purposes and contained cruft. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- monetdb5: Removed functions str.iconv and str.codeset. Internally, strings are + always in UTF-8 encoding, so we can't allow code set conversions. + +* Tue Apr 5 2016 Jennie Zhang <y.zh...@cwi.nl> - 11.23.1-20160601 +- sql: Disallow GRANT <some-user> TO <role-or-use>. Only explicitly + created roles can be granted. + +* Tue Apr 5 2016 Jennie Zhang <y.zh...@cwi.nl> - 11.23.1-20160601 +- sql: Extended grantable schema privileges: when a user is granted the + "sysadmin" role, the user now hcan not only create schemas, but + also drop schemas. +- sql: Introduced COPY INTO/ COPY FROM global privileges. These privileges + allows other users than 'monetdb' to be granted the privileges + to use the MonetDB bulk data loading/exporting features, i.e., + COPY FROM <file> and COPY INTO <file>. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: Removed all versions of the SORTloop macro. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- monetdb5: Removed algerbra.like with a BAT argument. Use algebra.likesubselect + instead. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: Removed Batkdiff. Use BATsubdiff instead. + +* Tue Apr 5 2016 Sjoerd Mullender <sjo...@acm.org> - 11.23.1-20160601 +- gdk: Removed BATselect. Use BATsubselect instead. +- gdk: Removed BATsemijoin. Use BATsubsemijoin instead. +- gdk: Removed BATjoin. Use BATsubjoin instead. +- gdk: Removed BATleftjoin. Use BATsubleftjoin or BATproject instead. +- gdk: Removed BATleftfetchjoin. Use BATproject instead. _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
