From f2116615bed09a5b2bb6f113ba3ea1beebcb5e54 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 1 Apr 2004 23:13:25 +0500 Subject: added synchronization in mysql_create_like_table ( fixed BUG #2385 CREATE TABLE LIKE lacks locking on source and destination table and added tests for it ) sql/mysql_priv.h: added code TEST_SYNCHRONIZATION for --exit-info option sql/mysqld.cc: fixed -debug prefix sql/sql_table.cc: added synchronization in mysql_create_like_table (fixed BUG #2385 CREATE TABLE LIKE lacks locking on source and destination table) --- mysql-test/t/synchronization.test | 44 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 mysql-test/t/synchronization.test (limited to 'mysql-test/t/synchronization.test') diff --git a/mysql-test/t/synchronization.test b/mysql-test/t/synchronization.test new file mode 100644 index 00000000000..84478cf7445 --- /dev/null +++ b/mysql-test/t/synchronization.test @@ -0,0 +1,44 @@ +-- source include/have_crypt.inc + +# +# Test for Bug #2385 CREATE TABLE LIKE lacks locking on source and destination table +# + +connect (con_to_sleep,localhost,lock_controller,,); +connect (con_to_harm_sleeper,localhost,root,,); + +# locking of source: +connection con_to_sleep; +CREATE TABLE t1 (a int); +send CREATE TABLE t2 LIKE t1; + +connection con_to_harm_sleeper; +ALTER TABLE t1 add key(a); + +connection con_to_sleep; +sleep 4; +SHOW CREATE TABLE t2; +drop table t1, t2; + +# locking of destination: +connection con_to_sleep; +CREATE TABLE t1 (a int); +send CREATE TABLE t2 LIKE t1; + +connection con_to_harm_sleeper; +sleep 1; +CREATE TABLE t2 (b int); +disable_query_log; +select "-----------" as "let's take a look at result of create .. like : "; +enable_query_log; + +connection con_to_sleep; +sleep 1; +--error 1 +reap; +disable_query_log; +select "" as "-----------"; +enable_query_log; +SHOW CREATE TABLE t2; + +drop table t1, t2; \ No newline at end of file -- cgit v1.2.1