sql: Incorrect documentation on Username constraints

[pawalt]

Peyton Walters (pawalt) commented:

Our docs on username considerations state that usernames must begin with a letter, number, or underscore, but testing against cockroach demo shows that you can't start with an underscore:

demo@127.0.0.1:26257/movr> create user 123test;
invalid syntax: statement ignored: at or near "123": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
create user 123test
            ^
HINT: try \h CREATE ROLE
demo@127.0.0.1:26257/movr> create user test;
CREATE ROLE


Time: 30ms total (execution 29ms / network 1ms)

demo@127.0.0.1:26257/movr> create user _test;
CREATE ROLE


Time: 30ms total (execution 30ms / network 0ms)

Jira Issue: DOC-5839

[exalate-issue-sync]

Ashley Tam (ashleykwtam) commented:
testing against cockroach demo shows usernames test and _test work but 123test does not. Usernames cannot begin with a number