this won't be pushed

1 files changed, 10 insertions, 1 deletions

diff --git a/mysql-test/t/handler.test b/mysql-test/t/handler.test
index 9656a28abe0..a22e5546252 100644
--- a/mysql-test/t/handler.test
+++ b/mysql-test/t/handler.test
@@ -5,8 +5,8 @@
 drop table if exists t1;
 create table t1 (a int, b char(10), key a(a), key b(a,b));
 insert into t1 values
-(14,"aaa"),(15,"bbb"),(16,"ccc"),(16,"xxx"),
 (17,"ddd"),(18,"eee"),(19,"fff"),(19,"yyy"),
+(14,"aaa"),(15,"bbb"),(16,"ccc"),(16,"xxx"),
 (20,"ggg"),(21,"hhh"),(22,"iii");
 handler t1 open as t2;
 handler t2 read a first;
@@ -50,7 +50,16 @@ handler t2 read a next  limit 3;
 handler t2 read a prev  limit 10;
 
 handler t2 read a>=(16) limit 4;
+handler t2 read a>=(16) limit 2,2;
 handler t2 read a last  limit 3;
 
+handler t2 read a=(19);
+handler t2 read a=(19) where b="yyy";
+
+handler t2 read first;
+handler t2 read next;
+handler t2 read next;
+handler t2 read last;
+
 handler t2 close;
 drop table if exists t1;