803246 - Need Persona production percentages for "plus" style email addressees

Status: RESOLVED WONTFIX

(Cloud Services :: Operations: Miscellaneous, task)

Description

[Austin King [:ozten]]

jrgm has identified[1] that if gmail.com email addresses were to become Primaries, it would break sign in for those users. This is true for the general class of "plus" email addresses.

Please run the following SQL:

select count(id) as plus_gmail from email where address LIKE '[e-mail]';
select count(id) as all_gmail  from email where address LIKE '[e-mail]';
select count(id) as plus_yahoo from email where address LIKE '[e-mail]';
select count(id) as all_yahoo  from email where address LIKE '[e-mail]';
select count(id) as all_users  from email;

Update this bug with the results of the following calculations:
* plus_gmail / all_gmail
* plus_gmail / all_users
* plus_yahoo / all_yahoo
* plus_yahoo / all_users

This shouldn't require any privacy guards as it will be 4 % measurements.

[1] https://github.com/mozilla/browserid-bigtent/issues/12

Comment 1

[Dan Callahan [:callahad]]

It would also be nice to include Hotmail in the query, if possible.

And just for emphasis, Hotmail and Gmail use a '+' for extended addresses, while Yahoo uses a '-', despite the "plus_yahoo" result name :)

Thanks!