1--source include/not_embedded.inc 2--source include/have_innodb.inc 3#--source include/have_metadata_lock_info.inc 4 5# 6# Testing of problems with ALTER TABLE and events on the same table(s) 7# 8 9# 10# MDEV-24452 ALTER TABLE event take infinite time which for example breaks 11# mysql_upgrade 12# 13 14SET GLOBAL event_scheduler=1; 15 16CREATE TABLE t1 (a int primary key, b int) engine=innodb; 17insert into t1 values (1,1),(2,2),(3,3); 18CREATE TABLE t2 (a int primary key) engine=innodb; 19 20CREATE EVENT e_t1 ON SCHEDULE EVERY 1 SECOND DO insert ignore into test.t2 select a from test.t1; 21 22let $wait_condition=SELECT count(*) > 0 from t2; 23--source include/wait_condition.inc 24select * from t2; 25drop event e_t1; 26 27# select * from information_schema.metadata_lock_info; 28ALTER TABLE mysql.event DROP PRIMARY KEY, ADD PRIMARY KEY(db,name); 29drop table t1,t2; 30 31SET GLOBAL event_scheduler=default; 32