List:Commits« Previous MessageNext Message »
From:Dmitry Shulga Date:October 14 2010 2:28pm
Subject:bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3528) Bug#36742
View as plain text  
#At file:///Users/shulga/projects/mysql/5.1-bugteam-bug36742/ based on revid:dmitry.shulga@stripped

 3528 Dmitry Shulga	2010-10-14
      Follow up for bug#36742.
     @ mysql-test/t/grant3.test
        Removed test case for bug#19828 because of currently hostname
        stored in db in lowercase.

    modified:
      mysql-test/t/grant3.test
=== modified file 'mysql-test/t/grant3.test'
--- a/mysql-test/t/grant3.test	2009-10-20 06:17:57 +0000
+++ b/mysql-test/t/grant3.test	2010-10-14 14:28:47 +0000
@@ -41,107 +41,6 @@ delete from mysql.columns_priv where use
 flush privileges;
 
 #
-# Bug#19828 Case sensitivity in Grant/Revoke
-#
-
-grant select on test.* to CUser@localhost;
-grant select on test.* to CUser@LOCALHOST;
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, select_priv FROM mysql.db where user = 'CUser' order by 1,2;
-
-REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'CUser'@'LOCALHOST';
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, select_priv FROM mysql.db where user = 'CUser' order by 1,2;
-
-REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'CUser'@'localhost';
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, select_priv FROM mysql.db where user = 'CUser' order by 1,2;
-
-DROP USER CUser@localhost;
-DROP USER CUser@LOCALHOST;
-
-#### table grants
-create table t1 (a int);
-grant select on test.t1 to CUser@localhost;
-grant select on test.t1 to CUser@LOCALHOST;
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, Table_name, Table_priv, Column_priv FROM mysql.tables_priv where user = 'CUser' order by 1,2;
-
-REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'CUser'@'LOCALHOST';
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, Table_name, Table_priv, Column_priv FROM mysql.tables_priv where user = 'CUser' order by 1,2;
-
-REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'CUser'@'localhost';
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, Table_name, Table_priv, Column_priv FROM mysql.tables_priv where user = 'CUser' order by 1,2;
-
-DROP USER CUser@localhost;
-DROP USER CUser@LOCALHOST;
-
-### column grants
-
-grant select(a) on test.t1 to CUser@localhost;
-grant select(a) on test.t1 to CUser@LOCALHOST;
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, Table_name, Table_priv, Column_priv FROM mysql.tables_priv where user = 'CUser' order by 1,2;
-
-REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'CUser'@'LOCALHOST';
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, Table_name, Table_priv, Column_priv FROM mysql.tables_priv where user = 'CUser' order by 1,2;
-
-REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'CUser'@'localhost';
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser' order by 1,2;
-SELECT user, host, db, Table_name, Table_priv, Column_priv FROM mysql.tables_priv where user = 'CUser' order by 1,2;
-
-DROP USER CUser@localhost;
-DROP USER CUser@LOCALHOST;
-
-drop table t1;
-
-# revoke on a specific DB only
-
-grant select on test.* to CUser2@localhost;
-grant select on test.* to CUser2@LOCALHOST;
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser2' order by 1,2;
-SELECT user, host, db, select_priv FROM mysql.db where user = 'CUser2' order by 1,2;
-
-REVOKE SELECT ON test.* FROM 'CUser2'@'LOCALHOST';
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser2' order by 1,2;
-SELECT user, host, db, select_priv FROM mysql.db where user = 'CUser2' order by 1,2;
-
-REVOKE SELECT ON test.* FROM 'CUser2'@'localhost';
-flush privileges;
-
-SELECT user, host FROM mysql.user where user = 'CUser2' order by 1,2;
-SELECT user, host, db, select_priv FROM mysql.db where user = 'CUser2' order by 1,2;
-
-DROP USER CUser2@localhost;
-DROP USER CUser2@LOCALHOST;
-
-
-#
 # Bug#31194 Privilege ordering does not order properly for wildcard values
 #
 


Attachment: [text/bzr-bundle] bzr/dmitry.shulga@sun.com-20101014142847-tggm7p60zsuui39a.bundle
Thread
bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3528) Bug#36742Dmitry Shulga14 Oct