GRANT ALL produces different results on master and slave

Bug #1175041 reported by Alex Yurchenko
6
This bug affects 1 person
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','linkbench','linkdb','root@localhost','2013-05-01 04:48:24','Select,Insert,Update,Delete,Create,Drop,References,Index,Alter,Create View,Show view,Trigger','');

on master and

INSERT INTO `tables_priv` VALUES ('%','linkdb','linkbench','linkdb','','2013-05-01 04:48:24','Select,Insert,Update,Delete,Create,Drop,References,Index,Alter,Create View,Show view,Trigger','');

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.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.