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/t/group_min_max.test | |
| 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/t/group_min_max.test')
| -rw-r--r-- | mysql-test/t/group_min_max.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/group_min_max.test b/mysql-test/t/group_min_max.test index 0f0a632ff67..bff07366ec2 100644 --- a/mysql-test/t/group_min_max.test +++ b/mysql-test/t/group_min_max.test @@ -641,6 +641,14 @@ explain select a1,a2,count(a2) from t1 group by a1,a2,b; explain select a1,a2,count(a2) from t1 where (a1 > 'a') group by a1,a2,b; explain select sum(ord(a1)) from t1 where (a1 > 'a') group by a1,a2,b; + +# +# Bug #16710: select distinct doesn't return all it should +# + +explain select distinct(a1) from t1 where ord(a2) = 98; +select distinct(a1) from t1 where ord(a2) = 98; + # # BUG#11044: DISTINCT or GROUP BY queries with equality predicates instead of MIN/MAX. # |