diff options
| author | unknown <serg@serg.mylan> | 2004-01-21 23:39:35 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-01-21 23:39:35 +0100 |
| commit | cdcf112af01e0365f5600b9de442f6640569a7a0 (patch) | |
| tree | e46ae07c45184a3e9285a504704783b4e0d2b10e /mysql-test/r/myisam.result | |
| parent | 0ef9acc9a9932ea63ff41d4528231632f3a3d31d (diff) | |
| download | mariadb-git-cdcf112af01e0365f5600b9de442f6640569a7a0.tar.gz | |
test moved to an appropriate file
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 8 |
1 files changed, 8 insertions, 0 deletions
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; |