As this is slightly relevant when constructing search queries for stats.
e.g. from https://wikimedia.biterg.io/edit/app/kibana#/discover in the gerrit index :
author_name Sam Reed author_user_name reedy name Reedy
Seeing e.g. https://gerrit.wikimedia.org/r/#/c/383289/ , Reedy is used.
Looking at the DB dump,
- as the profile name, Sam Reed is set.
- as the gerrit username, it is sometimes reedy and sometimes null and sometimes an empty string.
- as the gerrit name, it is sometimes Reedy and sometimes Sam Reed