diff options
| author | unknown <timour@mysql.com> | 2006-03-31 12:39:33 +0300 |
|---|---|---|
| committer | unknown <timour@mysql.com> | 2006-03-31 12:39:33 +0300 |
| commit | 085aa5c99e7935b0895d09acad13685ba2e6c3e4 (patch) | |
| tree | 88258692d6bed7dc04376eda6523507dc716bcd6 /mysql-test/r/group_min_max.result | |
| parent | 86504f87851d7eb5947d3bba41ae0ddf45aa92ab (diff) | |
| parent | a01d48f92e9c2eebe91e92962b5fdb075978c712 (diff) | |
| download | mariadb-git-085aa5c99e7935b0895d09acad13685ba2e6c3e4.tar.gz | |
Merge mysql.com:/home/timka/mysql/src/5.0-virgin
into mysql.com:/home/timka/mysql/src/5.0-bug-16710
mysql-test/r/group_min_max.result:
Auto merged
mysql-test/t/group_min_max.test:
Auto merged
sql/item.cc:
Auto merged
sql/item.h:
Auto merged
sql/opt_range.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/group_min_max.result')
| -rw-r--r-- | mysql-test/r/group_min_max.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/group_min_max.result b/mysql-test/r/group_min_max.result index b889d031079..6370f7699b3 100644 --- a/mysql-test/r/group_min_max.result +++ b/mysql-test/r/group_min_max.result @@ -1954,6 +1954,15 @@ id select_type table type possible_keys key key_len ref rows Extra explain select sum(ord(a1)) from t1 where (a1 > 'a') group by a1,a2,b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index idx_t1_0,idx_t1_1,idx_t1_2 idx_t1_1 163 NULL 128 Using where; Using index +explain select distinct(a1) from t1 where ord(a2) = 98; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 index NULL idx_t1_1 163 NULL 128 Using where; Using index +select distinct(a1) from t1 where ord(a2) = 98; +a1 +a +b +c +d explain select a1 from t1 where a2 = 'b' group by a1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range NULL idx_t1_1 130 NULL 5 Using where; Using index for group-by |