Hello! Yes, it's a bug. Implementation of this Oracle compatibility function doesn't handle DECFLOAT arguments properly, but you can cast them to a some other numeric types as a workaround.
TO_CHAR(CAST(2E+1 AS NUMERIC(6, 2)), '9999D00') Approximate numeric literals (with exponent) have DECFLOAT data type in new versions of H2. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/6eedc3f0-d6ba-4735-82a2-916e04466474n%40googlegroups.com.