From a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 Mon Sep 17 00:00:00 2001
From: Michael Widenius <monty@mariadb.org>
Date: Fri, 9 Mar 2018 14:05:35 +0200
Subject: Create 'main' test directory and move 't' and 'r' there

---
 mysql-test/main/grant5.test | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 mysql-test/main/grant5.test

(limited to 'mysql-test/main/grant5.test')

diff --git a/mysql-test/main/grant5.test b/mysql-test/main/grant5.test
new file mode 100644
index 00000000000..14f2fd65020
--- /dev/null
+++ b/mysql-test/main/grant5.test
@@ -0,0 +1,25 @@
+-- source include/not_embedded.inc
+
+#
+# MDEV-6625 SHOW GRANTS for current_user_name@wrong_host_name
+#
+--error ER_NONEXISTING_GRANT
+SHOW GRANTS FOR root@invalid_host;
+
+#
+# MDEV-9580 SHOW GRANTS FOR <current_user> fails
+#
+create user test;
+create user foo;
+create role foo;
+grant foo to test;
+--connect (conn_1, localhost, test,,)
+set role foo;
+show grants for test; # user
+show grants for foo;  # role
+--error ER_DBACCESS_DENIED_ERROR
+show grants for foo@'%'; # user
+--connection default
+drop user test, foo;
+drop role foo;
+
-- 
cgit v1.2.1