annotate ChangeLog @ 298:6db8f6702ce8

Improved MonetDatabaseMetaData methods: - getNumericFunctions(): it now includes functions: code, space and sys.alpha - getNumericFunctions(): it no longer lists functions: not_uniques and rotate_xor_hash - getStringFunctions(): it now includes functions: json.isarray, json.isobject, json.isvalid, sys.reverse which accept a string value as argument - getStringFunctions(): it no longer lists functions: copyfrom, get_value_for, next_value_for, restart. - getSystemFunctions(): it now includes system functions: get_value_for, hash, next_value_for, sys.columnsize, sys.debug, sys.hashsize, sys.heapsize, sys.imprintsize, sys.isauuid, sys.md5, sys.newurl, sys.password_hash, isaurl - getSystemFunctions(): it no longer lists function: getlimit. Also some functions require the prefix "sys." or "json." when used from another working schema. This is now included in the names returned by methods getNumericFunctions(), getStringFunctions(), getSystemFunctions() and getTimeDateFunctions().
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 14 Aug 2019 20:25:52 +0200 (2019-08-14)
parents 894abb249de1
children 5ddab9d8d3dd
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
298
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
4 * Wed Aug 14 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
5 - Improved MonetDatabaseMetaData methods:
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
6 - getNumericFunctions(): it now includes functions: code, space and sys.alpha
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
7 - getNumericFunctions(): it no longer lists functions: not_uniques and rotate_xor_hash
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
8 - getStringFunctions(): it now includes functions: json.isarray, json.isobject,
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
9 json.isvalid, sys.reverse which accept a string value as argument
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
10 - getStringFunctions(): it no longer lists functions: copyfrom, get_value_for, next_value_for, restart.
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
11 - getSystemFunctions(): it now includes system functions: get_value_for, hash,
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
12 next_value_for, sys.columnsize, sys.debug, sys.hashsize, sys.heapsize,
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
13 sys.imprintsize, sys.isauuid, sys.md5, sys.newurl, sys.password_hash, isaurl
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
14 - getSystemFunctions(): it no longer lists function: getlimit.
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
15 Also some functions require the prefix "sys." or "json." when used
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
16 from another schema. This is now included in the names returned by
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
17 methods getNumericFunctions(), getStringFunctions(), getSystemFunctions()
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
18 and getTimeDateFunctions().
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
19
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
20 * Wed Jul 31 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
294
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
21 - Corrected MonetDatabaseMetaData methods:
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
22 - getNumericFunctions(): it now includes function: pi.
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
23 - getSystemFunctions(): it no longer lists numeric functions: pi and rand.
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
24 - supportsSchemasInIndexDefinitions(): changed from true to false
290
d477b3103a8b Optimised MonetStatement memory resource usage by only creating an ArrayList and ReentrantLock object when the batch methods addBatch() or executeBatch() are called. In most Statement usages those methods are not called.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 289
diff changeset
25 - Optimised MonetStatement memory resource usage by only creating an ArrayList
d477b3103a8b Optimised MonetStatement memory resource usage by only creating an ArrayList and ReentrantLock object when the batch methods addBatch() or executeBatch() are called. In most Statement usages those methods are not called.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 289
diff changeset
26 and ReentrantLock object when the batch methods addBatch() or executeBatch()
294
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
27 are called. In most Statement usages those methods are never called.
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
28 - Implemented method MonetClob.getAsciiStream().
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
29
271
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 268
diff changeset
30 * Thu Mar 21 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 268
diff changeset
31 - Added implementation of java.sql.CallableStatement interface. Some standard
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 268
diff changeset
32 Java applications require this JDBC interface for executing SQL stored procedures.
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 268
diff changeset
33 This implementation resolves request: https://www.monetdb.org/bugzilla/show_bug.cgi?id=6402
4880267d0fe1 Added implementation of java.sql.CallableStatement interface, test program and updated the ChangeLog and release notes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 268
diff changeset
34
268
ee4c826e3933 Extended method getNumericFunctions() by also returning functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 265
diff changeset
35 * Thu Mar 7 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
ee4c826e3933 Extended method getNumericFunctions() by also returning functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 265
diff changeset
36 - Improved MonetDatabaseMetaData methods:
ee4c826e3933 Extended method getNumericFunctions() by also returning functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 265
diff changeset
37 - getNumericFunctions(): it now includes functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
ee4c826e3933 Extended method getNumericFunctions() by also returning functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 265
diff changeset
38 - getStringFunctions(): it now includes function: position.
ee4c826e3933 Extended method getNumericFunctions() by also returning functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 265
diff changeset
39 - supportsIntegrityEnhancementFacility() now returns false, as we do not enforce CHECK constraints yet.
ee4c826e3933 Extended method getNumericFunctions() by also returning functions: degrees, fuse, ms_round, ms_str, ms_trunc and radians.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 265
diff changeset
40
263
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
41 * Thu Feb 7 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
42 - Improved MonetDatabaseMetaData methods:
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
43 - getNumericFunctions(): it no longer lists aggregate functions: avg, prod and sum
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
44 - getSystemFunctions(): it no longer lists timedate function: extract
275
7d041f5c3fea In getTimeDateFunctions() also return newly added SQL function: date_trunc
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 271
diff changeset
45 - getTimeDateFunctions(): it now also lists functions: date_trunc, epoch
265
177f3d1a791d Corrected MonetDatabaseMetaData method getTypeInfo() for result column
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 263
diff changeset
46 - Corrected MonetDatabaseMetaData method getTypeInfo() for result column
177f3d1a791d Corrected MonetDatabaseMetaData method getTypeInfo() for result column
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 263
diff changeset
47 SEARCHABLE. It now returns DatabaseMetaData.typeSearchable for all
177f3d1a791d Corrected MonetDatabaseMetaData method getTypeInfo() for result column
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 263
diff changeset
48 string data types including 'inet','json','url','uuid' and 'blob'.
263
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
49
251
2b1f650869d6 Improved example program SQLcopyinto,java and added to tests directory for automatic testing
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 245
diff changeset
50 * Thu Sep 20 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
253
1b8277de9a7d Improve ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 251
diff changeset
51 - Improved example program SQLcopyinto.java and moved it to tests directory
1b8277de9a7d Improve ChangeLog
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 251
diff changeset
52 for automatic testing.
251
2b1f650869d6 Improved example program SQLcopyinto,java and added to tests directory for automatic testing
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 245
diff changeset
53
245
55375d489024 Corrected return values of DatabaseMetaData methods allTablesAreSelectable() and allProceduresAreCallable().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
54 * Thu Jun 28 2018 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
55375d489024 Corrected return values of DatabaseMetaData methods allTablesAreSelectable() and allProceduresAreCallable().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
55 - Corrected return values of DatabaseMetaData methods
55375d489024 Corrected return values of DatabaseMetaData methods allTablesAreSelectable() and allProceduresAreCallable().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
56 allTablesAreSelectable() and allProceduresAreCallable().
55375d489024 Corrected return values of DatabaseMetaData methods allTablesAreSelectable() and allProceduresAreCallable().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
57 They used to return true but now return false.
219
4572f0694fde Improved DatabaseMetaData methods getTablePrivileges() and getColumnPrivileges() by returning also
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 218
diff changeset
58