datafusion
datafusion copied to clipboard
suggest add table function `generate_series` and change the results of current version
Is your feature request related to a problem or challenge?
as https://github.com/apache/arrow-datafusion/discussions/9315 mentioned, generate_series
is alias of range
, it's result does not include the upper bound. it results the problem of Portability from other DBMS.
Describe the solution you'd like
the result of generate_series
is same as that of postgresql, the range()
funciton keeps the current result
select generate_series(1,3);
generate_series
-----------------
1
2
3
select * from generate_series(1,3);
generate_series
-----------------
1
2
3
Describe alternatives you've considered
No response
Additional context
No response