Subject Re: FB2 Integer overflow
Author Adam
--- In, "leugim@..." <leugim@...> wrote:
> Hello,
> 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 <

My guess is that the field order is mixed. Have you tried to
explicitly name each field in your statement.

insert into ATABLE_20060701 (field1, field2) select field1, field2
from ATABLE where ATime < '2006-07-01';