Debian Codegraph @

mysql-test/suite/wsrep/r/binlog_format.result

raw
1 call mtr.add_suppression("WSREP: MariaDB Galera does not support binlog format");
2 call mtr.add_suppression("WSREP: Cannot get fake transaction ID from storage engine.");
3 #
4 # MDEV-4227: Galera server should stop crashing on setting binlog_format STATEMENT
5 #
6 SHOW VARIABLES LIKE 'binlog_format';
7 Variable_name Value
8 binlog_format ROW
9 SET binlog_format=STATEMENT;
10 Warnings:
11 Warning 1105 MariaDB Galera and flashback do not support binlog format: STATEMENT
12 SHOW WARNINGS;
13 Level Code Message
14 Warning 1105 MariaDB Galera and flashback do not support binlog format: STATEMENT
15 SHOW VARIABLES LIKE 'binlog_format';
16 Variable_name Value
17 binlog_format STATEMENT
18 CREATE TABLE IF NOT EXISTS test.t1 AS SELECT * FROM information_schema.routines WHERE 1 = 0;
19 Warnings:
20 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
21 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
22 SET binlog_format=MIXED;
23 Warnings:
24 Warning 1105 MariaDB Galera and flashback do not support binlog format: MIXED
25 SHOW WARNINGS;
26 Level Code Message
27 Warning 1105 MariaDB Galera and flashback do not support binlog format: MIXED
28 SHOW VARIABLES LIKE 'binlog_format';
29 Variable_name Value
30 binlog_format MIXED
31 CREATE TABLE IF NOT EXISTS test.t2 AS SELECT * FROM information_schema.routines WHERE 1 = 0;
32 Warnings:
33 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
34 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
35 SET binlog_format=ROW;
36 SHOW WARNINGS;
37 Level Code Message
38 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
39 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
40 SHOW VARIABLES LIKE 'binlog_format';
41 Variable_name Value
42 binlog_format ROW
43 CREATE TABLE IF NOT EXISTS test.t3 AS SELECT * FROM information_schema.routines WHERE 1 = 0;
44 DROP TABLE IF EXISTS test.t1;
45 DROP TABLE IF EXISTS test.t2;
46 DROP TABLE IF EXISTS test.t3;
47 #
48 # MDEV-7322: Option to allow setting the binlog_format with Galera
49 #
50 SET @@GLOBAL.binlog_format=STATEMENT;
51 ERROR 42000: Variable 'binlog_format' can't be set to the value of 'STATEMENT'
52 SHOW GLOBAL VARIABLES LIKE 'binlog_format';
53 Variable_name Value
54 binlog_format ROW
55 SET @@GLOBAL.binlog_format=MIXED;
56 ERROR 42000: Variable 'binlog_format' can't be set to the value of 'MIXED'
57 SHOW GLOBAL VARIABLES LIKE 'binlog_format';
58 Variable_name Value
59 binlog_format ROW
60 SET @@GLOBAL.binlog_format=DEFAULT;
61 ERROR 42000: Variable 'binlog_format' can't be set to the value of 'DEFAULT'
62 SHOW GLOBAL VARIABLES LIKE 'binlog_format';
63 Variable_name Value
64 binlog_format ROW
65 SET @@GLOBAL.binlog_format=ROW;
66 SHOW GLOBAL VARIABLES LIKE 'binlog_format';
67 Variable_name Value
68 binlog_format ROW
69 # End of test.