Mercurial > hg > monetdb-java

annotate ChangeLog @ 887:674f9ed21308

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types. Also extended test Test_Interval_Types() to test all 13 interval types, both as result column and as parameter.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 04 Apr 2024 12:56:33 +0200 (12 months ago)
parents cd6e5449fb1a
children 549225b7be85
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
89
a6608e9581c1 Moved content of ChangeLog to ChangeLog-Archive.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 53
diff changeset
1 # ChangeLog file for monetdb-java
0
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
2 # This file is updated with Maddlog
a5a898f6886c Copy of MonetDB java directory changeset e6e32756ad31.
Sjoerd Mullender <sjoerd@acm.org>
parents:
diff changeset
3
887
674f9ed21308 Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 882
diff changeset
4 * Thu Apr 4 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
674f9ed21308 Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 882
diff changeset
5 - Improved ResultSetMetaData.getColumnTypeName() and
674f9ed21308 Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 882
diff changeset
6 ParameterMetaData.getParameterTypeName() for interval types. It now
674f9ed21308 Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 882
diff changeset
7 returns more precise information for the interval data types.
674f9ed21308 Improved ResultSetMetaData.getColumnTypeName() and ParameterMetaData.getParameterTypeName() for interval types. It now returns more precise information for the 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 882
diff changeset
8
882
cd6e5449fb1a Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial and bigserial data types and all 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 856
diff changeset
9 * Thu Mar 7 2024 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
cd6e5449fb1a Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial and bigserial data types and all 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 856
diff changeset
10 - Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial
cd6e5449fb1a Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial and bigserial data types and all 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 856
diff changeset
11 and bigserial data types and all 13 possible interval data types.
cd6e5449fb1a Improved DatabaseMetaData.getTypeInfo(). It now also returns the serial and bigserial data types and all 13 possible interval data types.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 856
diff changeset
12
832
7eb05cbf67dc In ResultSet.getObject(column, Class<T> type) and ResultSet.getObject(column, Map<String,Class<?>>) methods added support to return objects for classes: java.time.LocalDate, java.time.LocalDateTime.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
13 * Thu Dec 28 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
7eb05cbf67dc In ResultSet.getObject(column, Class<T> type) and ResultSet.getObject(column, Map<String,Class<?>>) methods added support to return objects for classes: java.time.LocalDate, java.time.LocalDateTime.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
14 - In ResultSet.getObject(column, Class<T> type) and
7eb05cbf67dc In ResultSet.getObject(column, Class<T> type) and ResultSet.getObject(column, Map<String,Class<?>>) methods added support to return objects for classes: java.time.LocalDate, java.time.LocalDateTime.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
15 ResultSet.getObject(column, Map<String,Class<?>>) methods added support
7eb05cbf67dc In ResultSet.getObject(column, Class<T> type) and ResultSet.getObject(column, Map<String,Class<?>>) methods added support to return objects for classes: java.time.LocalDate, java.time.LocalDateTime.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
16 to return objects for classes: java.time.LocalDate, java.time.LocalDateTime
7eb05cbf67dc In ResultSet.getObject(column, Class<T> type) and ResultSet.getObject(column, Map<String,Class<?>>) methods added support to return objects for classes: java.time.LocalDate, java.time.LocalDateTime.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
17 and java.time.LocalTime.
7eb05cbf67dc In ResultSet.getObject(column, Class<T> type) and ResultSet.getObject(column, Map<String,Class<?>>) methods added support to return objects for classes: java.time.LocalDate, java.time.LocalDateTime.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 827
diff changeset
18
827
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
19 * Wed Dec 20 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
20 - Enhanced DatabaseMetaData.getTables() method by adding support for SQL
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
21 table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY'
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
22 in parameter types[]. These are SQL synonyms of MonetDB table type names:
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
23 'TABLE', 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE'.
b2cbe866d020 Enhanced DatabaseMetaData.getTables() method by adding support for SQL table type names: 'BASE TABLE', 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter types[].
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 823
diff changeset
24
820
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
25 * Thu Dec 14 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
26 - In ResultSet.getObject() method added support for retrieving
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
27 TIMESTAMP WITH TIME ZONE data as java.time.OffsetDateTime object
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
28 and TIME WITH TIME ZONE as java.time.OffsetTime object.
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
29 Also methods ResultSetMetaData.getColumnClassName() and
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
30 ParameterMetaData.getParameterClassName() now return
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
31 java.time.OffsetDateTime.class for columns of type TIMESTAMP WITH TIME ZONE
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
32 and java.time.OffsetTime.class for columns of type TIME WITH TIME ZONE.
4c35009cd59c In ResultSet.getObject() method added support for retrieving
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 781
diff changeset
33
781
71d32f1a4d60 Improved DatabaseMetaData.getSystemFunctions(). It now also returns functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min. Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
34 * Thu Oct 12 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
71d32f1a4d60 Improved DatabaseMetaData.getSystemFunctions(). It now also returns functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min. Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
35 - Improved DatabaseMetaData.getSystemFunctions(). It now also returns
71d32f1a4d60 Improved DatabaseMetaData.getSystemFunctions(). It now also returns functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min. Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
36 functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min.
71d32f1a4d60 Improved DatabaseMetaData.getSystemFunctions(). It now also returns functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min. Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
37 Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
71d32f1a4d60 Improved DatabaseMetaData.getSystemFunctions(). It now also returns functions: current_sessionid, greatest, ifnull, least, sql_max, sql_min. Function ifnull will only be returned for servers Jun2023 (11.47 or higher).
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 774
diff changeset
38
774
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
39 * Wed Aug 9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
40 - Implemented ResultSet methods:
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
41 <T> T getObject(int columnIndex, Class<T> type)
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
42 <T> T getObject(String columnLabel, Class<T> type)
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
43 They used to throw an SQLFeatureNotSupportedException.
e029af7551b7 Implemented ResultSet methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 768
diff changeset
44
767
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
45 * Thu Jul 6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
768
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
46 - Removed deprecated nl.cwi.monetdb.*.* classes and package.
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
47 Those classes were marked deprecated on 12 Nov 2020 from
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
48 release 3.0 (released on 17 Feb 2021) onwards. It includes:
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
49 nl.cwi.monetdb.client.JdbcClient.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
50 nl.cwi.monetdb.jdbc.MonetDriver.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
51 nl.cwi.monetdb.jdbc.types.INET.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
52 nl.cwi.monetdb.jdbc.types.URL.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
53 nl.cwi.monetdb.mcl.net.MapiSocket.class
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
54 These classes are now removed permanently.
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
55 Use the org.monetdb.* equivalents instead.
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
56
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
57 * Thu Jul 6 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
767
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
58 - Removed code to support old MonetDB servers Oct2014 or older. Those
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
59 old servers did not yet have the system tables: sys.keywords and
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
60 sys.table_types which are introduced in Jul2015 release. Those system
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
61 tables are used by MonetDatabaseMetaData methods: getSQLKeywords(),
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
62 getTableTypes() and getTables(). These 3 methods will now fail when
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
63 used with those very old MonetDB servers.
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
64
764
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
65 * Wed Jul 5 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
66 - Corrected implementation of Connection methods getClientInfo() and
823
d3f92fcd047c correct English
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 820
diff changeset
67 setClientInfo(). They used to get/set Connection properties instead of
d3f92fcd047c correct English
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 820
diff changeset
68 Client Info properties, which was incorrect. MonetDB does not support
d3f92fcd047c correct English
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 820
diff changeset
69 Client Info properties.
764
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
70
757
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
71 * Thu Jun 22 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
72 - Corrected DatabaseMetaData method getClientProperties().
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
73 It used to return connection properties instead of client info properties.
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
74
755
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
75 * Thu May 4 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
76 - Corrected DatabaseMetaData method getStringFunctions() when connected
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
77 to Jun2023 server. It now includes the string functions from the new
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
78 txtsim module.
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
79
476
5b99ca67825a Improve text in ChangeLog. Also remove old release 3.0 changes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 471
diff changeset
80 For a complete list of changes in previous monetdb-java releases see:
5b99ca67825a Improve text in ChangeLog. Also remove old release 3.0 changes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 471
diff changeset
81 https://www.monetdb.org/downloads/Java/archive/ChangeLog-Archive
606
f15df1ae41bc Remove old changes already from the ChangeLog.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 595
diff changeset
82