Has anyone come across issues with H2 where divisions are not working as expected. In the example below, one would expect both calcualtions to result into same value but the results are shockingly different. select 0.72179425150347250912311550800000 / 5314251955.21 as BAD, 0.72178375676945356689701150672550 / 5314251955.21 as GOOD
BAD --> 0.135822361752313607260107721120531135706133161972 Good --> .35820386924227284899766062540132071488615045349*E-10* Issue is easily reproducible. Any help on how to address such issues is highly appreciated. -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.