Andrey Aleksandrov created IGNITE-8756: ------------------------------------------
Summary: SQL: CREATE/ALTER USER documentation should contain information about case sensitivity of username Key: IGNITE-8756 URL: https://issues.apache.org/jira/browse/IGNITE-8756 Project: Ignite Issue Type: Improvement Components: sql Affects Versions: 2.5 Reporter: Andrey Aleksandrov Fix For: 2.6 Now documentation contains next: https://apacheignite-sql.readme.io/docs/create-user#section-description For instance, if {{test}} was set as a username then: * You can use {{Test}}, {{TEst}}, {{TEST}} and other combinations from JDBC and ODBC. * You have to use {{TEST}} as the username from Ignite's native SQL APIs designed for Java, .NET and other programming languages. But next behavior exists: When you create the user in quotes ("test") using SQL as next: CREATE USER "test" WITH PASSWORD 'test' It will be created as it was set (in this case it will be test) If you create the user without quotes (test) using SQL as next: CREATE USER test WITH PASSWORD 'test' then username will be stored in uppercase (TEST). The same situation with ALTER USER. The documentation should be updated to clear that SQL supports case sensitive data too (using quotas). -- This message was sent by Atlassian JIRA (v7.6.3#76005)