Subject Explanation about delta rows
Author W O
Hello everybody

I have some doubts about delta rows.

Transaction 510 inserts a row with this values (ID=2500,
LASTNAME='Kennedy', FIRSTNAME='John', SALARY=28000)

Transaction 510 commits

Transaction 526 updates that row with this values (ID=2500, SALARY=31000)

How are in the database the rows now?

1. TRANSACTION=510, ID=2500, LASTNAME='Kennedy', FIRSTNAME='John',
SALARY=28000
TRANSACTION=526, SALARY=31000

2. TRANSACTION=526, ID=2500, LASTNAME='Kennedy', FIRSTNAME='John',
SALARY=31000
TRANSACTION=510, SALARY=28000

3. Another way

After transaction 526 commits, how are in the database the rows? Same as
before the commit or different?

Which of the rows is called the "delta" row?

Greetings.

Walter.


[Non-text portions of this message have been removed]