email comparisons in the auth module fail is auth data in uppercase

[DavidiBeMe]

We have populated our web2py auth database via a script and the emails were entered in uppercase. When we tried to login, we received the "invalid credentials" error message.

After investigation, we found that the comparisons on the email address were based on lowercase and did not convert the values to lowercase. I also noticed that if you create your login accounts via the UI, it converts the email address to lower case during account creation. This means that this issue is primarily for the cases where the auth user database is populated via a script. Either we would need to specify that the data must be entered always in lowercase or we need to modify all the comparisons performed in auth.py to compare in lowercase.

[mdipierro]

Can you provide a more concrete example?