summaryrefslogtreecommitdiff
path: root/mysql-test/r/handler.result
diff options
context:
space:
mode:
authorsergefp@mysql.com <>2004-05-18 22:59:43 +0400
committersergefp@mysql.com <>2004-05-18 22:59:43 +0400
commit482058befaf715bfc804cb70bdb01c4079b2e782 (patch)
treef4ce42bf90156e47e2c2a60ee12cf3d1d4bb0ea2 /mysql-test/r/handler.result
parent7ff94b3808d45c12e1216b102c5af3933d156282 (diff)
downloadmariadb-git-482058befaf715bfc804cb70bdb01c4079b2e782.tar.gz
Fix and test case for BUG#3649.
Diffstat (limited to 'mysql-test/r/handler.result')
-rw-r--r--mysql-test/r/handler.result12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/handler.result b/mysql-test/r/handler.result
index 1cfc3a9de8b..50d51cf14f4 100644
--- a/mysql-test/r/handler.result
+++ b/mysql-test/r/handler.result
@@ -191,3 +191,15 @@ Ok
handler t close;
use test;
drop table t1;
+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;
+a b
+1 2
+handler t1 read a=(1) where b=3;
+a b
+handler t1 read a=(1) where b=1;
+a b
+handler t1 close;
+drop table t1;