mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
0784dd32b1
If wsrep_mode=BINLOG_ROW_FORMAT_ONLY wsrep_forced_binlog_format can be DEFAULT (UNSPECIFIED) or ROW. Finally, if wsrep_mode=[REPLICATE_MYISAM|REPLICATE_ARIA] or wsrep_replicate_myisam=ON we allow wsrep_forced_binlog_format to be [DEFAULT|ROW]. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
81 lines
2.2 KiB
Text
81 lines
2.2 KiB
Text
--source include/galera_cluster.inc
|
|
--source include/have_aria.inc
|
|
|
|
#
|
|
# MDEV-29775 : Assertion `0' failed in void Protocol::end_statement() when adding data to the MyISAM table after setting wsrep_mode=replicate_myisam
|
|
#
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
CREATE TABLE t (f0 CHAR(0)) ENGINE=MyISAM;
|
|
INSERT INTO t VALUES();
|
|
SELECT * FROM t;
|
|
--connection node_2
|
|
SELECT * FROM t;
|
|
DROP TABLE t;
|
|
|
|
--connection node_1
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
SET GLOBAL wsrep_forced_binlog_format=ROW;
|
|
CREATE TABLE t (f0 CHAR(0)) ENGINE=MyISAM;
|
|
INSERT INTO t VALUES();
|
|
SELECT * FROM t;
|
|
--connection node_2
|
|
SELECT * FROM t;
|
|
DROP TABLE t;
|
|
|
|
--connection node_1
|
|
SET GLOBAL wsrep_mode=REPLICATE_ARIA;
|
|
CREATE TABLE t (f0 CHAR(0)) ENGINE=Aria;
|
|
INSERT INTO t VALUES();
|
|
SELECT * FROM t;
|
|
--connection node_2
|
|
SELECT * FROM t;
|
|
DROP TABLE t;
|
|
|
|
--connection node_1
|
|
SET GLOBAL wsrep_mode=REPLICATE_ARIA;
|
|
SET GLOBAL wsrep_forced_binlog_format=ROW;
|
|
CREATE TABLE t (f0 CHAR(0)) ENGINE=Aria;
|
|
INSERT INTO t VALUES();
|
|
SELECT * FROM t;
|
|
--connection node_2
|
|
SELECT * FROM t;
|
|
DROP TABLE t;
|
|
|
|
--connection node_1
|
|
SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_forced_binlog_format=MIXED;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
|
|
SET GLOBAL wsrep_mode=REPLICATE_ARIA;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_forced_binlog_format=MIXED;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|
|
SET GLOBAL wsrep_forced_binlog_format=MIXED;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_mode = REPLICATE_ARIA;
|
|
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_mode = REPLICATE_ARIA;
|
|
|
|
SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|
|
SET GLOBAL wsrep_forced_binlog_format=MIXED;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_replicate_myisam=ON;
|
|
SET GLOBAL wsrep_forced_binlog_format=STATEMENT;
|
|
--error ER_WRONG_ARGUMENTS
|
|
SET GLOBAL wsrep_replicate_myisam=ON;
|
|
|
|
SET GLOBAL wsrep_forced_binlog_format=DEFAULT;
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|