alamb opened a new issue, #9925:
URL: https://github.com/apache/arrow-datafusion/issues/9925
### Describe the bug
`coalesce` on a dictionary column worked on 36.0.0 but does not in 37.0.0
### To Reproduce
It works in 3.6.0
```sql
DataFusion CLI v36.0.0
❯ create table test as values (arrow_cast('foo', 'Dictionary(Int32,
Utf8)')), (null);
0 rows in set. Query took 0.035 seconds.
❯ select coalesce(column1, 'none_set') from test;
+-----------------------------------------+
| coalesce(test.column1,Utf8("none_set")) |
+-----------------------------------------+
| foo |
| none_set |
+-----------------------------------------+
2 rows in set. Query took 0.018 seconds.
```
Fails in 37.0.0:
```sql
DataFusion CLI v37.0.0
❯ create table test as values (arrow_cast('foo', 'Dictionary(Int32,
Utf8)')), (null);
0 row(s) fetched.
Elapsed 0.021 seconds.
❯ select coalesce(column1, 'none_set') from test;
Error during planning: No function matches the given name and argument types
'coalesce(Dictionary(Int32, Utf8), Utf8)'. You might need to add explicit type
casts.
Candidate functions:
coalesce(CoercibleT, .., CoercibleT)
```
### Expected behavior
Should get the same answer as 36.0.0
### Additional context
Maybe related to https://github.com/apache/arrow-datafusion/pull/9459
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
