summaryrefslogtreecommitdiff
path: root/mysql-test/t
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2017-09-21 16:30:24 +0300
committerMonty <monty@mariadb.org>2018-05-16 15:34:27 +0300
commitd703e09cd6706673fbb127f540d3917068b40755 (patch)
tree2f86e112dae58b0d938df5487c7d06b8e5df79c3 /mysql-test/t
parentb050df4fd3ee5f2377a814fd24ac3774d1458f99 (diff)
downloadmariadb-git-d703e09cd6706673fbb127f540d3917068b40755.tar.gz
Fix that FLUSH TABLES FOR EXPORT also works for Aria tables.
- Added missing test case for MyISAM
Diffstat (limited to 'mysql-test/t')
-rw-r--r--mysql-test/t/myisam.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test
index 62260ba43aa..796083c0622 100644
--- a/mysql-test/t/myisam.test
+++ b/mysql-test/t/myisam.test
@@ -1763,6 +1763,19 @@ OPTIMIZE TABLE t1;
DROP TABLE t1;
#
+# Check FLUSH FOR EXPORT
+#
+
+CREATE TABLE t1(a INT, b CHAR(10), KEY(a), KEY(b)) engine=myisam;
+INSERT INTO t1 VALUES(1,'0'),(2,'0'),(3,'0'),(4,'0'),(5,'0'),
+ (6,'0'),(7,'0');
+flush tables test.t1 for export;
+--error ER_TABLE_NOT_LOCKED_FOR_WRITE
+insert into t1 values (8,'0');
+unlock tables;
+drop table t1;
+
+#
# Check some variables
#
show variables like 'myisam_block_size';