ClickHouse / ClickHouse/ClickHouse

any loses LowCardinality

Open
#41,057 2 comments 1 reaction 0 assignees View on GitHub
comp-datatype-wrapper external minor unexpected behaviour
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

```sql
select cast ('', 'LowCardinality(Nullable(String))') x , toTypeName(x) x_type, toTypeName(any(x)) x_any_type;
┌─x─┬─x_type───────────────────────────┬─x_any_type───────┐
│ │ LowCardinality(Nullable(String)) │ Nullable(String) │
└───┴──────────────────────────────────┴──────────────────┘

create table t (
a Int64,
b SimpleAggregateFunction(any, Array(LowCardinality(Nullable(String)))) )
Engine = AggregatingMergeTree order by a;

DB::Exception: Incompatible data types between aggregate function 'any'
which returns Array(Nullable(String)) and column storage type Array(LowCardinality(Nullable(String))). (BAD_ARGUMENTS)
```

seems after 20.12

https://fiddle.clickhouse.com/7d7a5d39-f674-4145-9e2f-bf58916d3390
LowCardinality(Nullable(String)) LowCardinality(Nullable(String))

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.