> This is not a bug, this is a bug-fix for a validation process/message which was previously missing.
>
> It is likely that it is your example/data which is wrong.
>
>
> Sean

why this is not a bug ? it's work perfectly in all the previous version of firebird, even in 2.5 RC2 and suddenly it's raise an exception ? and even their is no raison to raise an exception :

also why if i do instead of

Select
ACOS((SIN(latitude*(0.0174532925)) * SIN(0.71939789)) +
(COS(latitude*(0.0174532925)) * COS(0.71939789) * COS(0.25357501 -
(Longitude*(0.0174532925))))) * 6371
from
TEST

directly

Select
ACOS((SIN(41.218463*(0.0174532925)) * SIN(0.71939789)) +
(COS(41.218463*(0.0174532925)) * COS(0.71939789) * COS(0.25357501 -
(14.528778*(0.0174532925))))) * 6371
from
TEST


(IE: it's exactly the same as previous, i replace longitude and latitude by their value) then it's WORK !!

and also

(SIN(latitude*(0.0174532925)) * SIN(0.71939789)) +
(COS(latitude*(0.0174532925)) * COS(0.71939789) * COS(0.25357501 -
(Longitude*(0.0174532925)))) is alway <= 1 (here it's egal to 0.999999999999994) ! so why ACOS[1] will raise an exception saying that the value must be between [-1..1] ?

an very good online scientifique calculator:
http://web2.0calc.com/

thanks for all !
stephane