summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/flush-innodb.result5
-rw-r--r--mysql-test/t/flush-innodb.test9
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/flush-innodb.result b/mysql-test/r/flush-innodb.result
new file mode 100644
index 00000000000..cea4f81e2a2
--- /dev/null
+++ b/mysql-test/r/flush-innodb.result
@@ -0,0 +1,5 @@
+FLUSH TABLES WITH READ LOCK AND DISABLE CHECKPOINT;
+UNLOCK TABLES;
+CREATE TABLE t1 ( m MEDIUMTEXT ) ENGINE=InnoDB;
+INSERT INTO t1 VALUES ( REPEAT('i',1048576) );
+DROP TABLE t1;
diff --git a/mysql-test/t/flush-innodb.test b/mysql-test/t/flush-innodb.test
new file mode 100644
index 00000000000..207032b1acb
--- /dev/null
+++ b/mysql-test/t/flush-innodb.test
@@ -0,0 +1,9 @@
+--source include/have_innodb.inc
+
+# MDEV-254: Server hang with FLUSH TABLES WITH READ LOCK AND DISABLE CHECKPOINT
+FLUSH TABLES WITH READ LOCK AND DISABLE CHECKPOINT;
+UNLOCK TABLES;
+CREATE TABLE t1 ( m MEDIUMTEXT ) ENGINE=InnoDB;
+INSERT INTO t1 VALUES ( REPEAT('i',1048576) );
+
+DROP TABLE t1;