Hello,

i suppose there is a bug in the 64 bit IO Version of the Firebird
Server in the handling of external tables larger than 2 GB.

I use the FirebirdSS-1.0.0.796-0.64IO for Intel on RedHat 7.3 and
SuSE 7.2. For copying data from one Database to another i use
external tables. Now i come to a point where one external table
is about 2 1/2 Gigabyte. While Firebird writes the external file
without any problem, Firebird is not able to read the whole
external file.

If i try to copy the external table into an internal table, after
a while i get these error message:

I/O error for file "/tmp/external_table"
-Error while trying to open file
-Invalid argument


It seems, that i can use this external_table as long as the data
in the external file does not exceed the 2GB border.


select first 10 * from external_table

works fine, but

select count(*) from external_table

raises an error

COUNT
============
Statement failed, SQLCODE = -902

I/O error for file "/tmp/external_table"
-Error while trying to open file
-Invalid argument

Is this an known bug?

Bye

Nils