Subject Re: [firebird-support] Re: Problem with FIRST in where clause
Author Dmitry Yemanov
"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.