Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.5.0
-
None
-
None
Description
The 'name' index on the m_selfservice_beneficiaries_tpt table prevents a client from adding two
Server error:
Duplicate entry 'Clint Westwood-4-\x01' for key 'name' {prepstmnt 128161655 INSERT INTO m_selfservice_beneficiaries_tpt (account_id, account_type, app_user_id, client_id, is_active, name, office_id, transfer_limit) VALUES (?, ?, ?, ?, ?, ?, ?, ?)} [code=1062, state=23000]
mysql> show index from m_selfservice_beneficiaries_tpt;
-------------------------------{}--------{}+{}------{}{}----------{}{}---------{}{}-------{}{}---------{}{}------{}{}----{}{}--{}{}--------{}{}-----{}+{}-------------
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
-------------------------------{}--------{}+{}------{}{}----------{}{}---------{}{}-------{}{}---------{}{}------{}{}----{}{}--{}{}--------{}{}-----{}+{}-------------
| m_selfservice_beneficiaries_tpt | 0 | PRIMARY | 1 | id | A | 1 | NULL | NULL | | BTREE | | |
| m_selfservice_beneficiaries_tpt | 0 | name | 1 | name | A | 1 | NULL | NULL | | BTREE | | |
| m_selfservice_beneficiaries_tpt | 0 | name | 2 | app_user_id | A | 1 | NULL | NULL | | BTREE | | |
| m_selfservice_beneficiaries_tpt | 0 | name | 3 | is_active | A | 1 | NULL | NULL | | BTREE | | |
-------------------------------{}--------{}+{}------{}{}----------{}{}---------{}{}-------{}{}---------{}{}------{}{}----{}{}--{}{}--------{}{}-----{}+{}-------------