diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/rpl000001.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/rpl000001.test | 8 |
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/rpl000001.result b/mysql-test/r/rpl000001.result index a80fb618457..ebccb1e1e6b 100644 --- a/mysql-test/r/rpl000001.result +++ b/mysql-test/r/rpl000001.result @@ -7,5 +7,11 @@ sum(length(word)) 0 count(*) 10 +select_priv user +N blafasel2 +select_priv user +Y blafasel2 n 3456 +select_priv user +Y blafasel2 diff --git a/mysql-test/t/rpl000001.test b/mysql-test/t/rpl000001.test index 7989a679a70..99b5c3bfcae 100644 --- a/mysql-test/t/rpl000001.test +++ b/mysql-test/t/rpl000001.test @@ -71,10 +71,18 @@ connection master1; drop table t1; create table t1 (n int); insert into t1 values(3456); +use mysql; +insert into user (Host, User, Password) + VALUES ("10.10.10.%", "blafasel2", "blafasel2"); +select select_priv,user from mysql.user where user = 'blafasel2'; +update user set Select_priv = "Y" where User="blafasel2"; +select select_priv,user from mysql.user where user = 'blafasel2'; +use test; save_master_pos; connection slave; sync_with_master; select n from t1; +select select_priv,user from mysql.user where user = 'blafasel2'; connection master1; drop table t1; save_master_pos; |