mirror of
https://github.com/MariaDB/server.git
synced 2025-02-23 05:43:08 +01:00
86a2e2ba90
Variable wsrep_forced_binlog_format has higher priority than binlog_format. In situation where STATEMENT is used and DELAYED INSERT is executing we should fall back to non-delay INSERT. Reviewed-by: Jan Lindström <jan.lindstrom@mariadb.com>
14 lines
408 B
Text
14 lines
408 B
Text
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
|
|
SET @wsrep_forced_binlog_format_saved = @@GLOBAL.wsrep_forced_binlog_format;
|
|
SET @@GLOBAL.wsrep_forced_binlog_format = STATEMENT;
|
|
|
|
CREATE TABLE t1(c INT PRIMARY KEY) ENGINE = MyISAM;
|
|
|
|
INSERT DELAYED INTO t1 VALUES (1),(2),(3);
|
|
SELECT SLEEP(1);
|
|
|
|
DROP TABLE t1;
|
|
|
|
SET @@GLOBAL.wsrep_forced_binlog_format = @wsrep_forced_binlog_format_saved;
|