Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3, 10.4
-
None
Description
MDEV-20076 introduced a massive change of quote marks in SHOW GRANTS output. However, if the goal was to convert them uniformly to backquotes, it didn't happen. GRANT PROXY still uses single quotes.
MariaDB [test]> create user foo@localhost; |
Query OK, 0 rows affected (0.000 sec) |
|
|
MariaDB [test]> grant proxy on 'x-x' to foo@localhost; |
Query OK, 0 rows affected (0.000 sec) |
|
|
MariaDB [test]> show grants for foo@localhost; |
+-----------------------------------------------+ |
| Grants for foo@localhost | |
+-----------------------------------------------+ |
| GRANT USAGE ON *.* TO `foo`@`localhost` | |
| GRANT PROXY ON 'x-x'@'%' TO 'foo'@'localhost' | |
+-----------------------------------------------+ |
2 rows in set (0.000 sec) |
|
|
MariaDB [test]> set sql_mode='ORACLE'; |
Query OK, 0 rows affected (0.000 sec) |
|
|
MariaDB [test]> show grants for foo@localhost; |
+-----------------------------------------------+ |
| Grants for foo@localhost | |
+-----------------------------------------------+ |
| GRANT USAGE ON *.* TO "foo"@"localhost" | |
| GRANT PROXY ON 'x-x'@'%' TO 'foo'@'localhost' | |
+-----------------------------------------------+ |
2 rows in set (0.000 sec) |
Attachments
Issue Links
- relates to
-
-
- Closed
-