diff options
Diffstat (limited to 'mysql-test/t/handler.test')
-rw-r--r-- | mysql-test/t/handler.test | 21 |
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; |