Hi, The problem is that the literal -0.0 is a BigDecimal, not a Double. BigDecimal doesn't "know" -0.0 (it's the same as 0.0). If you cast it to Double, the result is different:
select -cast(0.0 as double) >= 0.0; > false H2 uses Double.compareTo, where -0.0 is considered smaller than 0.0. Please tell me if this is a problem. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
