diff ChangeLog-Archive @ 0:a5a898f6886c

Copy of MonetDB java directory changeset e6e32756ad31.
author Sjoerd Mullender <sjoerd@acm.org>
date Wed, 21 Sep 2016 09:34:48 +0200 (2016-09-21)
parents
children a6608e9581c1
line wrap: on
line diff
new file mode 100644
--- /dev/null
+++ b/ChangeLog-Archive
@@ -0,0 +1,404 @@
+# DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY
+# This file contains past ChangeLog entries
+
+* Thu Jul  7 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.7-20160713
+- Corrected PROCEDURE_TYPE output value of method DatabaseMetaData.getProcedures().
+  It used to return procedureReturnsResult. Now it returns procedureNoResult.
+  Corrected ORDINAL_POSITION output value of method DatabaseMetaData.getProcedureColumns().
+  It used to start with 0, but as procedures do not return a result value it now
+  starts with 1 for all the procedure arguments, as defined by the JDBC API.
+- Improved output of method DatabaseMetaData.getProcedures(). The REMARKS
+  column now contains the procedure definition as stored in sys.functions.func.
+  The SPECIFIC_NAME column now contains the procedure unique identifier as
+  stored in sys.functions.id. This allows the caller to retrieve the specific
+  overloaded procedure which has the same name, but different arguments.
+  Also improved output of method DatabaseMetaData.getProcedureColumns().
+  The SPECIFIC_NAME column now contains the procedure unique identifier as
+  stored in sys.functions.id. This allows the caller to retrieve the proper
+  arguments of the specific overloaded procedure by matching the SPECIFIC_NAME
+  value.
+- Improved output of method DatabaseMetaData.getFunctions(). The REMARKS
+  column now contains the function definition as stored in sys.functions.func.
+  The SPECIFIC_NAME column now contains the function unique identifier as
+  stored in sys.functions.id. This allows the caller to retrieve the specific
+  overloaded function which has the same name, but different arguments.
+  Also improved output of method DatabaseMetaData.getFunctionColumns().
+  The SPECIFIC_NAME column now contains the function unique identifier as
+  stored in sys.functions.id. This allows the caller to retrieve the proper
+  arguments of the specific overloaded function by matching the SPECIFIC_NAME
+  value.
+
+* Thu May 26 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+
+* Sun May  8 2016 Jennie Zhang <y.zhang@cwi.nl> - 11.23.1-20160601
+- 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.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- Fixed resource leak in ResultSetMetaData. It created and cached a ResultSet
+  object for each column but never closed the ResultSet objects.
+
+* Thu Mar 31 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+- Corrected output of column KEY_SEQ of DatabaseMetaData methods:
+  getPrimaryKeys(), getImportedKeys(), getExportedKeys() and
+  getCrossReference(). It now starts at 1 instead of 0 previously.
+
+* Thu Mar 24 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- Corrected DatabaseMetaData.getSchemas() by returning 2 instead of 3 columns.
+- Improved DatabaseMetaData.getColumns() by returning two additional
+  columns: IS_AUTOINCREMENT and IS_GENERATEDCOLUMN.
+
+* Thu Mar 17 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+- Corrected DatabaseMetaData.getPseudoColumns(). It used to return 12 empty rows.
+  Now it returns no rows as MonetDB does not have pseudo columns.
+
+* Thu Mar  3 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+- 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.
+
+* Thu Feb 18 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+
+* Thu Feb 11 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+
+* Thu Feb  4 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+
+* Thu Jan 28 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+- The resultsets of DatabaseMetadata methods now no longer return a
+  value for the *_CAT columns as MonetDB does not support Catalogs.
+
+* Thu Jan  7 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- Fixed a memory leak in MonetDatabaseMetaData.java for a static cache
+  which kept references to closed Connection objects.
+
+* Thu May 12 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- 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.
+
+* Thu May 12 2016 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.23.1-20160601
+- Corrected MonetResultSet.getObject(String columnName). It no longer
+  throws a NullPointerException in cases where internally a
+  MonetVirtualResultSet is used.
+
+* Sun May  8 2016 Jennie Zhang <y.zhang@cwi.nl> - 11.23.1-20160601
+- Fixed Connection.isValid(): this method should never attempt to
+  close the connection, even if an error has occurred.
+
+* Thu Aug  6 2015 Martin van Dinther <martin.van.dinther@monetdbsolutions.com> - 11.21.1-20150807
+- Improved JDBC driver to not throw NullPointerException anymore
+  when calling isNullable() or getPrecision() or getScale() or
+  getColumnDisplaySize() or getSchemaName() or getTableName() or
+  getColumnClassName() on a ResultSetMetaData object.
+
+* Thu Jul 16 2015 Sjoerd Mullender <sjoerd@acm.org> - 11.21.1-20150807
+- We now compile the Java classes using the latest Java 1.8 version, and
+  we tell it to compile for Java 1.7.
+
+* Mon Oct  7 2013 Sjoerd Mullender <sjoerd@acm.org> - 11.15.17-20131008
+- Rearranged order of returned columns of certain metadata functions to
+  comply with the JDBC documentation.  See bug 3356.
+
+* Sun Jun  9 2013 Fabian Groffen <fabian@monetdb.org> - 11.15.9-20130619
+- Further improved setBigDecimal() method, based on patch by Ben Reilly
+  in bug #3290
+
+* Thu May 23 2013 Fabian Groffen <fabian@monetdb.org> - 11.15.9-20130619
+- Fixed bug where PreparedStatement.setBigDecimal() wouldn't format its
+  input well enough for the server causing odd errors.
+- Allow PreparedStatement.setXXX() methods to be called with null
+  arguments, bug #3288
+
+* Thu Apr 11 2013 Sjoerd Mullender <sjoerd@acm.org> - 11.15.5-20130412
+- The pre-compiled .jar files are now created using Java 7 instead of
+  Java 6.
+
+* Sat Dec  1 2012 Fabian Groffen <fabian@monetdb.org> - 11.15.1-20130212
+- merocontrol was changed to return server URIs, and lastStop time.
+  Connections and dbpath were removed.
+- Mapi protocol v8 support was removed from MapiSocket.  Protocol
+  v8 has not been used by the servers any more since Apr2012 release
+
+* Fri Nov 23 2012 Fabian Groffen <fabian@monetdb.org> - 11.13.7-20121212
+- Implemented type map support of Connection to allow custom mapping
+  of UDTs to Java classes.  By default the INET and URL UDTs are
+  now mapped to nl.cwi.monetdb.jdbc.types.{INET,URL}.  Most notably,
+  ResultSet.getObject() and PreparedStatement.setObject() deal with the
+  type map.
+
+* Thu Nov 22 2012 Fabian Groffen <fabian@monetdb.org> - 11.13.7-20121212
+- Fixed a problem in PreparedStatement where the prepared statement's
+  ResultSetMetaData (on its columns to be produced) incorrectly threw
+  exceptions about non existing columns.  Bug #3192
+
+* Wed Oct 10 2012 Fabian Groffen <fabian@cwi.nl> - 11.13.3-20121016
+- Fixed problem with PreparedStatements and setXXX() methods using column
+  numbers instead of names, bug #3158
+
+* Tue Aug 14 2012 Fabian Groffen <fabian@cwi.nl> - 11.11.9-20120911
+- Fixed a bug where DatabaseMetaData.getURL() did return null:0 for
+  hostname:port.
+
+* Fri Jul 20 2012 Fabian Groffen <fabian@cwi.nl> - 11.11.7-20120813
+- Fixed adaptive cache size used when retrieving results, not to cause
+  divide by zero errors when memory gets short, bug #3119.
+
+* Fri Mar  2 2012 Wouter Alink <wouter@spinque.com> - 11.9.1-20120418
+- Password reading by JdbcClient no longer results in strange artifacts
+- JdbcClient now returns exit code 1 in case of failures
+
+* Tue Feb 28 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.9-20120312
+- Implemented missing Number types support in
+  PreparedStatement.setObject()
+
+* Mon Feb 20 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.7-20120224
+- Fixed bug in DatabaseMetaData.getSchemas() method that caused an SQL
+  error when called with catalog and schema argument.
+
+* Tue Feb 14 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.7-20120224
+- Resolved a bug where JDBC and Control connections could terminate
+  abruptly with 'Connection closed' messages
+
+* Mon Jan  2 2012 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- Implemented getMetaData() method of PreparedStatement.
+
+* Tue Dec 27 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- Fixed an AssertionError for special results from e.g. EXPLAIN queries.
+
+* Wed Dec 21 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- Fixed overflow error when batching large statements, bug #2952
+
+* Tue Dec 20 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- Resolved a concurrency problem where ResultSet's date-related getters
+  could cause odd stack traces when used by multiple threads at the
+  same time, bug #2950.
+
+* Mon Dec 19 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- JDBC now implements JDBCv4.1 which makes it possible to be built with
+  Java 7 and up.  JDBCv4.1 is a maintenance release of JDBCv4, and hence
+  can be compiled with Java 6, although the added methods obviously are
+  not part of the java.sql interfaces.
+
+* Sun Dec 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- SQLExceptions thrown now carry a SQLSTATE.  Until the server starts
+  sending correct SQLSTATEs for all errors, server originated errors
+  without SQLSTATE are considered generic data exceptions (22000).
+
+* Sat Dec 10 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- Fixed a bug where closing ResultSets and PreparedStatements could lead
+  to errors on concurrent running queries using the same Connection due
+  to a race condition.
+
+* Thu Dec  8 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- Changed version scheme of JDBC driver and MCL jar to be more standard,
+  from monetdb-X.Y-<thing>.jar to monetdb-<thing>-X.Y.jar, bug #2943
+
+* Fri Oct 14 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- The embedded monet instance capability of MonetConnection was removed.
+- Bump JDBC version to 2.0 (Liberica).  JDBC now implements JDBCv4 which
+  makes it possible to be built with Java 6 and up.  Java 5 and before
+  are no longer supported, and can use the 1.x releases of the driver.
+
+* Thu Sep  1 2011 Fabian Groffen <fabian@cwi.nl> - 11.7.1-20120111
+- INTERVAL columns are now treated as decimals, since they can have
+  sub-second precision.
+
+* Thu Jun 30 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
+- Add so_timeout Driver property to specify a SO_TIMEOUT value for the
+  socket in use to the database.  Setting this property to a value in
+  milliseconds defines the timeout for read calls, which may 'unlock'
+  the driver if the server hangs, bug #2828
+
+* Wed May 25 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
+- Added a naive implementation for PreparedStatement.setCharacterStream
+
+* Mon Apr 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.5.1-20110907
+- The obsolete Java-based implementation for PreparedStatements (formerly
+  activated using the java_prepared_statements property) has been dropped
+
+* Fri Jul  8 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.5-20110720
+- Return false from Statement.getMoreResults() instead of a
+  NullPointerException when no query has been performed on the Statement
+  yet, bug #2833
+
+* Mon Jun  6 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.5-20110720
+- Fixed read-only interpretation.  Connection.isReadOnly now always
+  returns false, setReadOnly now generates a warning when called with
+  true.  Partly from bug #2818
+- Allow readonly to be set when autocommit is disabled as well.  Bug #2818
+
+* Wed May 11 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.3-20110517
+- Insertion via PreparedStatement and retrieval via ResultSet of timestamp
+  and time fields with and without timezones was improved to better
+  respect timezones, as partly indicated in bug #2781.
+
+* Tue Apr  5 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.1-20110414
+- clarify exception messages for unsupported methods
+
+* Mon Feb  7 2011 Fabian Groffen <fabian@cwi.nl> - 11.3.1-20110414
+- Removed XQuery related XRPC wrapper and XML:DB code, removed support
+  for language=xquery and language=mil from JDBC.
+
+* Wed Dec 15 2010 Fabian Groffen <fabian@cwi.nl> - 11.1.1-20110317
+- PreparedStatements now free the server-side resources attached to them
+  when closed.  This implements bug #2720
+
+* Tue Nov  9 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101110
+- Fix SQL syntax of inserting BLOB code, using setBytes()
+- Added propery 'treat_blob_as_binary' to simulate BINARY types based on
+  BLOBs for applications, (e.g. Hibernate-based) that rely on BINARY's
+  byte array mapping
+- Added code to handle BINARY types
+- Fixed implementation of getBytes to match the specifications
+- Implemented getBinaryStream according to the specifications
+
+* Mon Nov  8 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101109
+- Java 1.6's subSequence() bug has changed into a slice() bug since
+  1.6.0_22.  Revert workaround for subSequence breakage, since it breaks
+  operating with the latest Java 1.6.
+
+* Fri Oct 22 2010 Fabian Groffen <fabian@cwi.nl> - 1.40.1-20101029
+- Fix for bug #2703, allow to have multiple metadata ResultSets open at
+  the same time
+
+* Wed Aug 11 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
+- Implemented ResultSet's getCharacterStream methods, since Hibernate seems to
+  call this method for retrieving CLOB columns that we now do support.
+
+* Fri Aug 06 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
+- Fix implementation of setBytes method of PreparedStatement, such that bytes
+  are converted to MonetDB/SQL's BLOB notation.
+
+* Wed Jul 21 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
+- merocontrol Java library requires Java 2 Platform 1.5 and up, due to enum
+  and boxing/unboxing. Bug #2627
+
+* Tue Jul 20 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
+- Implement missing Blob support (readonly), since getObject will blindly
+  return a BLOB instance as String, which is causing applications to wrongly
+  believe a BLOB instance is a string.
+
+* Fri Jul 16 2010 Fabian Groffen <fabian@cwi.nl> - 1.38.5-20100823
+- Fix problem when using the MAL language.  Any statement would return
+  an error with a typo that was not typed in by the user, such as
+  ioo.printf when io.printf was typed.
+
+* Fri Apr 16 2010 Fabian Groffen <fabian@cwi.nl> - Jun2010-SP1
+- Enable the merovingian control library for default distribution as it
+  has been in use for some time without problems now.
+
+* Wed Mar 31 2010 Stefan Manegold <manegold@cwi.nl> - Jun2010-SP1
+- Made compilation of "testing" (and "java") independent of MonetDB.
+  This is mainly for Windows, but also on other systems, "testing" can now be
+  built independently of (and hence before) "MonetDB".
+  Files that mimic configure functionality on Windows were moved from
+  "MonetDB" to "buildtools"; hence, this affects all packages on Windows,
+  requiring a complete rebuild from scratch on Windows.
+  getopt() support in testing has changed; hence, (most probably) requiring a
+  rebuild from scratch of testing on other systems.
+
+* Wed Mar 31 2010 Fabian Groffen <fabian@cwi.nl> - Feb2010-SP2
+- Do not to throw an SQLException, but generate a warning and try to
+  perform as much as requested in an optimistic manner, as not to break
+  clients that rely on the called method, but don't really use its
+  functionality (such as high-level generic programs that call any
+  driver and try to put it in a mode that it does what they expect).
+  The following functions no longer throw an SQLException but now
+  generate a warning and perform actions as far as possible:
+  - Statement.execute(sql, columnIndexes/columnNames)
+  - Statement.executeUpdate(sql, columnIndexes/columnNames)
+  - Statement.getMaxFieldSize()
+  - Statement.setCursorName(name)
+  - Statement.setEscapeProcessing(enable)
+  - Statement.setMaxFieldSize(max)
+  - Statement.setQueryTimeout(seconds)
+  - PreparedStatement.getMetaData()
+  - PreparedStatement.setNull(paramIndex, sqlType, typeName)
+
+* Wed Mar 24 2010 Stefan Manegold <manegold@cwi.nl> - Jun2010-SP1
+- Implemented build directory support for Windows,
+  i.e., like on Unix/Linux also on Windows we can now build in a separate
+  build directory as alternative to ...\<package>\NT, and thus keep the
+  latter clean from files generated during the build.
+  On Windows, the build directory must be a sibling of ...\<package>\NT .
+
+* Tue Mar 09 2010 Fabian Groffen <fabian@cwi.nl> - Feb2010-SP1
+- Set JAVA_HOME to the configure derived value, such that ant will use
+  the javac compiler as found by configure, and not the one it was built
+  with itself.  This solves the problem that the JDBC driver still fails
+  to compile on e.g. Fedora systems even though configure
+  --with-java=/path/to/sun/jdk-5 was given, because ant still uses
+  gjc/icedtea by itself.
+
+* Mon Oct 12 2009 Wouter Alink <w.alink@cwi.nl> - Aug2009-SP2
+- Bump MCL version to 1.6 for fix.
+
+* Fri Oct 09 2009 Fabian Groffen <fabian@cwi.nl> - Feb2010
+- Bump Java source version to 1.5.  Java 1.5 is the current J2EE, and code
+  from nl.cwi.monetdb.merovingian relies on Java 1.5 features.  It seems
+  like a good time to deprecate 1.4 now 1.6 is about to become the new
+  J2EE version.
+
+* Fri Oct 09 2009 Wouter Alink <w.alink@cwi.nl> - Aug2009-SP2
+- applied workaround for bug in Sun JRE 1.6.
+
+* Thu Oct 01 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP2
+- Bump JDBC version to 1.14 for fix.
+
+* Thu Oct 01 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP2
+- Fix warning messages to disappear when a connection to merovingian is
+  made.
+
+* Sun Aug 23 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP1
+- Bump JDBC version to 1.13 for fix.
+
+* Sun Aug 23 2009 Fabian Groffen <fabian@cwi.nl> - Aug2009-SP1
+- Avoid "ResultSet is closed" messages by disabling the use of
+  finalizers, bug #2844202
+
+* Thu Mar 26 2009 Fabian Groffen <fabian@cwi.nl> - Feb2010
+- Fix configure handling for --enable-{jdbc,xrpc}, by Yue Sheng on
+  Monetdb-developers ML
+