mysql-test/t/rpl000001.test

    added a test for updates on user table


mysql-test/t/rpl000001.test:
  added a test for updates on user table

1 files changed, 8 insertions, 0 deletions

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;