Hello.
1. Unsupported type 17 is usually thrown when multiple versions of H2 were used with the same database file (versions of TCP clients don't matter, only versions of servers and embedded connections should match). For example, IDEA users are affected, because IDEA uses 1.4.196 it its tools. https://github.com/h2database/h2database/issues/2078 If you can reproduce that issue with 1.4.200 only, please try to build a test case for it. 2. Addition of DECIMAL(23, 5) to DECIMAL(23, 5) should produce a numeric data type with scale 5 and any vendor-specific precision, according to the SQL Standard. Therefore you should not assume that it will be DECIMAL(23, 5), it can legally be different, for example, DECIMAL(2147483647, 5) or something else. You need to add an explicit cast to DECIMAL(23, 5) such as CAST(A + B AS DECIMAL(23, 5)) to be sure. Unfortunately, H2 does not evaluate the scale properly, this issue is also known. https://github.com/h2database/h2database/issues/1910 3. Released versions of H2 don't have any sane limits for scale, but such limit exists in current sources. I think we need to add some code to allow initialization of databases that already have abnormal data types such as DECIMAL(2147483647, 2147483647) created by older 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/225c10df-184b-4d41-96f3-8872468a080b%40googlegroups.com.
