Mercurial > hg > monetdb-java

annotate ChangeLog @ 318:13a9d5316e37

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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". It now uses the same DDL text as when it was created, pulled from sys.tables.query, similar to mclient. Also corrected the missing ON clause part when dumping a REMOTE TABLE definition.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 04 Sep 2019 17:19:08 +0200 (2019-09-04)
parents df815a403bf4
children 816650cda8d0
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>
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
5 - 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
6 the view creation statement was not starting with "create view ", such as
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
7 when it was created using "CREATE VIEW" or "create or replace view". It now
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 uses the same DDL text as when it was created, pulled from sys.tables.query.
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
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
10 * 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
11 - 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
12 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
13 - 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
14 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
15
298
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
16 * 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
17 - Improved MonetDatabaseMetaData methods:
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
18 - 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
19 - 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
20 - 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
21 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
22 - 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
23 - 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
24 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
25 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
26 - getSystemFunctions(): it no longer lists function: getlimit.
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
27 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
28 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
29 methods getNumericFunctions(), getStringFunctions(), getSystemFunctions()
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
30 and getTimeDateFunctions().
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
31
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
32 * 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
33 - Corrected MonetDatabaseMetaData methods:
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
34 - getNumericFunctions(): it now includes function: pi.
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
35 - 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
36 - 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
37 - 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
38 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
39 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
40 - Implemented method MonetClob.getAsciiStream().
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
41
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
42 * 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
43 - 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
44 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
45 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
46
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
47 * 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
48 - 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
49 - 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
50 - 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
51 - 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
52
263
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
53 * 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
54 - Improved MonetDatabaseMetaData methods:
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
55 - 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
56 - 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
57 - 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
58 - 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
59 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
60 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
61
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
62 * 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
63 - 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
64 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
65
245
55375d489024 Corrected return values of DatabaseMetaData methods allTablesAreSelectable() and allProceduresAreCallable().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
66 * 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
67 - 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
68 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
69 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
70