datafusion
datafusion copied to clipboard
Handle nulls for `range` and `generate_series`
Describe the bug
Follow the logic like DuckDB, if any of the argument is Null, return Null instead of throwing error
To Reproduce
query error
select range(DATE '1992-09-01', NULL, INTERVAL '1' YEAR);
query error
select range(DATE '1992-09-01', DATE '1993-03-01', NULL);
query error
select range(NULL, DATE '1993-03-01', INTERVAL '1' YEAR);
Expected behavior
select range(DATE '1992-09-01', NULL, INTERVAL '1' YEAR);
----
Null
select range(DATE '1992-09-01', DATE '1993-03-01', NULL);
----
Null
query error
select range(NULL, DATE '1993-03-01', INTERVAL '1' YEAR);
----
Null
Additional context
No response
I can do the follow up on https://github.com/apache/datafusion/pull/9420