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)
