If SP has been BF-aborted, it should not retry if data has been sent back

Description

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.

 

Environment

None

Smart Checklist

Activity

Show:
Duplicate

Details

Assignee

Reporter

Affects versions

Priority

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