|
|
Test case
|
--source include/master-slave.inc
|
--source include/have_binlog_format_statement.inc
|
|
--connection master1
|
CREATE TABLE t1 (i INT);
|
INSERT INTO t1 VALUES (1),(2);
|
CREATE FUNCTION f() RETURNS INTEGER RETURN 1;
|
CREATE TEMPORARY TABLE tmp AS SELECT f() AS col FROM t1;
|
--disconnect master1
|
--sleep 1
|
--connection master
|
|
--sync_slave_with_master
|
Last_SQL_Error Error 'Can't reopen table: 'tmp'' on query. Default database: 'test'. Query: 'DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp`'
|
Apparently the problem appeared on 10.0 tree with the following revision:
commit 96784eb106d9e0ab6ce717a937a9be9af714b223
|
Author: Kristian Nielsen <knielsen@knielsen-hq.org>
|
Date: Mon Mar 9 13:06:32 2015 +0100
|
|
MDEV-7668: Intermediate master groups CREATE TEMPORARY with INSERT, causing parallel replication failure
|
|
...
|
|