[BUG] - Query result from scratchpad shows error in clickhouse

[touchinno]

Describe the bug
I have the following query in the scratchpad

select hostname, type, event_time, query, databases, tables, COLUMNS('exp*'), address, port 
from system.query_log
order by event_date, event_time
limit 10

When I selected the ClickHouse database and executed the above query, an error occurred, and it is displayed as shown in the following screenshot.

I think this happens when one of result columns has array type...

To Reproduce
As explained above

Expected behavior
The normal SQL execution results are displayed.

Screenshots

Additional context
.

[modelorona]

Hi @touchinno , thanks for trying out WhoDB! It looks like you're missing your screenshot as it's the same code block twice.

[touchinno]

Hi @touchinno , thanks for trying out WhoDB! It looks like you're missing your screenshot as it's the same code block twice.

screenshot uploaded ^^

[modelorona]

Thank you for uploading your screenshot!

By any chance, are you using a public test database, or are you able me with an idea of how your system.query_log table looks like in terms of column data types?

[touchinno]

Thank you for uploading your screenshot!

By any chance, are you using a public test database, or are you able me with an idea of how your system.query_log table looks like in terms of column data types?

That table is the system table which contains information about executed queries managed by clickhouse server.

https://clickhouse.com/docs/en/operations/system-tables/query_log