diff options
| author | unknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru> | 2007-04-24 10:27:59 +0500 |
|---|---|---|
| committer | unknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru> | 2007-04-24 10:27:59 +0500 |
| commit | b8850e15db3452924b9f4f30c08b665b0151efdc (patch) | |
| tree | 6d6b4b31b88b6bbeb2beb8979b2f1c56d599427f /mysql-test/t/grant.test | |
| parent | 0ab74abc6395af5949d3797c6a9037f3317a0acd (diff) | |
| parent | 50e158402bf51521dce5fb69be9100cc8ccfebd7 (diff) | |
| download | mariadb-git-b8850e15db3452924b9f4f30c08b665b0151efdc.tar.gz | |
Merge mysql.com:/home/ram/work/b27515/b27515.4.1
into mysql.com:/home/ram/work/b27515/b27515.5.0
mysql-test/r/grant.result:
will be merged in a post-merge CS
mysql-test/t/grant.test:
manual merge
sql/sql_parse.cc:
manual merge
Diffstat (limited to 'mysql-test/t/grant.test')
| -rw-r--r-- | mysql-test/t/grant.test | 23 |
1 files changed, 22 insertions, 1 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index 82bf011d32f..d219e5bc480 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -540,7 +540,28 @@ delete from mysql.tables_priv where user='mysqltest1'; flush privileges; drop database mysqltest; -# End of 4.1 tests +# +# Bug #27515: DROP previlege is not required for RENAME TABLE +# +connection master; +create database db27515; +use db27515; +create table t1 (a int); +grant alter on db27515.t1 to user27515@localhost; +grant insert, create on db27515.t2 to user27515@localhost; + +connect (conn27515, localhost, user27515, , db27515); +connection conn27515; +--error 1142 +rename table t1 to t2; +disconnect conn27515; + +connection master; +revoke all privileges, grant option from user27515@localhost; +drop user user27515@localhost; +drop database db27515; + +--echo End of 4.1 tests # # Bug #16297 In memory grant tables not flushed when users's hostname is "" |