Duplicate
Details
Assignee
UnassignedUnassignedReporter
KennTKennT(Deactivated)Affects versions
Priority
Medium
Details
Details
Assignee
Unassigned
UnassignedReporter
KennT
KennT(Deactivated)Affects versions
Priority
Smart Checklist
Smart Checklist
Smart Checklist
Created November 25, 2019 at 4:51 AM
Updated March 6, 2024 at 10:01 PM
Resolved January 23, 2023 at 2:32 PM
Currently, if a SP is BF-aborted, the SP will retry.
If no data has been sent back (say the SP contains only UPDATE/INSERT), then it is ok to retry the SP, since it will have been rolled back.
The problem occurs if data has been sent back. The client will already have received data, but the client has no way of knowing that the data is incomplete. Also, the client will receive more result sets than expected, since the entire SP is retried.
The proposal is to not allow the SP to be retried if data has been sent back to the client. This will allow us to return an error and for any returned data to be discarded.