DBeaver: Selecting array of structs returns error

[xxchan]

Describe the bug

select array[(1,2)]::struct<a integer, b integer>[] as measurements;

returns Cannot invoke "String.hashCode()" because "typeName" is null in DBeaver SQL console

dbeaver/dbeaver#36198

Error message/log

No response

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response

[ShadelessFox]

I believe this is a bug on the database side. The ResultSetMetaData#getColumnTypeName method returns null for such a column.

Is there a way to obtain a type name for complex columns? If PostgreSQL's JDBC driver is incompatible with your database, could you offer a different solution?

[ShadelessFox]

The JDBC metadata also incorrectly reports the second column being of type varchar:

select (1,2)::struct<a integer, b integer> as measurement;