Hi,

I'm running Firebird 1.5.1 on gentoo linux (kernel 2.6.8.1).
Firebird is installed via gentoo 'emerge' (auto compiles from source).
It should be a super server.

I have a basic test table :
create table TEST_A ( id integer, name char(20))

Running from isql on the local pc:
select * from TEST_A order by id

produce the following error when the table has up to a certain rows.
In my test, query up to 2730 rows is fine. More than that results in
the following error (more columns, less rows) :

------
SQL> select * from test_a order by id;
Statement failed, SQLCODE = -902

I/O error for file ""
-Error while trying to open file
-Permission denied
------

I must add that query without 'order by' runs fine, tested with no
problem with 100,000 rows.

Similar test runs without any issue on Firebird 1.0.3 / Win98.

I suspect it may be some configuration issue. I've not touch any
configuration files at all. Such an often used 'order by' query
should not be a bug right ?

Thanks,
Albert