[GH-ISSUE #1951] Array fields in Clickhouse cause a crash #576

New issue

Closed

opened 2026-03-07 20:51:31 +03:00 by kerem · 0 comments

kerem commented

2026-03-07 20:51:31 +03:00

Owner

Originally created by @AviSarmani on GitHub (Aug 24, 2023).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/1951

Originally assigned to: @uslss, @ShadelessFox on GitHub.

Hi,
Started at 23.1.5, doesn't happen in 23.1.4.
When we try to display data that has an array column in Clickhouse, we get an error:

The field at path '/result/results[0]/resultSet/id' was declared as a non null type, but the code involved in retrieving data has wrongly returned a null value.  The graphql specification requires that the parent field be set to null, or if that is non nullable that it bubble up null to its parent and so on. The non-nullable type is 'ID' within parent type 'SQLResultSet'

or:

Cannot invoke "org.jkiss.dbeaver.ext.clickhouse.ClickhouseDataTypesParser$AnyTypeContext.getText()" because the return value of "org.jkiss.dbeaver.ext.clickhouse.ClickhouseDataTypesParser$ArrayTypeContext.anyType()" is null

To Reproduce

create table test(
  `test` Array(Int64)
  )
ENGINE = MergeTree
ORDER BY tuple()
SETTINGS index_granularity = 8192

Try to navigate to the data tab
Screenshots

Originally created by @AviSarmani on GitHub (Aug 24, 2023). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/1951 Originally assigned to: @uslss, @ShadelessFox on GitHub. Hi, Started at 23.1.5, doesn't happen in 23.1.4. When we try to display data that has an array column in Clickhouse, we get an error: ``` The field at path '/result/results[0]/resultSet/id' was declared as a non null type, but the code involved in retrieving data has wrongly returned a null value. The graphql specification requires that the parent field be set to null, or if that is non nullable that it bubble up null to its parent and so on. The non-nullable type is 'ID' within parent type 'SQLResultSet' ``` or: ``` Cannot invoke "org.jkiss.dbeaver.ext.clickhouse.ClickhouseDataTypesParser$AnyTypeContext.getText()" because the return value of "org.jkiss.dbeaver.ext.clickhouse.ClickhouseDataTypesParser$ArrayTypeContext.anyType()" is null ``` **To Reproduce** ``` create table test( `test` Array(Int64) ) ENGINE = MergeTree ORDER BY tuple() SETTINGS index_granularity = 8192 ``` Try to navigate to the data tab **Screenshots** ![image](https://github.com/dbeaver/cloudbeaver/assets/49937628/5930efc4-5b13-453a-96cc-09299d975988) ![image](https://github.com/dbeaver/cloudbeaver/assets/49937628/e366239c-cae6-40ea-8f5c-4e52205816d8) ![image](https://github.com/dbeaver/cloudbeaver/assets/49937628/1b6c04a5-c764-4bd8-92ad-bd4cb9539cef)