Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support RENAME USER command #23648

Closed
morgo opened this issue Mar 29, 2021 · 0 comments · Fixed by #24413
Closed

Support RENAME USER command #23648

morgo opened this issue Mar 29, 2021 · 0 comments · Fixed by #24413
Assignees
Labels
type/feature-request Categorizes issue or PR as related to a new feature.

Comments

@morgo
Copy link
Contributor

morgo commented Mar 29, 2021

Feature Request

Is your feature request related to a problem? Please describe:

mysql [localhost:8023] {msandbox} (test) > create user first;
Query OK, 0 rows affected (0.01 sec)

mysql [localhost:8023] {msandbox} (test) > rename user first to second;
Query OK, 0 rows affected (0.00 sec)

mysql [localhost:8023] {msandbox} (test) > show grants for second;
+------------------------------------+
| Grants for second@%                |
+------------------------------------+
| GRANT USAGE ON *.* TO `second`@`%` |
+------------------------------------+
1 row in set (0.00 sec)

In TiDB:

mysql> create user first;
Query OK, 0 rows affected (0.00 sec)

mysql> rename user first to second;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 11 near "user first to second" 

Describe the feature you'd like:

See above. I noticed this while porting tests for dynamic privileges - I don't have an active need for it.

Describe alternatives you've considered:

N/A

Teachability, Documentation, Adoption, Migration Strategy:

MySQL compatibility.

@morgo morgo added the type/feature-request Categorizes issue or PR as related to a new feature. label Mar 29, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/feature-request Categorizes issue or PR as related to a new feature.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants