diff options
| author | monty@hundin.mysql.fi <> | 2001-12-10 17:51:07 +0200 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2001-12-10 17:51:07 +0200 |
| commit | 12058c299647533050950d1dd5952c666c2eceb2 (patch) | |
| tree | 40df440fc1708f1f09301e5f4f923c08a4470ec9 /mysql-test/r/group_by.result | |
| parent | 0f71e337b32c3388070f96160234df86eae964f8 (diff) | |
| download | mariadb-git-12058c299647533050950d1dd5952c666c2eceb2.tar.gz | |
Fixed bug in GROUP BY ... DESC
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 2c4a5cecbb1..d5fcc7d85e8 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -34,3 +34,33 @@ Test Procedures 0 2 a 0 1+1 a count(*) 2 a 0 +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 6 Using temporary +userid count(*) +3 3 +2 1 +1 2 +table type possible_keys key key_len ref rows Extra +t1 range spID spID 5 NULL 2 where used; Using index; Using temporary +table type possible_keys key key_len ref rows Extra +t1 range spID spID 5 NULL 2 where used; Using index +spid count(*) +1 1 +2 2 +spid count(*) +2 2 +1 1 +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 6 Using filesort +spid sum(userid) +5 3 +4 3 +3 3 +2 3 +1 1 +table type possible_keys key key_len ref rows Extra +t1 index NULL score 3 NULL 6 Using index +score count(*) +3 3 +2 1 +1 2 |