| Subject | Re: [Firebird-Architect] Re: the insert into t select * from t infinite loop |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-07-05T15:59:04Z |
Dmitry Yemanov wrote:
effect, without the overhead, using an existing mechanism, maybe we can
solve the problem.
Regards,
Ann
>The keyword in that statement is "effectively". If we can get the
> 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.
effect, without the overhead, using an existing mechanism, maybe we can
solve the problem.
Regards,
Ann