Debian Codegraph @

mysql-test/suite/rpl/t/create_or_replace2.test

raw
1 --source include/have_innodb.inc
2 --source include/have_binlog_format_row_or_statement.inc
3 --source include/have_metadata_lock_info.inc
4 --source include/master-slave.inc
5
6 --echo #
7 --echo # MDEV-6525 ; Problems with CREATE OR REPLACE under lock
8 --echo #
9
10 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
11 CREATE FUNCTION f1() RETURNS INT RETURN ( SELECT MAX(a) FROM t1 );
12
13 --connect (con1,localhost,root,,test)
14
15 CREATE TEMPORARY TABLE tmp (b INT) ENGINE=InnoDB;
16 LOCK TABLE t1 WRITE;
17
18 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
19
20 CREATE OR REPLACE TABLE t1 LIKE tmp;
21 SHOW CREATE TABLE t1;
22
23 --connection default
24 set session lock_wait_timeout=1;
25 --error 1205
26 SELECT f1();
27
28 set session lock_wait_timeout=@@global.lock_wait_timeout;
29 --send SELECT f1()
30 --connection con1
31 # This is here just in case, any timeout should be ok
32 --sleep 1
33 unlock tables;
34 --connection default
35 --error 1054
36 --reap
37 --disconnect con1
38
39 # Cleanup
40 drop function f1;
41 drop table t1;
42 --source include/rpl_end.inc