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

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

Reply via email to