From faa8252b101d9bb223362a2c9a5ac5bf74a100a7 Mon Sep 17 00:00:00 2001
From: "serg@serg.mylan" <>
Date: Wed, 21 Jan 2004 23:39:35 +0100
Subject: test moved to an appropriate file

---
 mysql-test/r/myisam.result | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'mysql-test/r/myisam.result')

diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result
index fbb84a677cf..68a667f6d95 100644
--- a/mysql-test/r/myisam.result
+++ b/mysql-test/r/myisam.result
@@ -395,3 +395,11 @@ concat(a,'.')
 aaa.
 aaa   .
 drop table t1;
+create table t1(a text not null, b text not null, c text not null, index (a(10),b(10),c(10)));
+insert into t1 values('807780', '477', '165');
+insert into t1 values('807780', '477', '162');
+insert into t1 values('807780', '472', '162');
+select * from t1 where a='807780' and b='477' and c='165';
+a	b	c
+807780	477	165
+drop table t1;
-- 
cgit v1.2.1