diff options
author | Nirbhay Choubey <nirbhay@mariadb.com> | 2015-01-27 16:25:18 -0500 |
---|---|---|
committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2015-01-27 16:25:18 -0500 |
commit | 950d69610aff4b2ee2cfe83113d339eac1ba0668 (patch) | |
tree | ae5cafd076f3f60536b3f2442c961fbe7a2fb46c /mysql-test/suite/wsrep/t | |
parent | 7cda4bee0ef7c8a3ec85e94bc1443ceaba3a64e8 (diff) | |
download | mariadb-git-950d69610aff4b2ee2cfe83113d339eac1ba0668.tar.gz |
MDEV-7322: Option to allow setting the binlog_format with Galera
At session scope, allow binlog_format to be changed to
values other than ROW with a warning.
Diffstat (limited to 'mysql-test/suite/wsrep/t')
-rw-r--r-- | mysql-test/suite/wsrep/t/binlog_format.test | 21 |
1 files changed, 14 insertions, 7 deletions
diff --git a/mysql-test/suite/wsrep/t/binlog_format.test b/mysql-test/suite/wsrep/t/binlog_format.test index 561e4d77ea9..a2dc8542322 100644 --- a/mysql-test/suite/wsrep/t/binlog_format.test +++ b/mysql-test/suite/wsrep/t/binlog_format.test @@ -1,19 +1,18 @@ --source include/have_wsrep_provider.inc --source include/have_binlog_format_row.inc -# -# MDEV-4227: Galera server should stop crashing on setting binlog_format STATEMENT -# -call mtr.add_suppression("WSREP: cannot get fake InnoDB transaction ID"); -call mtr.add_suppression("WSREP: Could not open saved state file for reading:.*"); + call mtr.add_suppression("WSREP: MariaDB Galera does not support binlog format.*"); +call mtr.add_suppression("WSREP: cannot get fake InnoDB transaction ID"); + +--echo # +--echo # MDEV-4227: Galera server should stop crashing on setting binlog_format STATEMENT +--echo # SHOW VARIABLES LIKE 'binlog_format'; --- error ER_WRONG_VALUE_FOR_VAR SET binlog_format=STATEMENT; SHOW WARNINGS; SHOW VARIABLES LIKE 'binlog_format'; CREATE TABLE IF NOT EXISTS test.t1 AS SELECT * FROM information_schema.routines WHERE 1 = 0; --- error ER_WRONG_VALUE_FOR_VAR SET binlog_format=MIXED; SHOW WARNINGS; SHOW VARIABLES LIKE 'binlog_format'; @@ -26,6 +25,10 @@ DROP TABLE IF EXISTS test.t1; DROP TABLE IF EXISTS test.t2; DROP TABLE IF EXISTS test.t3; +--echo # +--echo # MDEV-7322: Option to allow setting the binlog_format with Galera +--echo # + -- error ER_WRONG_VALUE_FOR_VAR SET @@GLOBAL.binlog_format=STATEMENT; SHOW GLOBAL VARIABLES LIKE 'binlog_format'; @@ -34,6 +37,10 @@ SHOW GLOBAL VARIABLES LIKE 'binlog_format'; SET @@GLOBAL.binlog_format=MIXED; SHOW GLOBAL VARIABLES LIKE 'binlog_format'; +-- error ER_WRONG_VALUE_FOR_VAR +SET @@GLOBAL.binlog_format=DEFAULT; +SHOW GLOBAL VARIABLES LIKE 'binlog_format'; + SET @@GLOBAL.binlog_format=ROW; SHOW GLOBAL VARIABLES LIKE 'binlog_format'; |