Mercurial > hg > monetdb-java

annotate ChangeLog @ 312:df815a403bf4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improved JdbcClient program by including the schema prefix when dumping schema objects. It now behaves more similar to mclient -D -N.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 22 Aug 2019 19:06:16 +0200 (2019-08-22)
parents 5ddab9d8d3dd
children 13a9d5316e37
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
310
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 298
diff changeset
4 * Thu Aug 22 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
312
df815a403bf4 Improved JdbcClient program by including the schema prefix when dumping schema objects. It now behaves more similar to mclient -D -N.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 310
diff changeset
5 - Improved JdbcClient program by including the schema prefix when dumping
df815a403bf4 Improved JdbcClient program by including the schema prefix when dumping schema objects. It now behaves more similar to mclient -D -N.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 310
diff changeset
6 schema objects. It now behaves more similar to mclient -D -N.
310
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 298
diff changeset
7 - Improved JdbcClient program. It now also dumps definitions of MERGE TABLE,
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 298
diff changeset
8 REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables.
5ddab9d8d3dd Improved JdbcClient program. It now also dumps definitions of MERGE TABLE, REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping all tables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 298
diff changeset
9
298
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
10 * 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
11 - Improved MonetDatabaseMetaData methods:
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
12 - 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
13 - 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
14 - 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
15 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
16 - 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
17 - 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
18 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
19 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
20 - getSystemFunctions(): it no longer lists function: getlimit.
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
21 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
22 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
23 methods getNumericFunctions(), getStringFunctions(), getSystemFunctions()
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
24 and getTimeDateFunctions().
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
25
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
26 * 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
27 - Corrected MonetDatabaseMetaData methods:
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
28 - getNumericFunctions(): it now includes function: pi.
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
29 - 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
30 - 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
31 - 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
32 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
33 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
34 - Implemented method MonetClob.getAsciiStream().
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
35
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
36 * 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
37 - 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
38 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
39 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
40
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
41 * 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
42 - 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
43 - 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
44 - 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
45 - 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
46
263
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
47 * 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
48 - Improved MonetDatabaseMetaData methods:
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
49 - 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
50 - 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
51 - 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
52 - 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
53 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
54 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
55
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
56 * 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
57 - 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
58 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
59
245
55375d489024 Corrected return values of DatabaseMetaData methods allTablesAreSelectable() and allProceduresAreCallable().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
60 * 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
61 - 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
62 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
63 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
64