Repository navigation
suggest add table function generate_series and change the results of current version #9323
Description
Is your feature request related to a problem or challenge?
as #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
3Describe alternatives you've considered
No response
Additional context
No response
Activity
l1t1 commentedon Feb 23, 2024
databend's numbers function + 1 is similar with generate_series
Lordworms commentedon Feb 24, 2024
I'm just wondering what is the purpose of datafusion to design in such a way. If this feature is needed, I can do this one.
alamb commentedon Feb 26, 2024
Here is the duckdb syntax: https://duckdb.org/docs/sql/functions/nested.html#range-functions
It looks to me like
generate_seriesandrangecan be both scalar functions (return list) or table functions (return a table)alamb commentedon Feb 26, 2024
I think we should follow postgres or duckdb's syntax
Lordworms commentedon Feb 27, 2024
take