diff options
| author | unknown <monty@hundin.mysql.fi> | 2001-12-10 17:51:07 +0200 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2001-12-10 17:51:07 +0200 |
| commit | 2d1e16eb04a3e78830447400a55f7cd2291e566c (patch) | |
| tree | 40df440fc1708f1f09301e5f4f923c08a4470ec9 /mysql-test/r/group_by.result | |
| parent | 6f8f45e9592aa7f2ca48168d51e1624cce158797 (diff) | |
| download | mariadb-git-2d1e16eb04a3e78830447400a55f7cd2291e566c.tar.gz | |
Fixed bug in GROUP BY ... DESC
Docs/manual.texi:
Changelog
libmysql/libmysql.c:
Fixed bug with mysql_use_result() when mysql_query() is called before mysql_free_result().
mysql-test/r/group_by.result:
New tests
mysql-test/t/group_by.test:
New tests
sql/stacktrace.c:
Fix for SCO
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 |