Subject RE: [firebird-support] select * order by.. error in Firebird 1.5.1
Author Paul Beach
> 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 ?

Can Firebird write temporary files for sorts? I would suspect that
2730 is a sort done in memory whilst anything over that requires
a sort on disk. Firebird can't create the sort file, because it can't
access the tmp area to create it.