[jdbc-v2] DatabaseMetadata fails if server has a new type

Description

Stacktrace:

java.lang.IllegalArgumentException: Unknown data type: Time64
	at com.clickhouse.data.ClickHouseDataType.of(ClickHouseDataType.java:460)
	at com.clickhouse.jdbc.metadata.DatabaseMetaDataTest.testGetTypeInfo(DatabaseMetaDataTest.java:234)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

This means that old client would not work with a new server even if type is never used.

Expected Behaviour

Warning but no exception when client reads a new type from a server.

@chernser

@chernser, it seems to have been revered ClickHouse/ClickHouse#75735, but agree the client shouldn't fail on a new type

This exception happens actually in the test so its fine. And indicates missing type.
However we may need to find place where it can cause an error.

There is a bug in Metadata reading type info (#2678 (comment)):

[ERROR] 2025-12-17 15:03:47.935 [main] c.c.j.metadata.DatabaseMetaDataImpl - Failed to convert column data type to SQL type: {}
java.lang.IllegalArgumentException: No enum constant com.clickhouse.data.ClickHouseDataType.Geometry
        at java.base/java.lang.Enum.valueOf(Enum.java:293)
        at com.clickhouse.data.ClickHouseDataType.valueOf(ClickHouseDataType.java:52)
        at com.clickhouse.jdbc.metadata.DatabaseMetaDataImpl.lambda$static$2(DatabaseMetaDataImpl.java:1102)
        at com.clickhouse.jdbc.internal.DetachedResultSet.createFromResultSet(DetachedResultSet.java:93)
        at com.clickhouse.jdbc.metadata.DatabaseMetaDataImpl.getTypeInfo(DatabaseMetaDataImpl.java:1082)
        at io.github.linghengqian.SimpleTest.simpleTest(SimpleTest.java:14)

There is a potential problem with reading data schema containing unknown Datatype.
We may ignore columns with unknown types but should:

create a special ClickhouseColumn instance that indicate unknown column to prevent accidental usage in binary writers and readers
write documentation around it
configuration flag?? may be not.

Navigation Menu

Repository navigation

[jdbc-v2] DatabaseMetadata fails if server has a new type #2394

Description

Expected Behaviour

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

[jdbc-v2] DatabaseMetadata fails if server has a new type #2394

Description

Description

Expected Behaviour

Activity

mshustov commented on May 28, 2025

chernser commented on Jun 27, 2025

chernser commented on Dec 17, 2025

chernser commented on Dec 18, 2025

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions