View Revisions: Issue #6617

All RevisionsBack to Issue
Summary 0006617: Update trigger to accommodate NULLs for unique index with NULLable columns
Revision 2024-10-11 20:11 by pbelov
Steps To Reproduce Update trigger is constructed in such a way that it is not working for the case:
- Table does not have a PrimaryKey
- Table has a Unique index instead
- Column which is part of Unique index is NULLable
- Update is performed on a row :
  * Updated column is not part of the unique index;
  * There was already a NULL in the column, which is part unique index (this value is unaffected by the update)
Observe:
Row change is not captured by the SymmetricDS trigger.
Revision 2024-10-11 16:26 by pbelov
Steps To Reproduce