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.test21
1 files changed, 17 insertions, 4 deletions
diff --git a/mysql-test/t/handler.test b/mysql-test/t/handler.test
index b72b739600e..657185f5e2d 100644
--- a/mysql-test/t/handler.test
+++ b/mysql-test/t/handler.test
@@ -33,13 +33,15 @@ handler t2 read a next;
handler t2 read a=(15);
handler t2 read a=(16);
-!$1070 handler t2 read a=(19,"fff");
+--error 1070
+handler t2 read a=(19,"fff");
handler t2 read b=(19,"fff");
handler t2 read b=(19,"yyy");
handler t2 read b=(19);
-!$1109 handler t1 read a last;
+--error 1109
+handler t1 read a last;
handler t2 read a=(11);
handler t2 read a>=(11);
@@ -65,8 +67,19 @@ handler t2 read first;
handler t2 read next;
alter table t1 type=MyISAM;
handler t2 read next;
-!$1064 handler t2 read last;
+--error 1064
+handler t2 read last;
handler t2 close;
-drop table if exists t1;
+
+#
+# DROP TABLE
+#
+handler t1 open as t2;
+drop table t1;
+create table t1 (a int);
+insert into t1 values (17);
+--error 1109
+handler t2 read first;
+drop table t1;