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

LISTAGG implementation is missing #1

Open
akond opened this issue Dec 10, 2023 · 3 comments
Open

LISTAGG implementation is missing #1

akond opened this issue Dec 10, 2023 · 3 comments
Labels
enhancement New feature or request

Comments

@akond
Copy link

akond commented Dec 10, 2023

H2 has several aggregating functions, such as LISTAGG

LISTAGG ( [ DISTINCT|ALL ] string [, separatorString]
[ ON OVERFLOW { ERROR | TRUNCATE [ filterString ] { WITH | WITHOUT } COUNT } ] )
withinGroupSpecification
[FILTER (WHERE expression)] [OVER windowNameOrSpecification]

Are there any plans to implement those?

@source-c
Copy link
Contributor

We actually implemented only those basic features we currently use. However, if something is needed it is a good reason to take a look at, so thank you for the request. Perhaps you have some testcases for that functionality?

@source-c source-c added the enhancement New feature or request label Dec 10, 2023
@akond
Copy link
Author

akond commented Dec 11, 2023

I've written a small implementation of the LISTAGG ... WITHIN GROUP (...) case. I admit I am not an expert on honey.sql, so the implementation may seem too trivial, clumsy even; however, it works for me.

@source-c
Copy link
Contributor

Ok. Will take a look at all of that. Thank you anyway!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Development

No branches or pull requests

2 participants