Important Changes
-
[jdbc-v2] SQL parser from v1 is ported to v2 to address multiple issues with SQL parsing. The ANTLR4-based parser is
still an option and will be developed further. The main difference between parses is completeness of their grammar:
JavaCC grabs only needed information and skips parsing of the rest (what makes it work for most cases) while ANTLR4
has more complete grammar and can detect type of some complex statements more accurate than JavaCC.
To use it setcom.clickhouse.jdbc.DriverProperties#SQL_PARSERtoANTLR4.
(#2579). This fixes issue: -
[repo] New artifact
clickhouse-jdbc-alladded to address issue when maven package qualifiers may not be used.
This artifact should is a copy ofclickhouse-jdbc:allbut should be used only when required. (#2625)
Improvements
- [client-v2] Added
getShortArray()andgetStringArray()toClickHouseBinaryFormatReader. (#2604) - [client-v2] Added
result_rowsandelapsed_timeto summary object. (https://github.com/ClickHouse/clickhouse-java/pull/1633/files)
Bug Fixes
- [jdbc-v2] Fixed issue with
maxRowsinStatementwhen additional settings were used to limit result set size.
It caused problems with read-only users because such users may not change settings in most cases. Now whenmaxRowsis
set thenResultSetwill skip extra rows. (#2582) - [jdbc-v2] Fixed issue with driver version. Previously version of a library was converted to minor and major version.
But this approach doesn't work well with0.9.xversions. Now major and minor versions are combined by shifting major.
Patch version becomes a minor version. (#2410) - [jdbc-v2, client-v2] Fixed converting different data types to a string. For example, there was an issue with IP
address whentoString()was used and returned\0.0.0.0instead of0.0.0.0. (#2575) - [jdbc-v2] Fixed issues around spatial data (GEO types). (#2577)
- [client-v2] Fixed issue with current user name. If user name is set then it will be used event after reading
server context. (#2247) - [client-v2] Fixed issue with network timeout settings when default value failed to be cast to Long. (#2597)
- [jdbc-v2] Fixed getting metadata for nullable columns. (#2586)
- [jdbc-v2, client-v2] Fixed issues related to reading JSON data type. Fixed reading JSON columns with arrays. Previously was causing exceptions like
com.clickhouse.client.api.ClientException: Unsupported data type with tag 101 at ...
(#2598, #2593,
#2613, #2102) - [client-v2] Fixed configuration parameter type for
socket_lingerto match documentation. (#2524) - [client-v2] Fixed handling exceptions in http client code. Now response object is always closed to prevent connection leaking. (#2615)
- [jdbc-v2, client-v2] Fixed issue with duplicate column names in a result set. (#2459, #2336)
- [jdbc-v2] Fixed ANTLR4 parse issue with
filterclause along with aggregate function. (#2631)