Stephane,

> in FB 2.5 RC2 it's work perfectly but in the last FB 2.5 snapshot i
> have an error
>
> try this :
>
> CREATE TABLE TEST (
> ID VARCHAR(100),
> Longitude NUMERIC(11,8),
> Latitude NUMERIC(10,8)
> );
> COMMIT;
>
> INSERT INTO TEST (ID, LATITUDE, LONGITUDE) VALUES ('IT-00298601-
> 00298707-00298781', 41.218463, 14.528778);
>
> commit;
>
> 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
>
>
> from FB2.0 to FB 2.5 RC2 no problem
> in FB2.5 last snapshot in have an error saying that Acos must be
> between [1 and -1]

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