diff options
| author | unknown <konstantin@mysql.com> | 2003-12-10 01:08:10 +0300 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2003-12-10 01:08:10 +0300 |
| commit | b0a9299efee6db1be9340d02f73739f679ddd6a5 (patch) | |
| tree | ad09db2edd1b6bbaeb15ac722466df9f424121f8 /mysql-test/r/group_by.result | |
| parent | 1c30ec097027ebef052992ac7accfcdf8a19f227 (diff) | |
| download | mariadb-git-b0a9299efee6db1be9340d02f73739f679ddd6a5.tar.gz | |
bug #1335 tests followup:
--disable_query_log was not a good idea, Serg says
mysql-test/r/group_by.result:
bug #1335 tests followup:
--disable_query_log was not a good idea, Serg says
tests results updated
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 861f0f009cd..dba95614052 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -597,6 +597,13 @@ count(*) category 1 3 1 4 drop table t1; +CREATE TABLE t1 ( +userid int(10) unsigned, +score smallint(5) unsigned, +key (score) +); +INSERT INTO t1 VALUES (1,1),(2,2),(1,1),(3,3),(3,3),(3,3),(3,3),(3,3); +SELECT userid,count(*) FROM t1 GROUP BY userid DESC; userid count(*) 3 5 2 1 @@ -604,6 +611,13 @@ userid count(*) 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 +DROP TABLE t1; +CREATE TABLE t1 ( +i int(11) default NULL, +j int(11) default NULL +); +INSERT INTO t1 VALUES (1,2),(2,3),(4,5),(3,5),(1,5),(23,5); +SELECT i, COUNT(DISTINCT(i)) FROM t1 GROUP BY j ORDER BY NULL; i COUNT(DISTINCT(i)) 1 1 2 1 |