Subject Re: [Firebird-Architect] Re: the insert into t select * from t infinite loop
Author Ann W. Harrison
Dmitry Yemanov wrote:
> And this is what the SQL spec explicitly requires:
> 13) Let QT be the table specified by the <query expression>
> ...
> 5) QT is effectively evaluated before insertion of any rows into T.

The keyword in that statement is "effectively". If we can get the
effect, without the overhead, using an existing mechanism, maybe we can
solve the problem.