[DuckDB] LIST/ARRAY column does not expand in Data Grid but expands in SQL Editor result set

[jimdickson007]

Description

LIST/ARRAY columns do not expand in the Data Grid (table navigator
double-click) but expand correctly when running SELECT * FROM table
in the SQL editor.

Record view (Tab) also works correctly and shows full array contents.

This suggests Data Grid and SQL Editor use different JDBC fetch paths,
and the Data Grid path does not correctly handle DuckDB LIST types.

DBeaver Version

26.1.1.202606211757

Operating System

Windows 11

Database and driver

DuckDB 1.5.4
DuckDB JDBC driver: duckdb_jdbc-1.5.4.0.jar

Steps to reproduce

1. Create table:

CREATE TABLE test_grid (
    id INTEGER,
    amounts INTEGER[]
);
INSERT INTO test_grid VALUES
    (1, [1, 2, 3]),
    (2, [4, 5]);

2. In SQL editor run: SELECT * FROM test_grid;
   → amounts column expands correctly ✓
3. Double-click test_grid in Database Navigator to open Data Grid
   → amounts column does NOT expand ✗

Expected behaviour

LIST/ARRAY columns expand consistently in both SQL Editor
and Data Grid views.

Actual behaviour

• SQL Editor result set: expands ✓
• Data Grid (navigator): does not expand ✗
• Record view (Tab): expands ✓

Additional context

• Reproduced on both DuckDB 1.3.2 (in-memory) and 1.5.4 (persistent)
• Neither version nor memory/persistent affects the outcome —
  the bug is consistent across both
• Root cause appears to be in the Data Grid JDBC fetch path —
  both Grid view and Record view fail when opened via Data Grid,
  but both work correctly when opened from a SQL Editor result set
• This suggests the Data Grid fetch cursor returns LIST/ARRAY data
  in a different format than the SQL Editor result set cursor

[jimdickson007]

Screenshots

[LonwoLonwo]

Hello. It looks like a bug (and I can reproduce it). Please create a ticket here https://github.com/dbeaver/dbeaver/issues

[jimdickson007]

Thanks for confirmation
Ticket raised : #41427

[davestokes]

#41427 is a duplicate