diff options
| author | timour@mysql.com <> | 2004-10-11 20:10:07 +0300 |
|---|---|---|
| committer | timour@mysql.com <> | 2004-10-11 20:10:07 +0300 |
| commit | 3bb2c4e325eab4d913207b06ec28458583647ba7 (patch) | |
| tree | c18fbef94db2d47ba6e9131fee1d1f09507d6fb7 /mysql-test/r/distinct.result | |
| parent | 8ab4a7a1019f7ecbac65a41718e79155a073945a (diff) | |
| download | mariadb-git-3bb2c4e325eab4d913207b06ec28458583647ba7.tar.gz | |
After merge adjustment of tests due to changes in cost estimates.
Diffstat (limited to 'mysql-test/r/distinct.result')
| -rw-r--r-- | mysql-test/r/distinct.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result index 3d0252b7cd8..2bb9cb9fa07 100644 --- a/mysql-test/r/distinct.result +++ b/mysql-test/r/distinct.result @@ -200,16 +200,16 @@ select distinct 1 from t1,t3 where t1.a=t3.a; 1 explain SELECT distinct t1.a from t1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL PRIMARY 4 NULL 5 Using index for group-by +1 SIMPLE t1 index NULL PRIMARY 4 NULL 4 Using index explain SELECT distinct t1.a from t1 order by a desc; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL PRIMARY 4 NULL 5 Using index for group-by; Using temporary; Using filesort +1 SIMPLE t1 index NULL PRIMARY 4 NULL 4 Using index explain SELECT t1.a from t1 group by a order by a desc; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range NULL PRIMARY 4 NULL 5 Using index for group-by; Using temporary; Using filesort +1 SIMPLE t1 index NULL PRIMARY 4 NULL 4 Using index explain SELECT distinct t1.a from t1 order by a desc limit 1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 index NULL PRIMARY 4 NULL 5 Using index +1 SIMPLE t1 index NULL PRIMARY 4 NULL 4 Using index explain SELECT distinct a from t3 order by a desc limit 2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t3 index NULL a 5 NULL 10 Using index |