Description:
following mysql-test script return error despite operation allowance.
But repeat of 'use <database>' command refresh ACL and command becomes allowed (see
commented line in the script)
How to repeat:
connect (root,localhost,root,,test);
connection root;
--disable_warnings
create database mysqltest;
--enable_warnings
grant create,select on test.* to mysqltest_1@localhost;
connect (user1,localhost,mysqltest_1,,test);
connection user1;
create table t1 (a int);
connection root;
grant create,drop,select on test.* to mysqltest_1@localhost;
connection user1;
# if uncomment following command bug will gone
#use test;
drop table t1;
connection root;
revoke all privileges on test.* from mysqltest_1@localhost;
drop database mysqltest;
