Wrong result in ARRAY_AGG when repeating the function with different ORDER BY clauses
Wrong LocalDate value bound when in DST
Error when creating sequence with explicit minvalue
I see, thanks for the clarification. So, not a bug then.
I'm not setting any such mode
LIMIT 0 is being ignored
Invalid ORDER BY expression when using DISTINCT and ORDER BY count(*)
OK, I guess that's a duplicate of https://sourceforge.net/p/hsqldb/bugs/1620/. I'd still say this is a bug, but you already disagreed.