Listagg with nulls clause emulation in H2 before 2.0

Description

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.

Activity

Show:
Fixed

Details

Assignee

Reporter

Components

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