Hi Thomas,
I realized I did not test the behavior of all comparison operators. I found
that in Java:
0.0 == -0.0 is true
-0.0 < 0.0 is false
SELECT
(CAST('-0.0' AS DOUBLE)) = -(CAST('-0.0' AS DOUBLE)),
(CAST('-0.0' AS DOUBLE)) < -(CAST('-0.0' AS DOUBLE))
H2 will say that:
0.0 == -0.0 is false
-0.0 < 0.0 is true
So, unless I made a mistake when testing, H2 does not seem to behave
properly when comparing negative zeros to zeros.
Hope this helps,
-Christopher
--
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.
