Mercurial > hg > monetdb-java

annotate ChangeLog @ 321:dbd8e9a8566f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes. Also enhanced the listing of table/view names when they contain whitespaces, they now are surrounded by double quotes.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 05 Sep 2019 20:01:03 +0200 (2019-09-05)
parents 816650cda8d0
children 0fcf338ce0b4
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
318
13a9d5316e37 Corrected JdbcClient program: the dumping of a view DDL was incorrect when the view creation statement was not starting with "create view ", such as when it was created using "CREATE VIEW" or "create or replace view".
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 312
diff changeset
4 * Wed Sep 4 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
319
816650cda8d0 Include the java version in the jar files for clarity to users on which minimum Java version to use.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 318
diff changeset
5 - The jar files are now named according to Java version compatibility.
816650cda8d0 Include the java version in the jar files for clarity to users on which minimum Java version to use.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 318
diff changeset
6 For example, the monetdb-jdbc-2.29.jre7.jar file should be used with
816650cda8d0 Include the java version in the jar files for clarity to users on which minimum Java version to use.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 318
diff changeset
7 Java 7 (or higher).
318
13a9d5316e37 Corrected JdbcClient program: the dumping of a view DDL was incorrect when the view creation statement was not starting with "create view ", such as when it was created using "CREATE VIEW" or "create or replace view".
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 312
diff changeset
8 - Corrected JdbcClient program: the dumping of a view DDL was incorrect when
13a9d5316e37 Corrected JdbcClient program: the dumping of a view DDL was incorrect when the view creation statement was not starting with "create view ", such as when it was created using "CREATE VIEW" or "create or replace view".
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 312
diff changeset
9 the view creation statement was not starting with "create view ", such as
321
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 319
diff changeset
10 when it was created using "create or replace view". It now shows the
dbd8e9a8566f Fixed JdbcClient program. It now allows you to describe tables or view which contains whitespaces by using double quotes.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 319
diff changeset
11 value as stored in sys.tables.query field, similar to mclient program.
318
13a9d5316e37 Corrected JdbcClient program: the dumping of a view DDL was incorrect when the view creation statement was not starting with "create view ", such as when it was created using "CREATE VIEW" or "create or replace view".
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 312
diff changeset
12
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
13 * 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
14 - Improved JdbcClient program by including the schema prefix when dumping
318
13a9d5316e37 Corrected JdbcClient program: the dumping of a view DDL was incorrect when the view creation statement was not starting with "create view ", such as when it was created using "CREATE VIEW" or "create or replace view".
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 312
diff changeset
15 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
16 - Improved JdbcClient program. It now also dumps definitions of MERGE TABLE,
318
13a9d5316e37 Corrected JdbcClient program: the dumping of a view DDL was incorrect when the view creation statement was not starting with "create view ", such as when it was created using "CREATE VIEW" or "create or replace view".
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 312
diff changeset
17 REMOTE TABLE, REPLICA TABLE and STREAM TABLE when dumping (all) tables.
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
18
298
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
19 * 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
20 - Improved MonetDatabaseMetaData methods:
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
21 - 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
22 - 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
23 - 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
24 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
25 - 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
26 - 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
27 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
28 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
29 - getSystemFunctions(): it no longer lists function: getlimit.
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
30 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
31 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
32 methods getNumericFunctions(), getStringFunctions(), getSystemFunctions()
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
33 and getTimeDateFunctions().
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
34
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
35 * 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
36 - Corrected MonetDatabaseMetaData methods:
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
37 - getNumericFunctions(): it now includes function: pi.
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
38 - 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
39 - 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
40 - 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
41 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
42 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
43 - Implemented method MonetClob.getAsciiStream().
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
44
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
45 * 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
46 - 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
47 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
48 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
49
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
50 * 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
51 - 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
52 - 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
53 - 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
54 - 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
55
263
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
56 * 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
57 - Improved MonetDatabaseMetaData methods:
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
58 - 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
59 - 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
60 - 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
61 - 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
62 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
63 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
64
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
65 * 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
66 - 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
67 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
68
245
55375d489024 Corrected return values of DatabaseMetaData methods allTablesAreSelectable() and allProceduresAreCallable().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
69 * 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
70 - 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
71 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
72 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
73