Simple comparison operator failure

2003-11-17 Thread philip villars
I encountered a problem where a simple comparison operation seemed to fail. Has anyone else seen this? Take a simple table: a FLOAT(10, 2) b DOUBLE With data: +--+--+ | a| b| +--+--+ | 1.50 |1 | | 6.00 |4 | | 5.60 |4 | +--+--+ Then do a

RE: Simple comparison operator failure

2003-11-17 Thread philip villars
Hello All, Upon further review, my question involving the unexpected comparison operator behavior IS discussed in the documentation, specifically section A.5.7 Problems with Floating-Point Comparison. My bad -- thought I'd checked everywhere. Doesnt' look like there's a great solution,