diff options
| author | unknown <serg@sergbook.mysql.com> | 2004-06-21 19:42:00 +0300 |
|---|---|---|
| committer | unknown <serg@sergbook.mysql.com> | 2004-06-21 19:42:00 +0300 |
| commit | 83a4e46d8e6c324ae6f2232a36907a554a3d9dd4 (patch) | |
| tree | c835111cbdb01ffd8e8443a7f50f43e492e2e1d1 /mysql-test/r/range.result | |
| parent | e4042c25ef4c7162046e953198dfd56bc80db1f8 (diff) | |
| download | mariadb-git-83a4e46d8e6c324ae6f2232a36907a554a3d9dd4.tar.gz | |
use ref not range for ... WHERE key IN (val)
Diffstat (limited to 'mysql-test/r/range.result')
| -rw-r--r-- | mysql-test/r/range.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index b826dd1b677..c930b0df77a 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -255,7 +255,7 @@ t1 ref y y 5 const 1 Using where t2 range x x 5 NULL 2 Using where explain select count(*) from t1 where x in (1); table type possible_keys key key_len ref rows Extra -t1 range x x 5 NULL 1 Using where; Using index +t1 ref x x 5 const 1 Using where; Using index explain select count(*) from t1 where x in (1,2); table type possible_keys key key_len ref rows Extra t1 range x x 5 NULL 2 Using where; Using index |