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.
>
> No, there are one more problem - INSERT provided by Ann in the
> subject will loop infinite since SELECT can see new inserted records
> and never stops.

That's the same reason why the "SELECT FIRST 5 ..." also fails? If the results from the sub-query in
the IN predicate are first put into a temporary list and that is used as "lookup list" both problems
are solved.

Regards,
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