Round Function Error

Hi,

I'm using mysql 4.0.16-standard on Linux.

I've just noticed this:

mysql> select round(0.5);
+------------+
| round(0.5) |
+------------+
|          0 |
+------------+
1 row in set (0.00 sec)

--

mysql> select round(0.500001);
+-----------------+
| round(0.500001) |
+-----------------+
|               1 |
+-----------------+
1 row in set (0.00 sec)

--

Is it not the case that 0.5 should be rounded UP?

--
Mark