-20528 THE TARGET OF THE DATA CHANGE OPERATION IS A TABLE table-name, WHICH INCLUDES A PERIOD period-name. A ROW THAT THIS DATA CHANGE OPERATION ATTEMPTED TO MODIFY WAS ALSO MODIFIED BY ANOTHER TRANSACTION.
Explanation
An attempt was made to change a row in a system-period temporal table, but the row has been modified by another transaction. The requested change would result in a row in the associated history table whose row-begin column is higher than the row-end column.
- table-name
- The name of the system-period temporal table.
- period-name
- The name of the period.
This error can occur when two concurrent transactions are accessing the same row for data changes.
System action
The statement cannot be processed.
User response
Reissue the statement.
SQLSTATE
57062