Skip to content

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

@chernser

Description

@chernser

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    area:jdbc-metadataissue handling metadata things like getting type of columnbugjdbc-v2jdbc-v2 issues

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions