wild_compare fun: bug in GRANT db_pattern.* ...

1 files changed, 24 insertions, 0 deletions

diff --git a/mysql-test/r/grant2.result b/mysql-test/r/grant2.result
new file mode 100644
index 00000000000..1586375c7d8
--- /dev/null
+++ b/mysql-test/r/grant2.result
@@ -0,0 +1,24 @@
+delete from mysql.user where user like 'mysqltest\_%';
+delete from mysql.db where user like 'mysqltest\_%';
+flush privileges;
+grant all privileges on `my\_%`.* to mysqltest_1@localhost with grant option;
+select current_user();
+current_user()
+mysqltest_1@localhost
+grant all privileges on `my\_1`.* to mysqltest_9@localhost with grant option;
+ERROR 42000: Access denied for user: 'mysqltest_1@localhost' to database 'my\_1'
+grant all privileges on `my_%`.* to mysqltest_2@localhost with grant option;
+select current_user();
+current_user()
+mysqltest_2@localhost
+grant all privileges on `mysql`.* to mysqltest_3@localhost with grant option;
+select current_user();
+current_user()
+mysqltest_3@localhost
+show grants for mysqltest_3@localhost;
+Grants for mysqltest_3@localhost
+GRANT USAGE ON *.* TO 'mysqltest_3'@'localhost'
+GRANT ALL PRIVILEGES ON `mysql`.* TO 'mysqltest_3'@'localhost' WITH GRANT OPTION
+delete from mysql.user where user like 'mysqltest\_%';
+delete from mysql.db where user like 'mysqltest\_%';
+flush privileges;