| 1 |
RESET MASTER; |
| 2 |
call mtr.add_suppression("REVOKE/GRANT failed while storing table level and column level grants in the privilege tables. An incident event has been written to the binary log which will stop the replicas."); |
| 3 |
CREATE TABLE t1(a INT, b INT); |
| 4 |
CREATE USER u1@h; |
| 5 |
# |
| 6 |
# Verify that u1 is added into mysql.user. |
| 7 |
# |
| 8 |
SELECT user FROM mysql.user where user='u1'; |
| 9 |
user |
| 10 |
u1 |
| 11 |
GRANT SELECT(a) ON t1 TO u1@h, u2@h; |
| 12 |
ERROR 42000: You are not allowed to create a user with GRANT |
| 13 |
# |
| 14 |
# u1@h should not have been granted any permission |
| 15 |
# |
| 16 |
SELECT user, column_name, column_priv FROM mysql.columns_priv; |
| 17 |
user column_name column_priv |
| 18 |
# |
| 19 |
# Verify that the partially failed GRANT statement does not generate |
| 20 |
# a gtid and save the gtid into @@GLOBAL.GTID_EXECUTED. |
| 21 |
# |
| 22 |
include/assert.inc [Does not generate MASTER_UUID:4 and commit it into @@GLOBAL.GTID_EXECUTED] |
| 23 |
# |
| 24 |
# Verify that the partially failed GRANT statement is not binlogged. |
| 25 |
# |
| 26 |
include/show_binlog_events.inc |
| 27 |
DROP USER u1@h; |
| 28 |
DROP TABLE t1; |