Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug(frontent): generate_series not compatible with PSQL #8826

Closed
CAJan93 opened this issue Mar 28, 2023 · 2 comments
Closed

bug(frontent): generate_series not compatible with PSQL #8826

CAJan93 opened this issue Mar 28, 2023 · 2 comments
Assignees
Labels
component/func-table Support a 1-to-n set / table function good first issue Good for newcomers type/feature
Milestone

Comments

@CAJan93
Copy link
Contributor

CAJan93 commented Mar 28, 2023

Describe the bug

https://www.postgresql.org/docs/current/functions-srf.html

Postgres supports 2 forms of generate_series: One with 2 params and one with 3 params. The 3rd params is the stepping distance between the generated numbers

SELECT * FROM generate_series(2,4);
 generate_series
-----------------
               2
               3
               4
(3 rows)

SELECT * FROM generate_series(5,1,-2);
 generate_series
-----------------
               5
               3
               1
(3 rows)

We only support the version with 3 params. Should we also support the one with 2 params?

It just defaults to 1 for the stepping distance.

Expected behavior

Compatibility with PSQL

@CAJan93 CAJan93 added the type/bug Something isn't working label Mar 28, 2023
@github-actions github-actions bot added this to the release-0.19 milestone Mar 28, 2023
@xxchan
Copy link
Member

xxchan commented Mar 28, 2023

Should we also support the one with 2 params

Yes

@xiangjinwu xiangjinwu added the component/func-table Support a 1-to-n set / table function label Apr 4, 2023
@xxchan xxchan added type/bug Something isn't working good first issue Good for newcomers type/feature and removed type/bug Something isn't working labels May 14, 2023
@xiangjinwu
Copy link
Contributor

Supported by #9949

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/func-table Support a 1-to-n set / table function good first issue Good for newcomers type/feature
Projects
None yet
Development

No branches or pull requests

4 participants