Re: [h2] Value is different for AVG(CAST AS DECIMAL)

2022-04-08 Thread Noel Grandin
I think you will need to cast to something like DECIMAL(20,2) i.e. specify the precision and scale On Thu, 7 Apr 2022 at 21:49, Jane wrote: > Hi All, > > I am upgrading H2 from 1.4.197 to 2.1.210. I have a query which casts a > value to DECIMAL, as - SELECT AVG(CAST(A AS DECIMAL). Column A is IN

Re: [h2] Error 50000-210: org.h2.jdbc.JdbcSQLNonTransientException

2022-04-08 Thread Noel Grandin
If you can provide a standalone test case, we can probably debug the issue -- 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.co