diff options
| author | unknown <jani@ua141d10.elisa.omakaista.fi> | 2005-03-01 14:50:59 +0200 |
|---|---|---|
| committer | unknown <jani@ua141d10.elisa.omakaista.fi> | 2005-03-01 14:50:59 +0200 |
| commit | 425573747f54cf54187a0985e21fddf580c8e924 (patch) | |
| tree | de6c64a9195bb705263b9e50dd5fe861ba9a7dff /mysql-test/t/func_group.test | |
| parent | 679088a2ae1353f14a970182fa64f58170e81b72 (diff) | |
| parent | 1a3ee0dec50cb71d314ed6935a012760f0cb72d4 (diff) | |
| download | mariadb-git-425573747f54cf54187a0985e21fddf580c8e924.tar.gz | |
Merge
mysql-test/r/func_group.result:
Auto merged
mysql-test/r/ps.result:
Auto merged
mysql-test/r/select_found.result:
Auto merged
mysql-test/r/show_check.result:
Auto merged
mysql-test/t/func_group.test:
Auto merged
mysql-test/t/show_check.test:
Auto merged
sql/mysqld.cc:
Auto merged
sql/sql_class.cc:
Auto merged
sql/sql_show.cc:
Auto merged
strings/ctype-bin.c:
Auto merged
sql/sql_select.cc:
SCCS merged
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 9a61e6f7029..51528be8952 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -479,6 +479,15 @@ INSERT INTO t1 VALUES select val, count(*) from t1 group by val; drop table t1; +# +# Bug #5615: type of aggregate function column wrong when using group by +# + +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; +drop table t1, t2; # # Bug 7833: Wrong datatype of aggregate column is returned |