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

[JDBC-V2] Review type mapping and return more certain SQL types for Clickhouse types

Open chernser opened this issue 2 months ago • 0 comments

Description

UInt64 doesn't fit java.sql.Types#BIGINT and it is defined as java.sql.Types#OTHER. This creates a problem for tools working with metadata because they treat is as mystery type.

It can be fixed with mapping such big integer type to java.sql.Types#NUMERIC

This issue it to review mapping in v1 (com.clickhouse.jdbc.JdbcTypeMapping#toSqlType) and v2 . Reasonable mapping should ported from v1.

chernser avatar Sep 30 '25 21:09 chernser