Product Documentation

FairCom DB V12 Release Notes

Previous Topic

Next Topic

SQL - Failed update statement now returns correct error

An issue was discovered with an update statement on a table with a unique or a primary key that caused a duplicate key error. The statement should fail with the following:

Error: -17002 Description: CT - Key value already exists in index...

Either of the following incorrect results could occur:

  • it failed with a different error
  • the transaction could be placed in a bad state, causing further operations to fail with:

error(-17094): CT - Pending error - cannot save or commit tran

The issue does not affect the data because it fails. However, the error code was not properly propagated and the transaction may not be restored to the last good savepoint. The logic has been modified to correct this.

TOCIndex