beta.row_binary_for_simple_insert fails on Uint64 values larger than long type passed as string

[troyjcurt]

Describe your feedback

when you pass a very large number (larger than max long, but smaller than max UInt64) as a string in a simple insert, the client attempts to convert this value into a long using Long.parseLong, which will fail, as the string value is higher than the long boundary. something like BigInteger.longValue would be required for this translation.

Code example

preparedStatement.setString(1, bignumber);
preparedStatement.addBatch();

[chernser]

Good day, @troyjcurt ! What version of a JDBC driver do you use? Would you please give a JDBC url and connection properties?

Thanks!

[troyjcurt]

The JDBC version was 0.9.2 (v2), and the connection url was: jdbc:ch://${CLICKHOUSE_HOSTNAME:localhost}:${CLICKHOUSE_PORT:8123}/${DB_NAME:database}?beta.row_binary_for_simple_insert=true

[chernser]

Thank you, @troyjcurt!

this beta.row_binary_for_simple_insert=true is critical configuration parameter. We will fix it.