diff options
| author | unknown <marko@hundin.mysql.fi> | 2004-10-05 16:02:10 +0300 |
|---|---|---|
| committer | unknown <marko@hundin.mysql.fi> | 2004-10-05 16:02:10 +0300 |
| commit | 4535f80e600f93eb200f3bd40d74dd341d75929b (patch) | |
| tree | 8f74f907801c9488862cd502c6059497de0b5d2e /mysql-test | |
| parent | 6d4058a994397d9ce06806c23b461a892cd589e3 (diff) | |
| parent | 438cc71abfeff4839017a67d3401774eaf210bf1 (diff) | |
| download | mariadb-git-4535f80e600f93eb200f3bd40d74dd341d75929b.tar.gz | |
Merge marko@build.mysql.com:/home/bk/mysql-4.1
into hundin.mysql.fi:/home/marko/j/mysql-4.1
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_group.result | 26 | ||||
| -rw-r--r-- | mysql-test/t/func_group.test | 24 |
2 files changed, 50 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 011a47874c2..c25f89d4df3 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -693,3 +693,29 @@ SELECT MIN(a) FROM t1 WHERE a < 0; MIN(a) NULL DROP TABLE t1; +CREATE TABLE t1 ( +id int(10) unsigned NOT NULL auto_increment, +val enum('one','two','three') NOT NULL default 'one', +PRIMARY KEY (id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +INSERT INTO t1 VALUES +(1,'one'),(2,'two'),(3,'three'),(4,'one'),(5,'two'); +select val, count(*) from t1 group by val; +val count(*) +one 2 +two 2 +three 1 +drop table t1; +CREATE TABLE t1 ( +id int(10) unsigned NOT NULL auto_increment, +val set('one','two','three') NOT NULL default 'one', +PRIMARY KEY (id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +INSERT INTO t1 VALUES +(1,'one'),(2,'two'),(3,'three'),(4,'one'),(5,'two'); +select val, count(*) from t1 group by val; +val count(*) +one 2 +two 2 +three 1 +drop table t1; diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 7f48f2b92bd..3e001961f90 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -431,6 +431,30 @@ SELECT MIN(a) FROM t1 WHERE a < 0; DROP TABLE t1; +# +# Bug #5555 GROUP BY enum_field" returns incorrect results +# + +CREATE TABLE t1 ( + id int(10) unsigned NOT NULL auto_increment, + val enum('one','two','three') NOT NULL default 'one', + PRIMARY KEY (id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO t1 VALUES +(1,'one'),(2,'two'),(3,'three'),(4,'one'),(5,'two'); + +select val, count(*) from t1 group by val; +drop table t1; +CREATE TABLE t1 ( + id int(10) unsigned NOT NULL auto_increment, + val set('one','two','three') NOT NULL default 'one', + PRIMARY KEY (id) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +INSERT INTO t1 VALUES +(1,'one'),(2,'two'),(3,'three'),(4,'one'),(5,'two'); +select val, count(*) from t1 group by val; +drop table t1; |