From: Dmitry Shulga Date: October 14 2010 2:28pm Subject: bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3528) Bug#36742 List-Archive: http://lists.mysql.com/commits/120777 X-Bug: 36742 Message-Id: <0LAA009AUAWFHX60@fe-emea-10.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="Boundary_(ID_z6SQr5jVPn+m6unaMQQpSA)" --Boundary_(ID_z6SQr5jVPn+m6unaMQQpSA) MIME-version: 1.0 Content-type: text/plain; CHARSET=US-ASCII Content-transfer-encoding: 7BIT Content-disposition: inline #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 # --Boundary_(ID_z6SQr5jVPn+m6unaMQQpSA) MIME-version: 1.0 Content-type: text/bzr-bundle; CHARSET=US-ASCII; name="bzr/dmitry.shulga@stripped" Content-transfer-encoding: 7BIT Content-disposition: inline; filename="bzr/dmitry.shulga@stripped" # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: dmitry.shulga@stripped # target_branch: file:///Users/shulga/projects/mysql/5.1-bugteam-\ # bug36742/ # testament_sha1: f31d6b1c16685ea73651883bd456138d583e3514 # timestamp: 2010-10-14 21:29:00 +0700 # base_revision_id: dmitry.shulga@stripped\ # 4p8vvy5lrth7zarw # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWanD9fEAAZDfgEAQWGP/918C mAC////wUAO9eOhd3VQABoSmymCPSE2pp4mh6mU/VNMDQmTAaKJ6RhtU9AnkhoAAAAAMAAAABoAA AAAGpiT0k0yNDTQNAGmgABoNBJIhoBHojRqbIaVPxTT1Mp5T1Mh6Eojvjr51iR62ywUAkJguymbT dClnZKQIu3IemqUxVkRIm+auwh4SYR/dL45DkvGyJCgMeG/UrZpovsIYLmNGS+XYEHLIHbpNyvdV d+MP9pFzi6FE0XCPq9BeiMj5rINKLU04osgekErNWnLbYq1IOsaGSgvIfOEsnNKsZ8Hrz4SIPDIJ 51sMOdarfJbRRs1M5etF6c8URR0q2RIU+LVOsGDkibQ8SbCUbjIDKuctMpLlbcwNZSghI4Joieqp eEmzCUO0Z6V0U5HiidbgJHYzVcLhUVBDO2e2PGyAjcwmrMH40mAqc5XM2/AhToTZqFnLevIkiUyJ 9i2TV6lcqicwLua3YW1cxU2U2DtzQdJHKWk23PV5Qa1PqkVwmvaZPomNziqmrq5a3L+BaL9rorad aqjbKEEeUUqMhZU6K+KKikEa1CkNcwKgshI3woI+cxBAczXIQO1DEcCPVzcARrGpOVoQIqMM3KaM fAR8sNAobZljUg17eeNhkAuEyMXOdwgTpcjV3LjmQha5RfAeZ5tVjMnjY9CjLyyKhHfrNqqprNFK eA8QvL5BZVIrJ42BRxKe54PLP/23hsmrrqzKE41gSUk3OTGTx4PH4KKaGiIi+mhc4420WUO8Vr7T p0iqnvLMyleD7DOn9I87YkUQ0422eiVg+YHZ7JJVC1JQwCy9S7Vp9QwaUZTiOvEoqlvN33d82KxM vPCynLHjiSpM04Mncdi2ms6HTTtv6ci09pu7d9qzHA8sX0P7TN1SHi2i4dReL2X1owgDZBnZb+SR BcQNKBcS+z9A02hihxWsAqm+cdcmoMA0BOxu2ndcLg91CZezA4J3L5s5IxSOWvs+fD1Vb95itJxF LhZpxYWH5M0G+e6EDtamdnSoXJDHq2u+mYJGIVSIZD2TKJyUZ/1mkTBlKQK0MvDl7W37N5e7IPgX wo7mYJT6U2UStZSTLKBu3JwYyIe+QvZU8bSbSCrdbbcpptVSneMIb3V6fd+4Gqiipn5sW/CDgDul a09PRp+55WpGyQN+xfgQ/QV2xGv0te5HiV33JBuTr+O4N+bnjnio5Jr3ax1dImXZuCRM5O5zzLhi GYuqR2/mYRFpbKHisttUcw8/ZYqaC6p293ZdFQqFApYFQp7lQSrJatFiQUtXuL/xdyRThQkKnD9f EA== --Boundary_(ID_z6SQr5jVPn+m6unaMQQpSA)--