Subject | RE: [Firebird-Architect] the insert into t select * from t infinite loop |
---|---|
Author | Claudio Valderrama C. |
Post date | 2005-07-06T04:58:31Z |
> -----Original Message-----Verb backout... Ann wrote about undo list.
> From: Firebird-Architect@yahoogroups.com
> [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.
I hope this is not affected by isc_tpb_no_auto_undo.
C.