ClickHouse / ClickHouse/clickhouse-odbc

Wrong number of fields with grouparray via ODBC

Open
#433 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
C
Stars
285
Forks
105
Avg merge
3h 56m
Merged PRs (30d)
3

Description

Hi,

The following statement should give a list of fields per table:
```
SELECT
table AS table_name
, REPLACE(REPLACE(REPLACE(toString(groupArray(name)), '[',''), ']',''), '''', '') AS fieldlist
FROM system.columns
GROUP BY table
```
In DB Visualizer or native, we get the correct number of entries in the fieldlist (our test table has 367 fields), but with ODBC, we receive much more fields (some of them are listed twice or even more).

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.