Check for duplicated usernames and emails when Login with email option is enabled

[rmartinc]

Before reporting an issue

• I have read and understood the above terms for submitting issues, and I understand that my issue may be closed without action if I do not follow them.

Area

user-profile

Describe the bug

Currently the user profile validators check for duplicated username and duplicated emails. But when the option Login with email is enabled (it's enabled by default) it can happen that the username (if it has an email format) collides with another user email. The duplicated username and duplicated email validators should also check for the other field when that option is enabled to avoid duplicates between them.

Version

23.0.7

Regression

• The issue is a regression

Expected behavior

• The validators should check the other field and throw an error because it's duplicated.

Actual behavior

• The validators allow a user to have the same username than another email user and vice-versa.

How to Reproduce?

• In a realm with login with email enabled.
• Create a user with username username1@local.com and email username1@local.org.
• Create a second user with username username2 and email username1@local.com (like the first username).

Anything else?

No response