Dear all, I have defined a plain attribute "u_email" for USER with "uniqueConstraint": true.
For some obscure reasons (several successive modifications of this attribute), I am stuck with this situation: 1. The user "foo" has this email: GET /syncope/rest/users/foo { "key": "018e75cc-1d7b-7aef-94ef-ec26528c775e", "username": "foo", "plainAttrs": [ { "schema": "u_email", "values": [ "foo_...@gmail.com" ] } ] } 2. Trying to change email to "foo_...@gmail.com" gives an error: "A violation of the constraint imposed by a unique index or a unique constraint occurred" 3. Looking for "foo_...@gmail.com", I get the user "foo": GET /syncope/rest/users?fiql=u_email%3D%3Dfoo_two%40gmail.com { "result": [ { "key": "018e75cc-1d7b-7aef-94ef-ec26528c775e", "username": "foo", "plainAttrs": [ { "schema": "u_email", "values": [ "foo_...@gmail.com" ] } ] } ], "page": 1, "size": 1, "totalCount": 1 } Looking into the database, I found that there are 2 entries for the attribute "u_email" in the table "uplainattruniquevalue". I guess it's not the normal case, so I wonder if I can safely remove the entry which causes the violation? I'm also interested in discovering the cause of this situation if someone has an idea Best regards, Lionel
smime.p7s
Description: S/MIME Cryptographic Signature