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