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": [
"[email protected]"
]
}
]
}
2. Trying to change email to "[email protected]" gives an error: "A violation
of the constraint imposed by a unique index or a unique constraint occurred"
3. Looking for "[email protected]", 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": [
"[email protected]"
]
}
]
}
],
"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
