Listagg with nulls clause emulation in H2 before 2.0
Description
Activity
Show:
Fixed
Details
Details
Assignee
Christian Beikov
Christian BeikovReporter
Christian Beikov
Christian BeikovComponents
Fix versions
Affects versions
Priority
Created June 23, 2022 at 8:36 PM
Updated July 1, 2022 at 12:08 PM
Resolved June 23, 2022 at 10:00 PM
When using the listagg function with null precedence on H2, the resulting query fails on versions below 2.0, because H2 doesn’t support the nulls clause in the within group clause. Also, the listagg function until version 2.0 didn’t support multiple order by items, so we should use group concat until 2.0.