clickhouse-java
clickhouse-java copied to clipboard
Jdbc driver can't understand data type "Nothing" and fails to execute query.
Describe the bug
We have table at Clickhouse DB with columns having datatype Nullable(Nothing).
We are using Spotfire desktop with latest version of CH drivers (0.6.0).
While executing simple select query, it fails and throws error..
Steps to reproduce
- Create/Add column of type Nullable(Nothing)
- Use latest version of CH driver and use it at Spotfire
- Call "select" query for table having that column
Expected behaviour
it should run and show results from that table.
Code example
Error log
com.spotfire.ws.im.IMException: Failed to execute query: Unsupported JDBC data type in query result: Nullable(Nothing)
Configuration
Environment
- Client version: clickhouse-jdbc 0.6.0
- Language version:
- OS:
ClickHouse server
- ClickHouse Server version:
- ClickHouse Server non-default settings, if any:
-
CREATE TABLEstatements for tables involved: - Sample data for all these tables, use clickhouse-obfuscator if necessary
This is com.spotfire.ws.im.IMException exception, not com.clickhouse... one