summaryrefslogtreecommitdiff
path: root/mysql-test/t/handler.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/handler.test')
-rw-r--r--mysql-test/t/handler.test8
1 files changed, 5 insertions, 3 deletions
diff --git a/mysql-test/t/handler.test b/mysql-test/t/handler.test
index 657185f5e2d..30746f10c62 100644
--- a/mysql-test/t/handler.test
+++ b/mysql-test/t/handler.test
@@ -65,15 +65,13 @@ handler t2 read a=(19) where b="yyy";
handler t2 read first;
handler t2 read next;
-alter table t1 type=MyISAM;
handler t2 read next;
--error 1064
handler t2 read last;
-
handler t2 close;
#
-# DROP TABLE
+# DROP TABLE / ALTER TABLE
#
handler t1 open as t2;
drop table t1;
@@ -81,5 +79,9 @@ create table t1 (a int);
insert into t1 values (17);
--error 1109
handler t2 read first;
+handler t1 open as t2;
+alter table t1 type=MyISAM;
+--error 1109
+handler t2 read first;
drop table t1;