> On one of our client server where I did an upgrade from Fb1.5 to Fb2 I
> had the the following problem when executing a query (this copy about
> 5e6 of records from table ATABLE to an archive table ATABLE_20060701):
>
> insert into ATABLE_20060701 select * from ATABLE where ATime < '2006-07-01';
>
> The message I've got is:
> Integer overflow
> insert into ATABLE_20060701 select * from ATABLE where ATime < '2006-07-01';

"Integer overflow" error is not raised by simple assignment,
but by some arithmetic operation. Are you absolutely sure
that no triggers nor computed fields are involved ?

What application did you use ? Is not it possible that copying executes
just fine, but the error is caused by bug in application that tries
to report number of affected records ?

Ivan