summaryrefslogtreecommitdiff
path: root/mysql-test/main/synchronization.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/synchronization.test')
-rw-r--r--mysql-test/main/synchronization.test50
1 files changed, 50 insertions, 0 deletions
diff --git a/mysql-test/main/synchronization.test b/mysql-test/main/synchronization.test
new file mode 100644
index 00000000000..aef06245717
--- /dev/null
+++ b/mysql-test/main/synchronization.test
@@ -0,0 +1,50 @@
+# 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