Hi,

>> This doesn't fix this problem:
>>
>> SELECT
>> *
>> FROM
>> TableX x
>> WHERE
>> x.ID IN (SELECT FIRST 5 y.ID FROM TableY)
>>
>> Which is the same problem IMO.
>
> Nope. The problem you're talking about is fixed in FB2.

Correct i forgot about that you fixed this, but it's fixed another way. The x.ID can't be used with
an index which would be nice if it could.

Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info