diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-10-11 18:38:48 +0500 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-10-11 18:38:48 +0500 |
| commit | 47f8a473bd1179c7622deab59b491f5a9d91b211 (patch) | |
| tree | 1284afe19e807c2e3e78bc52396ba3c43d3fd568 /mysql-test/r | |
| parent | 1073271b1c19f57990cd58a22b9ae09953d042aa (diff) | |
| download | mariadb-git-47f8a473bd1179c7622deab59b491f5a9d91b211.tar.gz | |
A fix (bug #5615 type of aggregate function column wrong when using group by).
mysql-test/r/func_group.result:
test case (bug #5615 type of aggregate function column wrong when using group by)
mysql-test/t/func_group.test:
test case (bug #5615 type of aggregate function column wrong when using group by)
sql/sql_select.cc:
A fix (bug #5615 type of aggregate function column wrong when using group by):
should create a temporary field of the proper type in case of
MIN|MAX(field).
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_group.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index c25f89d4df3..ecf6422261f 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -719,3 +719,12 @@ one 2 two 2 three 1 drop table t1; +create table t1(a int, b datetime); +insert into t1 values (1, NOW()), (2, NOW()); +create table t2 select MAX(b) from t1 group by a; +show create table t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `MAX(b)` datetime default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1, t2; |