diff options
author | unknown <sasha@mysql.sashanet.com> | 2001-05-16 13:23:03 -0600 |
---|---|---|
committer | unknown <sasha@mysql.sashanet.com> | 2001-05-16 13:23:03 -0600 |
commit | 8aeba90087409740612a0e8597546203c80fba52 (patch) | |
tree | 02c6789ff4125795b9a80e7fd1cede0fc7aedd80 /mysql-test | |
parent | 8dada46395577459bbb05ac261fa11c411751140 (diff) | |
parent | fa33f498349cb7f4e477f5e0ec93451bcb202d1f (diff) | |
download | mariadb-git-8aeba90087409740612a0e8597546203c80fba52.tar.gz |
Merge work:/home/bk/mysql
into mysql.sashanet.com:/home/sasha/src/bk/mysql
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; |