diff options
| author | unknown <monty@hundin.mysql.fi> | 2001-12-13 02:31:19 +0200 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2001-12-13 02:31:19 +0200 |
| commit | 33a096829b0f2a294b162e11ad81df788732c384 (patch) | |
| tree | 47a4c1a60e94a3e70ea5564124a296f7cd71605e /mysql-test/r/group_by.result | |
| parent | f0f71accfc2b6fcc6dfeaa1ac4b8b73d071ff3a1 (diff) | |
| download | mariadb-git-33a096829b0f2a294b162e11ad81df788732c384.tar.gz | |
Fixed sleep time in mysql-test-run
Fixed bug in query cache.
Cleaned up des_crypt code.
BitKeeper/deleted/.del-fsck.mysql~87170d4358b50d60:
Delete: fs/fsck.mysql
Docs/manual.texi:
Changed != to <>
mysql-test/mysql-test-run.sh:
Fix sleep times to take into account creation of InnoDB tables.
mysql-test/r/group_by.result:
More tests
mysql-test/r/query_cache.result:
More tests
mysql-test/r/union.result:
More tests
mysql-test/t/func_str.test:
Fix for FreeBSD
mysql-test/t/query_cache.test:
More tests
mysql-test/t/union.test:
More tests
mysys/my_winsem.c:
Cleanup comments
sql/des_key_file.cc:
Cleanup des_crypt code
sql/item_strfunc.cc:
Cleanup des_crypt code
sql/item_strfunc.h:
Cleanup des_crypt code
sql/mysql_priv.h:
Cleanup des_crypt code
sql/mysqld.cc:
Cleanup des_crypt code
sql/sql_acl.cc:
For for GRANT and lower-case-table names
sql/sql_cache.cc:
Function for integrity checking.
Fixed bug when merging blocks.
sql/sql_cache.h:
Function for integrity checking.
sql/sql_delete.cc:
Cleanup
sql/sql_parse.cc:
For for GRANT and lower-case-table names
sql/sql_union.cc:
Cleanup & fixed bug in LIMIT handling
sql/sql_yacc.yy:
C
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index d0b4ab4efff..a0e234aa69c 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -216,3 +216,50 @@ select 1+1,"a",count(*) from t1 where foo in (2); 1+1 a count(*) 2 a 0 drop table t1; +CREATE TABLE t1 ( +spID int(10) unsigned, +userID int(10) unsigned, +score smallint(5) unsigned, +key (spid), +key (score) +); +INSERT INTO t1 VALUES (1,1,1),(2,2,2),(2,1,1),(3,3,3),(4,3,3),(5,3,3); +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 6 Using temporary +select userid,count(*) from t1 group by userid desc; +userid count(*) +3 3 +2 1 +1 2 +explain select spid,count(*) from t1 where spid between 1 and 2 group by spid desc; +table type possible_keys key key_len ref rows Extra +t1 range spID spID 5 NULL 2 where used; Using index +explain select spid,count(*) from t1 where spid between 1 and 2 group by spid; +table type possible_keys key key_len ref rows Extra +t1 range spID spID 5 NULL 2 where used; Using index +select spid,count(*) from t1 where spid between 1 and 2 group by spid; +spid count(*) +1 1 +2 2 +select spid,count(*) from t1 where spid between 1 and 2 group by spid desc; +spid count(*) +explain select sql_big_result spid,sum(userid) from t1 group by spid desc; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 6 Using filesort +select sql_big_result spid,sum(userid) from t1 group by spid desc; +spid sum(userid) +5 3 +4 3 +3 3 +2 3 +1 1 +explain select sql_big_result score,count(*) from t1 group by score desc; +table type possible_keys key key_len ref rows Extra +t1 index NULL score 3 NULL 6 Using index +select sql_big_result score,count(*) from t1 group by score desc; +score count(*) +3 3 +2 1 +1 2 +drop table t1; |