Skip to content

Add support for multiple expressions in order by clause for aggregate functions #875

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

Closed
mustafasrepo opened this issue May 10, 2023 · 0 comments · Fixed by #879
Closed

Comments

@mustafasrepo
Copy link
Contributor

sqlparser can parse query below successfully,

SELECT ARRAY_AGG(x ORDER BY x) AS a FROM T

However, it cannot parse query below

SELECT ARRAY_AGG(x ORDER BY x, y) AS a FROM T

It assumes that order by will contain single entry. However, second form is valid also. Postgres can run queries in the second form.
Add support for multiple expression in the order by clause for aggregate functions.

@mustafasrepo mustafasrepo changed the title Add support for multiple expression in order by for aggregate queries Add support for multiple expressions in order by clause for aggregate queries May 10, 2023
@mustafasrepo mustafasrepo changed the title Add support for multiple expressions in order by clause for aggregate queries Add support for multiple expressions in order by clause for aggregate functions May 10, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
1 participant