From cdf7471c2c504840bd6feb1e7c634a2d1ad8ed89 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 18 May 2004 22:59:43 +0400 Subject: Fix and test case for BUG#3649. mysql-test/r/handler.result: Test case for BUG#3649 mysql-test/t/handler.test: Test case for BUG#3649 sql/sql_handler.cc: Fix for BUG#3649: when doing an index scan for an equality condition, use index_next_same to retrieve subsequent rows. --- mysql-test/t/handler.test | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'mysql-test/t/handler.test') diff --git a/mysql-test/t/handler.test b/mysql-test/t/handler.test index 936902fd9bf..1f7f32c930a 100644 --- a/mysql-test/t/handler.test +++ b/mysql-test/t/handler.test @@ -123,3 +123,15 @@ handler t close; use test; drop table t1; +# +# BUG#3649 +# +create table t1 ( a int, b int, INDEX a (a) ); +insert into t1 values (1,2), (2,1); +handler t1 open; +handler t1 read a=(1) where b=2; +handler t1 read a=(1) where b=3; +handler t1 read a=(1) where b=1; +handler t1 close; +drop table t1; + -- cgit v1.2.1