Users using a username with cases diferent than what were used at creation time
Environment
Vertica analytics database: v23.4 and above
Situation
Users created with md5 hashing algorithm experience authentication failures if the cases of usernames are different -
test=> create user ajilani1 identified by 'abc123';
CREATE USER
test=> ALTER USER ajilani1 SECURITY_ALGORITHM 'MD5';
WARNING 9760: MD5 authentication is deprecated
ALTER USER
test=>
[dbadmin@ajilani07 ~]$ vsql -U ajilani1 -w abc123
Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type: \h or \? for help with vsql commands
\g or terminate with semicolon to execute query
\q to quit
test=>
test=> \q
[dbadmin@ajilani07 ~]$
[dbadmin@ajilani07 ~]$
[dbadmin@ajilani07 ~]$ vsql -U AJILANI1 -w abc123
vsql: FATAL 2248: Authentication failed for username "AJILANI1"
Here in the 2nd failed attempt, we are using uppercase in the username while authentication.
