If memory serves me right, a number can not be greater than itself, yet MySQL seems to disagree.
mysql> select score,score>7.64 from rateit_files where id=2382; +-------+------------+ | score | score>7.64 | +-------+------------+ | 7.64 | 1 | +-------+------------+ 1 row in set (0.00 sec)
I assume the problem arises because of rounding since score is of type double(4,2). Have done extensive searching of the manual and google but found no reference to this issue. Version is 4.0.16
http://dev.mysql.com/doc/mysql/en/Problems_with_float.html
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
