Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_next_partially_failed_grant.result

raw
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;