diff options
Diffstat (limited to 'mysql-test/t/grant.test')
| -rw-r--r-- | mysql-test/t/grant.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index 0bb83891fe2..34d9a09cba7 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -1,5 +1,8 @@ # Test of GRANT commands +# Grant tests not performed with embedded server +-- source include/not_embedded.inc + # Cleanup --disable_warnings drop table if exists t1; @@ -381,3 +384,22 @@ drop database mysqltest_2; # just SHOW PRIVILEGES test # SHOW PRIVILEGES; + +# +# Rights for renaming test (Bug #3270) +# +connect (root,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK); +connection root; +--disable_warnings +create database mysqltest; +--enable_warnings +create table mysqltest.t1 (a int,b int,c int); +grant all on mysqltest.t1 to mysqltest_1@localhost; +connect (user1,localhost,mysqltest_1,,mysqltest,$MASTER_MYPORT,$MASTER_MYSOCK); +connection user1; +-- error 1142 +alter table t1 rename t2; +connection root; +revoke all privileges on mysqltest.t1 from mysqltest_1@localhost; +delete from mysql.user where user=_binary'mysqltest_1'; +drop database mysqltest; |