harbour 3.0 ceiling(101.2/2.53)==41 bug?

[ShumingWang]

Hi, call Harbour 3.0 function
?ceiling(101.2/2.53)
// 41
// Should be 40.
Regards!
Shuming Wang

[Enrico Maria Giordano]

I get the same result using this C sample:

Code: Select all  Expand view

#include <stdio.h>
#include <math.h>


int main()
{
    printf( "%lf\n", ceil( 101.2 / 2.53 ) );
    return 0;
}

It's a well known problem with floating-point numbers. The result of the division is probably a little more than 40 (ie. 40.000000000001) so ceil() gives 41. You have to working around the problem using some sort of rounding.

EMG

[ShumingWang]

EMG,
2.53X40==101.20
MySQL select ceiling(101.2/2.53)
// 40
Regards!
Shuming Wang

[Enrico Maria Giordano]

Please read something about floating-point numbers. I repeat: it's a well known problem and no, it's not specific of a particular programming language.

EMG