generate_series hangs indefinitely when providing a step of less than 1 day

[Abdullahsab3]

Describe the bug

When using dates for generate_series and providing a step of less than 1 day, Datafusion hangs indefinitely without any failures/successes (or maybe I didn't wait long enough :-) )

To Reproduce

select generate_series(date '2023-01-01', date '2023-02-01', interval '1 hour');

Expected behavior

Return the grouping, or an error to indicate it may not be implemented/expected

Additional context

No response

[tshauck]

Edit: understand a little bit better what is happening. Comment below is out of date.

I took a quick look here, and I think the root cause may be in arrow.

For one, the generate series uses a Date32, I tried to change it to a ate64, but then ran into what I think is an issue with adding IntervalMonthDayNanoType to a date. See apache/arrow-rs#6198 for more info.

[alamb]

@tshauck has a PR up that fixes this ❤️ -- #11907. I expect it will be merged shortly