userName attribute should be case-insensitive, per the RFC
Closed this issue · 3 comments
logston commented
See https://datatracker.ietf.org/doc/html/rfc7643#section-4.1.1: (userName)
This attribute is REQUIRED and is case insensitive.
Currently this case-insensitive behavior is not implemented and the filter lookups are case-sensitive.
logston commented
To tackle this problem, we need if there is a db agnostic means of comparing two strings in a case insensitive way. For example, do all databases support UPPER (ie. UPPER(email) = UPPER(test@example.com)`)?
andersk commented
UPPER is part of the SQL standard, and supported by at least MySQL, PostgreSQL, and SQLite.
logston commented
Pushed another set of changes.