summaryrefslogtreecommitdiff
path: root/mysql-test/t/myisam.test
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2017-09-21 16:30:24 +0300
committerMonty <monty@mariadb.org>2017-09-21 16:34:48 +0300
commit0a44ae6528d1fdb2d4a9dab1be7e36931eac8236 (patch)
tree49cb66b22401072eb4b3f46fef10cc487b5af8c1 /mysql-test/t/myisam.test
parent05da63f0483e2e1d2389e9c6829f269db014dfbb (diff)
downloadmariadb-git-0a44ae6528d1fdb2d4a9dab1be7e36931eac8236.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/myisam.test')
-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 572fa55e70f..0da542e499e 100644
--- a/mysql-test/t/myisam.test
+++ b/mysql-test/t/myisam.test
@@ -1770,6 +1770,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';