CREATE TABLE a ( id int ); begin; --echo # Connection con1 connect (con1, localhost, root); connection con1; begin; --echo # Connection default connection default; show fields from a; --echo # Connection con1 connection con1; --send alter table a add a int --echo # Connection default connection default; LET $wait_condition= SELECT COUNT(*) = 1 FROM information_schema.processlist WHERE state LIKE 'Waiting for table metadata lock'; --source include/wait_condition.inc select * from a; --echo # Connection default connection default; --error ER_LOCK_DEADLOCK