mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
![mkaruza](/assets/img/avatar_default.png)
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>
11 lines
383 B
Text
11 lines
383 B
Text
connection node_2;
|
|
connection node_1;
|
|
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);
|
|
SLEEP(1)
|
|
0
|
|
DROP TABLE t1;
|
|
SET @@GLOBAL.wsrep_forced_binlog_format = @wsrep_forced_binlog_format_saved;
|