Regression in JDBC 0.9.8 when reading Array(Tuple(...)) with named tuple elements.
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 52/100
Research direction
Start by reproducing the two SQL queries with clickhouse-jdbc 0.9.8, then compare the returned Array(Tuple(...)) value with JDBC 0.6.0 and the unnamed-tuple case. Check whether the driver or IntelliJ Database Viewer controls rendering; done means named tuple arrays expose their contents consistently with the expected cases.
Written by the indexing model from the issue text.
Description
Description
Regression in JDBC 0.9.8 when reading Array(Tuple(...)) with named tuple elements.
With the official ClickHouse JDBC driver 0.9.8, IntelliJ IDEA displays Array(Tuple(id UUID)) values as:
com.clickhouse.jdbc.types.Array@54c3b772
instead of the array contents.
The same query works correctly with JDBC 0.6.0.
The issue only affects named tuples. Arrays of unnamed tuples are displayed correctly.
Steps to reproduce
- Connect to ClickHouse using clickhouse-jdbc:0.9.8.
- Execute
SELECT [('550e8400-e29b-41d4-a716-446655440000')];Result is displayed correctly. - Execute
SELECT [('550e8400-e29b-41d4-a716-446655440000')::Tuple(id UUID)];Result is displayed as com.clickhouse.jdbc.types.Array@...
Error Log or Exception StackTrace
No exception is thrown.
The value is rendered as:
com.clickhouse.jdbc.types.Array@54c3b772
Expected Behaviour
Array(Tuple(id UUID)) should be returned through JDBC in a way that clients can display its contents, the same as in JDBC 0.6.0 and the same as Array(Tuple(UUID))
Code Example
SELECT [('550e8400-e29b-41d4-a716-446655440000')];
SELECT [('550e8400-e29b-41d4-a716-446655440000')::Tuple(id UUID)];
Configuration
Client Configuration
Default JDBC configuration.
Environment
- Cloud
- Client version: clickhouse-jdbc 0.9.8
- Language version: N/A (observed in IntelliJ Database Viewer)
- OS: macOS
- IDE: IntelliJ IDEA 2026.2.0.1
ClickHouse Server
- ClickHouse Server version: 26.3.17.56
- ClickHouse Server non-default settings, if any: None
CREATE TABLEstatements for tables involved: Not required (reproducible with literal values only)- Sample data for all these tables, use clickhouse-obfuscator if necessary
It is unclear whether this is a JDBC driver regression or an incompatibility with IntelliJ’s database viewer, but the behavior changed between JDBC 0.6.0 and 0.9.8 and is reproducible with the SQL above.
- Dominant language
- Java
- Stars
- 1.6k
- Forks
- 637
- Avg merge
- 2d 12h
- Merged PRs (30d)
- 28
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from ClickHouse/clickhouse-java
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
ClickHouse/clickhouse-java#3143 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 85/100
ClickHouse/clickhouse-java#3111 ·
-
area:data-type bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
ClickHouse/clickhouse-java#3098 · 1 comment ·
-
bug client-api-v2 test
Difficulty 2/5 1-3 hours Newbie friendliness 92/100
ClickHouse/clickhouse-java#3076 ·
-
area:sql-parser bug client-v1
Difficulty 1/5 1-3 hours Newbie friendliness 92/100
ClickHouse/clickhouse-java#3066 ·
All issues in ClickHouse/clickhouse-java
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
infinispan/infinispan#18150 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
-
untriaged
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
opensearch-project/k-NN#3597 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 82/100