summaryrefslogtreecommitdiff
path: root/mysql-test/suite/roles
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-11-10 17:50:52 +0100
committerSergei Golubchik <sergii@pisem.net>2013-11-10 17:50:52 +0100
commit09b63917be4cfb5f5af9c74c8d0d8b7b4307cb1c (patch)
tree3ac87bff89d6c9005682b52d098c819df1c0f639 /mysql-test/suite/roles
parentab2bf1ad0bd268e305233d0464fdf8ae408861f5 (diff)
downloadmariadb-git-09b63917be4cfb5f5af9c74c8d0d8b7b4307cb1c.tar.gz
MDEV-5238 Server crashes in find_role_grant_pair on SHOW GRANTS for an anonymous user
Diffstat (limited to 'mysql-test/suite/roles')
-rw-r--r--mysql-test/suite/roles/show_grants_anon-5238.result12
-rw-r--r--mysql-test/suite/roles/show_grants_anon-5238.test17
2 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/suite/roles/show_grants_anon-5238.result b/mysql-test/suite/roles/show_grants_anon-5238.result
new file mode 100644
index 00000000000..85be1ac92f3
--- /dev/null
+++ b/mysql-test/suite/roles/show_grants_anon-5238.result
@@ -0,0 +1,12 @@
+create user ''@localhost;
+create role r1;
+grant r1 to ''@localhost;
+select current_user;
+current_user
+@localhost
+show grants;
+Grants for @localhost
+GRANT r1 TO ''@'localhost'
+GRANT USAGE ON *.* TO ''@'localhost'
+drop role r1;
+drop user ''@localhost;
diff --git a/mysql-test/suite/roles/show_grants_anon-5238.test b/mysql-test/suite/roles/show_grants_anon-5238.test
new file mode 100644
index 00000000000..adb22490233
--- /dev/null
+++ b/mysql-test/suite/roles/show_grants_anon-5238.test
@@ -0,0 +1,17 @@
+#
+# MDEV-5238 Server crashes in find_role_grant_pair on SHOW GRANTS for an anonymous user
+#
+--source include/not_embedded.inc
+
+create user ''@localhost;
+create role r1;
+grant r1 to ''@localhost;
+
+--connect (con1,localhost,nonexisting_user,,)
+select current_user;
+show grants;
+
+connection default;
+drop role r1;
+drop user ''@localhost;
+