> > > Will this be solved in FB 2?
> >
> > I doubt it ...
>
> This particular issue is solved in v2.0.

A, good :-)

> > 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.
> >
> > Same issue:
> >
> > insert into mytable
> > select * from mytable
>
> This is another issue, although looking similarly.

I figured it would be the same. Is the issue fixed for subqueries
only then? Or only for FIRST subqueries?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com