|Subject||Re: [Firebird-Architect] the insert into t select * from t infinite loop|
Claudio Valderrama C. wrote:
>>-----Original Message-----That would be a complication, yes.
>>[mailto:Firebird-Architect@yahoogroups.com]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.