annotate ChangeLog @ 768:a80c21fe7bb2

Removed deprecated nl.cwi.monetdb.*.* classes and package. Those classes were marked deprecated on 12 Nov 2020 from release 3.0 (released on 17 Feb 2021) onwards. It includes: nl.cwi.monetdb.client.JdbcClient.class nl.cwi.monetdb.jdbc.MonetDriver.class nl.cwi.monetdb.jdbc.types.INET.class nl.cwi.monetdb.jdbc.types.URL.class nl.cwi.monetdb.mcl.net.MapiSocket.class These classes are now removed permanently. Use the org.monetdb.* equivalents instead.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 06 Jul 2023 15:35:04 +0200 (21 months ago)
parents 1547843b3a9b
children e029af7551b7
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
767
1547843b3a9b Removed code to support old MonetDB servers Oct2014 or older.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 764
diff changeset
4 * 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
5 - 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
6 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
7 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
8 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
9 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
10 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
11 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
12 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
13 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
14 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
15
a80c21fe7bb2 Removed deprecated nl.cwi.monetdb.*.* classes and package.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 767
diff changeset
16 * 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
17 - 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
18 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
19 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
20 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
21 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
22 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
23
764
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
24 * 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
25 - Corrected implementation of Connection methods getClientInfo() and
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
26 setClientInfo(). They used to get/set Connection properties instead
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
27 of Client Info properties which was a incorrect. MonetDB does not
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
28 support Client Info properties.
052c23fbfab2 Corrected implementation of Connection methods getClientInfo() and setClientInfo().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 757
diff changeset
29
757
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
30 * 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
31 - Corrected DatabaseMetaData method getClientProperties().
7f68120de37c Corrected DatabaseMetaData method getClientProperties().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 755
diff changeset
32 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
33
755
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
34 * 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
35 - 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
36 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
37 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
38
739
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
39 * Thu Feb 23 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
40 - Compiled and released new jar files: monetdb-jdbc-3.3.jre8.jar and
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
41 jdbcclient.jre8.jar
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
42
730
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
43 * Thu Feb 9 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
44 - Corrected DatabaseMetaData.getSQLKeywords() output. It used to return
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
45 all MonetDB SQL keywords, but now it excludes the SQL:2003 keywords
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
46 as defined by the Java JDBC API specification.
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
47
724
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
48 * Thu Jan 19 2023 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
49 - Corrected DatabaseMetaData.getUDTs() output. It used to return rows
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
50 for system types: inet, json, url and uuid. However those are not User
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
51 Defined Types. Now they are no longer returned by this method.
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
52
704
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
53 * Thu Dec 8 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
54 - Internal method waitForPrompt() of class BufferedMCLReader has been
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
55 renamed to discardRemainder(). The example program SQLcopyinto.java
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
56 which uses this method, has been updated.
5d6c577e2f74 Add a ChangeLog entry for change of method name in a MonetDB specific class.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 691
diff changeset
57
691
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
58 * Thu Nov 17 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
59 - Fixed an invalid error issue when a PreparedStatement had more than 250
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
60 parameters. See also https://github.com/MonetDB/MonetDB/issues/7337
fb55e62c50f3 Fixed an invalid error issue when a PreparedStatement had more than 250 parameters.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 682
diff changeset
61
682
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
62 * Thu Nov 3 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
63 - Corrected returned SQL TypeName values for the MonetDB interval types:
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
64 'day_interval', 'month_interval' and 'sec_interval'. Those MonetDB
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
65 type names can not be used in CREATE TABLE statements. Instead
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
66 one has to use SQL type names: 'interval day', 'interval month' or
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
67 'interval second'. The JDBC driver now returns those SQL type names.
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
68 This applies to methods: DatabaseMetaData.getTypeInfo() for the output
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
69 column TYPE_NAME (the output column LOCAL_TYPE_NAME now returns
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
70 the original type name), ResultSetMetaData.getColumnTypeName() and
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
71 ParameterMetaData.getParameterTypeName().
78253fdb3c3f Corrected returned SQL TypeName values for the MonetDB interval types: 'day_interval', 'month_interval' and 'sec_interval'.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 672
diff changeset
72
667
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
73 * Thu Oct 27 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
74 - Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(),
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
75 getMetaData().getPrecision() and getParameterMetaData().getPrecision().
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
76
665
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
77 * Thu Oct 20 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
78 - Improved implementation of method ResultSetMetaData.getPrecision(). It
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
79 now returns more accurate values for columns of type DECIMAL, NUMERIC,
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
80 CHAR, VARCHAR, CLOB, JSON, URL and BLOB.
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
81 - Improved implementation of method ResultSetMetaData.getScale(). It now
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
82 returns more accurate values for columns of type DECIMAL and NUMERIC.
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
83
659
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
84 * Thu Sep 29 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
85 - Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
86 Programmers who used this jar file should use monetdb-jdbc-3.#.jre8.jar file.
0b564ae68ac1 Removed creation and distribution of monetdb-mcl-1.##.jre8.jar file.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 652
diff changeset
87
672
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
88 * Fri Sep 09 2022 Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
89 - Add autocommit=true/false option to the JDBC URL. The default remains 'true'.
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
90
652
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
91 * Wed Aug 24 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
92 - Improved DatabaseMetaData.getBestRowIdentifier(). When there are multiple
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
93 unique constraints and no pkey for a table it used to return the columns
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
94 of all the table unique constraints. Now it only returns the columns of
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
95 the first table unique constraint.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
96 Also optimized the performance of getBestRowIdentifier(). It used to
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
97 send a separate query first to find out if the table had a pkey or not.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
98 This extra query is now integrated so less queries are send to the server.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
99
645
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
100 * Wed Mar 30 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
101 - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
648
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
102 and getIndexInfo() for local temporary tables located in schema tmp. They
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
103 did not return any rows when the temp table had a primary or unique key or
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
104 index. Now they do return rows as expected.
645
fbed03097738 Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier() and getIndexInfo() for temporary tables in schema tmp.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 642
diff changeset
105
642
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
106 * Thu Feb 10 2022 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
107 - Added recognition of 'xml' type. Use default mapping to Types.VARCHAR for
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
108 easy and fast (as java.lang.String) retrieval, display and setting data of
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
109 columns of type 'xml'.
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
110
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
111 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
112 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
113