Symptom
- Table is datarow locking
- Table has a unique non-clustered index
- Index is created with ignore_dup_key
- Insert trigger on table
- Multiple rows inserted which fires trigger with duplicate rows
(1 row affected)
Duplicate key was ignored.
(0 rows affected)
Duplicate key was ignored.
(0 rows affected)
Duplicate key was ignored.
(0 rows affected)
Duplicate key was ignored.
(0 rows affected)
Duplicate key was ignored.
(0 rows affected)
Duplicate key was ignored.
(0 rows affected)
- The result of the table shows that all rows were inserted although "Duplicate key was ignored"
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 SP04
Product
SAP Adaptive Server Enterprise 16.0.4
Keywords
trigger, ignore_dup_key, CR 830661, 830661 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.