That's a funny bug! It's stripping trailing zeros from 1.35822361752313607260107721120531135706133161972E-1*0*
:D ValueDecimal.java:101 On Fri, May 16, 2014 at 12:37 PM, Ankur Goyal <[email protected]> wrote: > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
