Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Server    [ Add a report in this area ]  
Report #:  130988   Status: Closed
transaction isolation violation with after triggers
Project:  InterBase Build #:  12.0.1.261
Version:    12.0 Submitted By:   Bruce Horn
Report Type:  Crash / Data loss / Total failure Date Reported:  4/16/2015 3:54:22 AM
Severity:    Critical / Show Stopper Last Updated: 4/29/2015 2:30:13 PM
Platform:    All platforms Internal Tracking #:  
Resolution: Fixed (Resolution Comments) Resolved in Build: : 12.0.2.299
Duplicate of:  None
Voting and Rating
Overall Rating: (2 Total Ratings)
5.00 out of 5
Total Votes: 5
Description
A parent child two table relationship where the child updates the parent after inserts and updates leads to parent changes leaking outside of running transaction when a child is inserted then updated within one transaction, and rollback does not restore parent state.
Steps to Reproduce:
see attachments
1. begin transaction
2. insert into child
3. update child
4. check parent -> visible from external attachments
5. rollback
6. check child removed
7. check parent state not restored
Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01