"Martijn Tonies" <m.tonies@...> wrote:

>
> > Will this be solved in FB 2?
>
> I doubt it ...

This particular issue is solved in v2.0.

> 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.


Dmitry