--source include/have_debug_sync.inc --source include/have_innodb.inc connect (locker,localhost,root,,); connect (waiter,localhost,root,,); eval CREATE TABLE t1 (id INT PRIMARY KEY, b CHAR(100) DEFAULT "initial value") ENGINE=InnoDB; delimiter |; CREATE PROCEDURE t_proc () BEGIN SELECT * FROM t1; END| delimiter ;| connection locker; SET DEBUG_SYNC= 'after_lock_tables_takes_lock SIGNAL locked WAIT_FOR do_unlock'; send ALTER PROCEDURE t_proc COMMENT 'Now with a comment from connection locker 1.10'; connection waiter; SET DEBUG_SYNC= 'now WAIT_FOR locked'; SET DEBUG_SYNC= 'wait_for_lock SIGNAL do_unlock'; send DROP PROCEDURE t_proc; connection locker; --echo Locker reap reap; connection waiter; --echo Waiter reap reap; connection default;