Mercurial > hg > monetdb-java

annotate ChangeLog @ 755:99ff3cd9f4f0

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server. It now includes the string functions from the new txtsim module.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 04 May 2023 01:28:52 +0200 (23 months ago)
parents 01da1ea91c3f
children 7f68120de37c
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
755
99ff3cd9f4f0 Corrected DatabaseMetaData method getStringFunctions() when connected to a Jun2023 server.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 739
diff changeset
4 * 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
5 - 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
6 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
7 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
8
739
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
9 * 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
10 - 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
11 jdbcclient.jre8.jar
01da1ea91c3f Update ChangeLog in preparation of new release.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 732
diff changeset
12
730
ee061ab9ee32 Corrected DatabaseMetaData.getSQLKeywords() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 724
diff changeset
13 * 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
14 - 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
15 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
16 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
17
724
2b763b189452 Corrected DatabaseMetaData.getUDTs() output.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 704
diff changeset
18 * 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
19 - 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
20 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
21 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
22
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
23 * 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
24 - 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
25 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
26 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
27
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
28 * 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
29 - 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
30 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
31
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
32 * 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
33 - 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
34 '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
35 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
36 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
37 '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
38 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
39 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
40 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
41 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
42
667
ed3d0c1a60cf Corrected PreparedStatement methods getMetaData().getColumnDisplaySize(), getMetaData().getPrecision() and getParameterMetaData().getPrecision().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 665
diff changeset
43 * 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
44 - 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
45 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
46
665
8f7d51c478df Improved implementation of methods ResultSetMetaData.getPrecision() and ResultSetMetaData.getScale().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 659
diff changeset
47 * 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
48 - 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
49 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
50 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
51 - 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
52 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
53
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
54 * 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
55 - 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
56 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
57
672
cd6193bc5956 Update ChangeLog
Joeri van Ruth <joeri.van.ruth@monetdbsolutions.com>
parents: 667
diff changeset
58 * 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
59 - 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
60
652
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
61 * 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
62 - 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
63 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
64 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
65 the first table unique constraint.
6a34d2c36dec Improved and optimized DatabaseMetaData.getBestRowIdentifier().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 648
diff changeset
66 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
67 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
68 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
69
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
70 * 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
71 - Corrected DatabaseMetaData methods getPrimaryKeys(), getBestRowIdentifier()
648
03e0f577db00 Improve ChangeLog text.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 645
diff changeset
72 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
73 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
74 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
75
642
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
76 * 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
77 - 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
78 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
79 columns of type 'xml'.
dd9b4fb14256 Added recognition of 'xml' type.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 636
diff changeset
80
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
81 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
82 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
83