diff options
| author | serg@serg.mylan <> | 2004-01-21 23:39:35 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2004-01-21 23:39:35 +0100 |
| commit | faa8252b101d9bb223362a2c9a5ac5bf74a100a7 (patch) | |
| tree | e46ae07c45184a3e9285a504704783b4e0d2b10e /mysql-test/r/myisam.result | |
| parent | 0371c68e3ec8ad7fb9ae36af1f9ad66ce5c36685 (diff) | |
| download | mariadb-git-faa8252b101d9bb223362a2c9a5ac5bf74a100a7.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; |