summaryrefslogtreecommitdiff
path: root/mysql-test/main/connect.result
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2019-11-06 12:35:19 +0100
committerOleksandr Byelkin <sanja@mariadb.com>2020-02-05 17:22:26 +0100
commitfafb35ee517f309d9e507f6e3908caca5d8cd257 (patch)
tree2b077c5fb367d221dd03b30365e66e9a8aa3b28f /mysql-test/main/connect.result
parentb3ded21922fc684c3c1aeb4ad57161bc2fec5859 (diff)
downloadmariadb-git-fafb35ee517f309d9e507f6e3908caca5d8cd257.tar.gz
MDEV-20076: SHOW GRANTS does not quote role names properlybb-10.3-MDEV-20076
Quotes added to output.
Diffstat (limited to 'mysql-test/main/connect.result')
-rw-r--r--mysql-test/main/connect.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/connect.result b/mysql-test/main/connect.result
index 057105d192f..82007994eed 100644
--- a/mysql-test/main/connect.result
+++ b/mysql-test/main/connect.result
@@ -108,12 +108,12 @@ update mysql.user set password=old_password("gambling2") where user=_binary"test
flush privileges;
show grants for test@localhost;
Grants for test@localhost
-GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost' IDENTIFIED BY PASSWORD '2f27438961437573'
+GRANT ALL PRIVILEGES ON *.* TO `test`@`localhost` IDENTIFIED BY PASSWORD '2f27438961437573'
update mysql.user set plugin='mysql_old_password' where user='test';
flush privileges;
show grants for test@localhost;
Grants for test@localhost
-GRANT ALL PRIVILEGES ON *.* TO 'test'@'localhost' IDENTIFIED BY PASSWORD '2f27438961437573'
+GRANT ALL PRIVILEGES ON *.* TO `test`@`localhost` IDENTIFIED BY PASSWORD '2f27438961437573'
connect con10,localhost,test,gambling2,;
connect con5,localhost,test,gambling2,mysql;
connection con5;