Debian Codegraph @

mysql-test/suite/galera/r/galera_forced_binlog_format.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SET GLOBAL wsrep_on=OFF;
5 RESET MASTER;
6 SET GLOBAL wsrep_on=ON;
7 FLUSH BINARY LOGS;
8 SET SESSION binlog_format = 'STATEMENT';
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
10 INSERT INTO t1 VALUES (1);
11 SET SESSION binlog_format = 'MIXED';
12 INSERT INTO t1 VALUES (2);
13 SHOW BINLOG EVENTS IN 'mysqld-bin.000001' FROM 256;
14 Log_name Pos Event_type Server_id End_log_pos Info
15 mysqld-bin.000001 <Pos> Gtid_list 1 <End_log_pos> []
16 mysqld-bin.000001 <Pos> Binlog_checkpoint 1 <End_log_pos> mysqld-bin.000001
17 mysqld-bin.000001 <Pos> Rotate 1 <End_log_pos> mysqld-bin.000002;pos=4
18 DROP TABLE t1;
19 #
20 # MDEV-9401: wsrep_forced_binlog_format with binlog causes crash
21 #
22 SET SESSION binlog_format = 'ROW';
23 CREATE DATABASE testdb_9401;
24 USE testdb_9401;
25 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
26 CREATE USER dummy@localhost;
27 GRANT ALL PRIVILEGES ON testdb_9401.t1 TO dummy@localhost;
28 FLUSH PRIVILEGES;
29 SHOW GRANTS FOR dummy@localhost;
30 Grants for dummy@localhost
31 GRANT USAGE ON *.* TO `dummy`@`localhost`
32 GRANT ALL PRIVILEGES ON `testdb_9401`.`t1` TO `dummy`@`localhost`
33 REVOKE ALL PRIVILEGES, GRANT OPTION FROM dummy@localhost;
34 DROP USER dummy@localhost;
35 DROP DATABASE testdb_9401;
36 # End of tests