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)
|
Bug
Minor
