[jira] [Created] (IGNITE-8756) SQL: CREATE/ALTER USER documentation should contain information about case sensitivity of username

[Anton Vinogradov (Jira)]

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)