|Subject||Re: [firebird-support] Re: Problem with FIRST in where clause|
> > First n doesn't work properly in a subquery.I doubt it ...
> Will this be solved in FB 2?
Whenever the/a subquery is not depending on items in
the outer query, it should materialize this result first and
then use the cached result. Firebird doesn't do this. Ever.
insert into mytable
select * from mytable
-> this will create an endless loop, while it's perfectly
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!