>>>>> "Sasha" == Sasha Pachev <sasha@stripped> writes:
Sasha> John Cartwright wrote:
>> The manual seems to have a typo in section 7.4.9 describing the
>> ROUND(X,D) function. There is a statement that "Note that the return
>> value is converted to a BIGINT!". While I presume that this is true for
>> the ROUND(X) call, It doesn't make sense to me for the
>> ROUND(X,D) call given that it returns a float. Does it return a float
>> even if called with D=0?
Sasha> You are correct -- the manual is not very clear -- we will make the
Sasha> changes .
Sasha> if D=0 the conversion is to BIGINT:
mysql> select round(3.39,0);
Sasha> | round(3.39,0) |
Sasha> | 3 |
Sasha> 1 row in set (0.00 sec)
I just checked the source; round() is not converted to an integer.
floor() and ceiling() is however converted to integers.
I have now updated the manual with this!