-
Notifications
You must be signed in to change notification settings - Fork 8.3k
groupUniqArray + Enum data type returns Int instead of Enum #17875
Copy link
Copy link
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release
Description
How to reproduce
Clickhouse version 20.11.5.18, 20.8.7.15, 20.3.19
SELECT
groupUniqArray(val) AS uniq,
toTypeName(uniq),
groupArray(val) AS arr,
toTypeName(arr)
FROM
(
SELECT CAST(number % 2, 'Enum(\'hello\' = 1, \'world\' = 0)') AS val
FROM numbers(2)
)
Query id: d4657f27-c8bd-4174-9947-c6c48d0222d5
┌─uniq──┬─toTypeName(groupUniqArray(val))─┬─arr───────────────┬─toTypeName(groupArray(val))────────────┐
│ [0,1] │ Array(Int8) │ ['world','hello'] │ Array(Enum8('world' = 0, 'hello' = 1)) │
└───────┴─────────────────────────────────┴───────────────────┴────────────────────────────────────────┘
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release