[ https://issues.apache.org/jira/browse/IGNITE-8756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Denis Magda reassigned IGNITE-8756: ----------------------------------- Assignee: Artem Budnikov > 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: documentation, sql > Affects Versions: 2.5 > Reporter: Andrey Aleksandrov > Assignee: Artem Budnikov > Priority: Major > Labels: doc > Fix For: 2.7 > > > 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)