fix and test case for the bug #787: HANDLER without INDEX doesn't work with deleted rows

mysql-test/r/handler.result:
  test case for the bug #787: HANDLER without INDEX doesn't work with deleted rows
mysql-test/t/handler.test:
  test case for the bug #787: HANDLER without INDEX doesn't work with deleted rows
sql/sql_handler.cc:
  fix for the bug #787: HANDLER without INDEX doesn't work with deleted rows

1 files changed, 19 insertions, 0 deletions

diff --git a/mysql-test/r/handler.result b/mysql-test/r/handler.result
index 1973797ae79..4af38807518 100644
--- a/mysql-test/r/handler.result
+++ b/mysql-test/r/handler.result
@@ -146,6 +146,25 @@ alter table t1 type=MyISAM;
 handler t2 read first;
 Unknown table 't2' in HANDLER
 drop table t1;
+create table t1 (a int);
+insert into t1 values (1),(2),(3),(4),(5),(6);
+delete from t1 limit 2;
+handler t1 open;
+handler t1 read first;
+a
+3
+handler t1 read first limit 1,1;
+a
+4
+handler t1 read first limit 2,2;
+a
+5
+6
+delete from t1 limit 3;
+handler t1 read first;
+a
+6
+drop table t1;
 create table t1(a int, index(a));
 insert into t1 values (1), (2), (3);
 handler t1 open;