Email not properly downcased on sign in
- Zendesk ticket: https://gitlab.zendesk.com/agent/tickets/9470
- Dev link: None
- GitLab version: 8.0.4
While troubleshooting #2957 (moved) @DouweM and I discovered an issue with email downcasing when user's are queried on sign in.
If a user's LDAP email address has upper case characters it will be saved to GitLab database lowered. However, on sign in we do not downcase the email address so there is no lookup match on subsequent sign ins. When coupled with a problem like #2957 (moved) the user is unable to sign in.
The query in question:
User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."email" = 'Upper.Case@example.com' ORDER BY "users"."created_at" DESC, "users"."id" DESC LIMIT 1
cc/ @JobV