-
Notifications
You must be signed in to change notification settings - Fork 1.9k
Closed
Labels
bugSomething isn't workingSomething isn't working
Description
Describe the bug
During the implementation of this issue I found another problem
Given this slt
query II
select unnest([1,2,3]), unnest(unnest([[1,2,3]]));
The output from Datafusion is
1 1
1 2
1 3
To Reproduce
No response
Expected behavior
Datafusion returns correct result set
1 1
2 2
3 3
Example in Duckdb
D select unnest([1,2,3]), unnest([[1,2,3]],recursive:=true);
┌──────────────────────────────────┬────────────────────────────────────────────────────────────────────────────────────────┐
│ unnest(main.list_value(1, 2, 3)) │ unnest(main.list_value(main.list_value(1, 2, 3)), "recursive" := CAST('t' AS BOOLEAN)) │
│ int32 │ int32 │
├──────────────────────────────────┼────────────────────────────────────────────────────────────────────────────────────────┤
│ 1 │ 1 │
│ 2 │ 2 │
│ 3 │ 3 │
└──────────────────────────────────┴────────────────────────────────────────────────────────────────────────────────────────┘
Additional context
No response
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working