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.

Reply via email to