clickhouse-java icon indicating copy to clipboard operation
clickhouse-java copied to clipboard

Jdbc driver can't understand data type "Nothing" and fails to execute query.

Open nikhilbhawsar opened this issue 2 years ago • 1 comments

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

  1. Create/Add column of type Nullable(Nothing)
  2. Use latest version of CH driver and use it at Spotfire
  3. 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 TABLE statements for tables involved:
  • Sample data for all these tables, use clickhouse-obfuscator if necessary

nikhilbhawsar avatar Feb 20 '24 03:02 nikhilbhawsar

This is com.spotfire.ws.im.IMException exception, not com.clickhouse... one

dolfinus avatar Mar 27 '24 22:03 dolfinus