Kbase P96062: Are sequences rolled back when a transaction is undone?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2008 |
|
Status: Verified
GOAL:
Are sequences rolled back when a transaction is undone?
GOAL:
Why sequences are not undone in transactions?
FIX:
Because of transaction independence, sequences do not roll back when transactions are undone, but maintain their last value for all UNDOs. However, fields defined in control tables do roll back to their pretransaction values, as long as all updates to control tables respect transaction boundaries.