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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/6eedc3f0-d6ba-4735-82a2-916e04466474n%40googlegroups.com.
