search

mozilla / fxa-auth-db-mysql

DEPRECATED - Migrated to https://github.com/mozilla/fxa
Mozilla Public License 2.0
12 stars 26 forks source link

fix(account): don't use `LOWER(uid)` in account query, update `accountRecord` #441

Closed vbudhram closed 5 years ago

vbudhram commented 5 years ago

Fixes #438 Connects to https://github.com/mozilla/fxa-auth-db-mysql/issues/440

Opted to pull these two issues into one migration since they were both fairly small and not to introduce too much headache with merge conflicts for https://github.com/mozilla/fxa-auth-db-mysql/pull/436.

First commit: Removes the LOWER(uid) from the account_ stored procedure since it doesn't really change the query.

Second commit: From https://github.com/mozilla/fxa-auth-db-mysql/issues/440, it specifies the charact set for inEmail as utf8 for the accountRecord_ procedure. It also re enables coalescing in SQL rather than in code.