datafusion icon indicating copy to clipboard operation
datafusion copied to clipboard

suggest add table function `generate_series` and change the results of current version

Open l1t1 opened this issue 4 months ago • 2 comments

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

l1t1 avatar Feb 23 '24 04:02 l1t1