> Why FB (2.1.1 at least) consider any floating-point constant as type
> float instead of double precision?
>
> SQL> select 1.14155251141552511e-5 from rdb$database;
>
> CONSTANT
> =======================
> 0.000011

It is only formatting problem of ISQL. This is what I get in FSQL:

select 1.14155251141552511e-5 from rdb$database;
CONSTANT
======================
1.141552511415525E-05


Or you can let the FB server do the conversion Double->Varchar:

select cast(1.14155251141552511e-5 as varchar(20)) from rdb$database;
CAST
====================
1.141552511416e-005


Ivan
http://www.volny.cz/iprenosil/interbase/fsql.htm