Debian Codegraph @

mysql-test/suite/binlog/t/binlog_mdev717.test

raw
1 # MDEV-717 LP:1003679 - Wrong binlog order on concurrent DROP schema and CREATE function.
2
3 --source include/have_debug_sync.inc
4 --source include/have_log_bin.inc
5 RESET MASTER;
6
7 connect(con1,localhost,root);
8 connection default;
9
10 CREATE DATABASE mysqltest;
11 SET DEBUG_SYNC= "after_wait_locked_schema_name SIGNAL locked WAIT_FOR release";
12 --send DROP DATABASE mysqltest;
13 connection con1;
14 SET DEBUG_SYNC= "now WAIT_FOR locked";
15 SET DEBUG_SYNC= "before_wait_locked_pname SIGNAL release";
16 --error ER_BAD_DB_ERROR
17 CREATE FUNCTION mysqltest.f1() RETURNS INT RETURN 1;
18 connection default;
19 --reap
20
21 CREATE DATABASE mysqltest;
22 SET DEBUG_SYNC= "after_wait_locked_schema_name SIGNAL locked WAIT_FOR release";
23 --send DROP DATABASE mysqltest;
24 connection con1;
25 SET DEBUG_SYNC= "now WAIT_FOR locked";
26 SET DEBUG_SYNC= "before_wait_locked_pname SIGNAL release";
27 --error ER_BAD_DB_ERROR
28 CREATE EVENT mysqltest.e1 ON SCHEDULE EVERY 15 MINUTE DO BEGIN END;
29 connection default;
30 --reap
31
32 CREATE DATABASE mysqltest;
33 CREATE EVENT mysqltest.e1 ON SCHEDULE EVERY 15 MINUTE DO BEGIN END;
34 SET DEBUG_SYNC= "after_wait_locked_schema_name SIGNAL locked WAIT_FOR release";
35 --send DROP DATABASE mysqltest;
36 connection con1;
37 SET DEBUG_SYNC= "now WAIT_FOR locked";
38 SET DEBUG_SYNC= "before_wait_locked_pname SIGNAL release";
39 --error ER_BAD_DB_ERROR
40 ALTER EVENT mysqltest.e1 ON SCHEDULE EVERY 20 MINUTE DO BEGIN END;
41 connection default;
42 --reap
43
44 SET DEBUG_SYNC= "RESET";
45 --source include/show_binlog_events.inc
46