OK, now we’re using the latest LTA (v2025.1.1 (104738) to be exact).
Some quick checks assured that the problem described above still persists.
Moreover:
- I have removed the john_doe1234 user via database changes. This is the user that SQ created earlier with the john.doe@newaddress.com email address.
- I updated (via DB UPDATE) the email field in the original john_doe users record to john.doe@newaddress.com
The login still fails:
2025.04.11 08:28:30 DEBUG web[649d7796-74e8-4f41-ab1d-e1d96c82dd4b][auth.event] login failure [cause|Email ‘john.doe@newaddress.com’ is already used][method|FORM][provider|REALM|ldap][IP|127.0.0.1|10.164.153.250][login|john_doe]
Which is funny, since the following two SELECT statements yield the same row:
SELECT * FROM users WHERE email = 'john.doe@newaddress.com';
SELECT * FROM users WHERE name = 'john_doe';