Open
Description
Describe the bug
per #13706 the list functions are modeled after DuckDB1
per https://duckdb.org/docs/sql/functions/list.html#flattenlist_of_lists, flatten should flatten one level, not recursive
To Reproduce
query ???
select flatten(arrow_cast(make_array([[1.1]], [[2.2]], [[3.3], [4.4]]), 'LargeList(LargeList(LargeList(Float64)))'));
----
[1.1, 2.2, 3.3, 4.4]
Expected behavior
query ???
select flatten(arrow_cast(make_array([[1.1]], [[2.2]], [[3.3], [4.4]]), 'LargeList(LargeList(LargeList(Float64)))'));
----
[[1.1], [2.2], [3.3], [4.4]]
Additional context
No response
Footnotes
-
i would prefer a more established point of reference with close alignment to the SQL standard, but this issue is not about this ↩