summaryrefslogtreecommitdiff
path: root/mysql-test/t/myisam.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2017-09-25 22:05:56 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2017-09-25 22:05:56 +0300
commit4a32e2395e1ff6cf7274d0567282b1747031108b (patch)
treef20565057eebcd25fda9292e66695bbf8a409f41 /mysql-test/t/myisam.test
parentb773270c397a97425abc506e7d7fbc5fedb99d9c (diff)
parent86c3ba65aa39e1e81c52f3455a1bcf187906dffc (diff)
downloadmariadb-git-4a32e2395e1ff6cf7274d0567282b1747031108b.tar.gz
Merge bb-10.2-ext into 10.3
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';