GRANT ALL produces different results on master and slave
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
New
|
Undecided
|
Seppo Jaakola |
Bug Description
The following script:
=======
HOST=127.0.0.1
PORT=3305
USER=root
PSWD=rootpass
mysql -u$USER -p$PSWD -h$HOST -P$PORT << EOF
CREATE DATABASE linkdb;
USE linkdb;
CREATE USER 'linkbench'@'%' IDENTIFIED BY 'linkpass';
GRANT ALL ON linkdb TO 'linkbench'@'%'
EOF
=======
results in
INSERT INTO `tables_priv` VALUES ('%','linkdb'
on master and
INSERT INTO `tables_priv` VALUES ('%','linkdb'
on slave.
Note inconsistency in the fifth column. It also may well be that the sixth column can also be inconsistent if the query timing is wrong.