ClickHouse / ClickHouse/clickhouse-odbc
Wrong number of fields with grouparray via ODBC
Open
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
Assessment
This issue has not been assessed yet.