diff options
| author | unknown <konstantin@mysql.com> | 2003-12-09 23:52:58 +0300 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2003-12-09 23:52:58 +0300 |
| commit | 1c30ec097027ebef052992ac7accfcdf8a19f227 (patch) | |
| tree | 1614a1388a5a24cb4eb731d38d2bea6e472fb49a /mysql-test/r/group_by.result | |
| parent | 6f96fb795684400b06af96ad535d7f84d33a9273 (diff) | |
| download | mariadb-git-1c30ec097027ebef052992ac7accfcdf8a19f227.tar.gz | |
Fix for bug #1335: filesort is missing in EXPLAIN if ORDER BY NULL is used
mysql-test/r/group_by.result:
test results fixed
mysql-test/t/group_by.test:
added few explicit tests for bug #1335
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index f89cb8a6792..861f0f009cd 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -287,7 +287,7 @@ table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 8 Using filesort explain select sql_big_result spid,sum(userid) from t1 group by spid desc order by null; table type possible_keys key key_len ref rows Extra -t1 ALL NULL NULL NULL NULL 8 +t1 ALL NULL NULL NULL NULL 8 Using filesort select sql_big_result spid,sum(userid) from t1 group by spid desc; spid sum(userid) 7 3 @@ -597,3 +597,18 @@ count(*) category 1 3 1 4 drop table t1; +userid count(*) +3 5 +2 1 +1 2 +EXPLAIN SELECT userid,count(*) FROM t1 GROUP BY userid DESC; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 8 Using temporary; Using filesort +i COUNT(DISTINCT(i)) +1 1 +2 1 +4 4 +explain SELECT i, COUNT(DISTINCT(i)) FROM t1 GROUP BY j ORDER BY NULL; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 6 Using filesort +DROP TABLE t1; |