summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <sasha@mysql.sashanet.com>2001-05-16 13:23:03 -0600
committerunknown <sasha@mysql.sashanet.com>2001-05-16 13:23:03 -0600
commit8aeba90087409740612a0e8597546203c80fba52 (patch)
tree02c6789ff4125795b9a80e7fd1cede0fc7aedd80 /mysql-test
parent8dada46395577459bbb05ac261fa11c411751140 (diff)
parentfa33f498349cb7f4e477f5e0ec93451bcb202d1f (diff)
downloadmariadb-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.result6
-rw-r--r--mysql-test/t/rpl000001.test8
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;