-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Array functions not working with Array(Array(LowCardinality(String))) data type #7815
Copy link
Copy link
Closed
Labels
comp-datatype-wrapperType modifiers/wrappers (Nullable, LowCardinality, etc.).Type modifiers/wrappers (Nullable, LowCardinality, etc.).comp-regular-functionRegular scalar functions: string processing, data conversion, arithmetic, math, comparison, condi...Regular scalar functions: string processing, data conversion, arithmetic, math, comparison, condi...unfinished code
Description
Describe the bug or unexpected behavior
Array functions not working with Array(Array(LowCardinality(String))) data type
How to reproduce
- Which ClickHouse server version to use
19.14.7.15 - Which interface to use, if matters
http CREATE TABLEstatements for all tables involved
create table test (
arr Array(Array(LowCardinality(String)))
) engine = Memory
- Sample data for all these tables, use clickhouse-obfuscator if necessary
insert into test(arr) values ([['a'], ['b', 'c']]) - Queries to run that lead to unexpected result
select arrayFilter(x -> 1, arr) from test
Expected behavior
array functions works without exceptions
Error message and/or stacktrace
Code: 49, e.displayText() = DB::Exception: Cannot capture column 2 because it has incompatible type: got Array(String), but Array(LowCardinality(String)) is expected. (version 19.14.7.15 (official build))
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
comp-datatype-wrapperType modifiers/wrappers (Nullable, LowCardinality, etc.).Type modifiers/wrappers (Nullable, LowCardinality, etc.).comp-regular-functionRegular scalar functions: string processing, data conversion, arithmetic, math, comparison, condi...Regular scalar functions: string processing, data conversion, arithmetic, math, comparison, condi...unfinished code