Repository navigation
4.1 Parser fails on H2 Ordered Aggregate Functions #1183
Description
Just stumpled over this:
-- LISTAGG 3: fails to parse
SELECT LISTAGG(ID, ', ') WITHIN GROUP (ORDER BY ID) OVER (ORDER BY ID);
-- ARRAY_AGG 2: fails to deparse correctly
SELECT ARRAY_AGG(NAME ORDER BY ID) FILTER (WHERE NAME IS NOT NULL);
-- ARRAY_AGG 3 fails to deparse correctly
SELECT ARRAY_AGG(ID ORDER BY ID) OVER (ORDER BY ID);net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "BY" "BY"
at line 1, column 65.
I will look into this and try to craft a PR when I find some time.
Activity
wumpz commentedon May 1, 2021
The second and third SQL is now parsed and deparsed successfully.
wumpz commentedon May 1, 2021
To the first one: I was not aware that additional to this "within group" an over clause is valid.
manticore-projects commentedon Nov 22, 2022
Should be address by PR #1666.