|Subject||Re: [firebird-support] Re: Problem with FIRST in where clause|
> > > Will this be solved in FB 2?A, good :-)
> > I doubt it ...
> This particular issue is solved in v2.0.
> > Whenever the/a subquery is not depending on items inI figured it would be the same. Is the issue fixed for subqueries
> > the outer query, it should materialize this result first and
> > then use the cached result. Firebird doesn't do this. Ever.
> > Same issue:
> > insert into mytable
> > select * from mytable
> This is another issue, although looking similarly.
only then? Or only for FIRST subqueries?
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!