Subject Re: [Firebird-Architect] Re: Indexing tales - part 1 - Siblings
Author Ann W. Harrison
Ann W. Harrison wrote:
> ... we don't do internal deadlocks. A transaction
> gets a deadlock error if and only if it has a record level conflict
> on an update or delete with a concurrent transaction updating or
> deleting the same record.

She meant to include the case where A has resource 1 and wants
resource 2, B has resource 2 and wants resource 3, C has resource
3 and wants 4 ... Z has resource 26 and wants 1. A deadlock can
involve lots of transactions, but the conflict is on records,
never on internal structures.