Subject select * order by.. error in Firebird 1.5.1
Author Albert

I'm running Firebird 1.5.1 on gentoo linux (kernel
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 ?