Subject Re: [Firebird-Architect] the insert into t select * from t infinite loop
Author Jim Starkey
Claudio Valderrama C. wrote:

>>-----Original Message-----
>>[]On Behalf Of Jim Starkey
>>The problem is, in fact, quite simple, and Ann has sketched the
>>solution. All that is necessary is to track the record numbers of newly
>>inserted records so the outer select can ignore them. This is
>>particularly easy since a bitmap of those records is already maintained
>>for verb backout. All we need to do is use it. And the best way to use
>>it is just another very simple RSB type.
>Verb backout... Ann wrote about undo list.
>I hope this is not affected by isc_tpb_no_auto_undo.
That would be a complication, yes.