I just upgraded from 1.3.148 to 1.3.162 and my software started failing a test case stemming from this:
create table junk (x double, y double as -x); insert into junk values(0.0, 1.0); insert into junk values(-0.0, 1.0); select * from junk; X Y 0.0 -0.0 0.0 -0.0 (2 rows, 0 ms) --- here is the funny one select * from junk where y >= 0.0; X Y (no rows, 0 ms) -- and yet... select -0.0 >= 0.0; TRUE TRUE (1 row, 0 ms) -- 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.
