diff options
| author | unknown <timour@mysql.com> | 2004-10-11 20:10:07 +0300 |
|---|---|---|
| committer | unknown <timour@mysql.com> | 2004-10-11 20:10:07 +0300 |
| commit | 662b24f81ea21868643720043501dfc98d754822 (patch) | |
| tree | c18fbef94db2d47ba6e9131fee1d1f09507d6fb7 /mysql-test/r/distinct.result | |
| parent | 81f7ade6627d3ab8f5e1100a97f7a3cd7ff5bad2 (diff) | |
| download | mariadb-git-662b24f81ea21868643720043501dfc98d754822.tar.gz | |
After merge adjustment of tests due to changes in cost estimates.
BitKeeper/etc/ignore:
Added server-tools/instance-manager/mysqlmanager to the ignore list
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 |