annotate ChangeLog @ 322:0fcf338ce0b4

Optimized parse method of TupleLineParser by creating less helper objects and replacing method calls by direct operations on variables. We now only create a StringBuilder object uesc when it is needed (when an escaped character is detected in the tuple line). In most tuple data lines no escape characters are used and thus the StringBuilder object was not used/needed. Also increased the default capacity of StringBuilder uesc such that it is not enlarged so often. Also made StringBuilder object uesc now part of the TupleLineParser object, such that it can be reused by many parse() calls, again reducing the number of created StringBuilder objects.
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Wed, 11 Sep 2019 17:18:00 +0200 (2019-09-11)
parents dbd8e9a8566f
children 6ed8f5b1f9ed
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
322
0fcf338ce0b4 Optimized parse method of TupleLineParser by creating less helper objects and replacing method calls by direct operations on variables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 321
diff changeset
4 * Wed Sep 11 2019 Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
0fcf338ce0b4 Optimized parse method of TupleLineParser by creating less helper objects and replacing method calls by direct operations on variables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 321
diff changeset
5 - Optimized parse() method of TupleLineParser by creating less helper objects
0fcf338ce0b4 Optimized parse method of TupleLineParser by creating less helper objects and replacing method calls by direct operations on variables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 321
diff changeset
6 and replacing method calls by direct operations on variables.
0fcf338ce0b4 Optimized parse method of TupleLineParser by creating less helper objects and replacing method calls by direct operations on variables.
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 321
diff changeset
7
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 * 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
9 - 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
10 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
11 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
12 - 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
13 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
14 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
15 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
16
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
17 * 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
18 - 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
19 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
20 - 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
21 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
22
298
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
23 * 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
24 - Improved MonetDatabaseMetaData methods:
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
25 - 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
26 - 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
27 - 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
28 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
29 - 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
30 - 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
31 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
32 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
33 - getSystemFunctions(): it no longer lists function: getlimit.
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
34 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
35 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
36 methods getNumericFunctions(), getStringFunctions(), getSystemFunctions()
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
37 and getTimeDateFunctions().
6db8f6702ce8 Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 294
diff changeset
38
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
39 * 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
40 - Corrected MonetDatabaseMetaData methods:
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
41 - getNumericFunctions(): it now includes function: pi.
894abb249de1 Corrected 3 MonetDatabaseMetaData methods
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 290
diff changeset
42 - 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
43 - 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
44 - 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
45 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
46 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
47 - Implemented method MonetClob.getAsciiStream().
289
cce8a1803f68 Implemented method MonetClob.getAsciiStream()
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 275
diff changeset
48
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
49 * 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
50 - 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
51 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
52 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
53
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
54 * 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
55 - 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
56 - 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
57 - 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
58 - 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
59
263
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
60 * 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
61 - Improved MonetDatabaseMetaData methods:
8fbed4aeff0e Improved MonetDatabaseMetaData methods:
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 253
diff changeset
62 - 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
63 - 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
64 - 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
65 - 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
66 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
67 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
68
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
69 * 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
70 - 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
71 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
72
245
55375d489024 Corrected return values of DatabaseMetaData methods allTablesAreSelectable() and allProceduresAreCallable().
Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
parents: 230
diff changeset
73 * 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
74 - 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
75 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
76 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
77