Subject | Re: Thank you both |
---|---|

Author | svanderclock |

Post date | 2010-04-16T18:15:05Z |

> This is not a bug, this is a bug-fix for a validation process/message which was previously missing.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 :

>

> It is likely that it is your example/data which is wrong.

>

>

> Sean

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