1include/master-slave.inc 2[connection master] 3# 4# MDEV-6525 ; Problems with CREATE OR REPLACE under lock 5# 6CREATE TABLE t1 (a INT) ENGINE=InnoDB; 7CREATE FUNCTION f1() RETURNS INT RETURN ( SELECT MAX(a) FROM t1 ); 8connect con1,localhost,root,,test; 9CREATE TEMPORARY TABLE tmp (b INT) ENGINE=InnoDB; 10LOCK TABLE t1 WRITE; 11SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; 12CREATE OR REPLACE TABLE t1 LIKE tmp; 13SHOW CREATE TABLE t1; 14Table Create Table 15t1 CREATE TABLE `t1` ( 16 `b` int(11) DEFAULT NULL 17) ENGINE=InnoDB DEFAULT CHARSET=latin1 18connection default; 19set session lock_wait_timeout=1; 20SELECT f1(); 21ERROR HY000: Lock wait timeout exceeded; try restarting transaction 22set session lock_wait_timeout=@@global.lock_wait_timeout; 23SELECT f1(); 24connection con1; 25unlock tables; 26connection default; 27ERROR 42S22: Unknown column 'a' in 'field list' 28disconnect con1; 29drop function f1; 30drop table t1; 31include/rpl_end.inc 32