# Save the initial number of concurrent sessions --source include/count_sessions.inc # # Test for Bug#2385 CREATE TABLE LIKE lacks locking on source and destination # table # --disable_warnings DROP TABLE IF EXISTS t1,t2; --enable_warnings connect (con1,localhost,root,,); connect (con2,localhost,root,,); # locking of source: CREATE TABLE t1 (x1 INT); let $1= 10; while ($1) { connection con1; send ALTER TABLE t1 CHANGE x1 x2 INT; connection con2; CREATE TABLE t2 LIKE t1; replace_result x1 xx x2 xx; SHOW CREATE TABLE t2; DROP TABLE t2; connection con1; reap; send ALTER TABLE t1 CHANGE x2 x1 INT; connection con2; CREATE TABLE t2 LIKE t1; replace_result x1 xx x2 xx; SHOW CREATE TABLE t2; DROP TABLE t2; connection con1; reap; dec $1; } DROP TABLE t1; connection default; disconnect con1; disconnect con2; # End of 4.1 tests # Wait till we reached the initial number of concurrent sessions --source include/wait_until_count_sessions.inc