diff options
| author | unknown <ramil@mysql.com> | 2005-02-28 18:11:18 +0400 |
|---|---|---|
| committer | unknown <ramil@mysql.com> | 2005-02-28 18:11:18 +0400 |
| commit | 7865746c27c2ec164fa97c914fef5d80239bce81 (patch) | |
| tree | 5f944a93b81ec4584682abfae38393fa2839e673 /mysql-test/t/func_group.test | |
| parent | c8b3d65ca26ff2be783115da2fb7c790dd4338e4 (diff) | |
| parent | 556950da46e61a1a04f0531f6d96ec60c7ede79c (diff) | |
| download | mariadb-git-7865746c27c2ec164fa97c914fef5d80239bce81.tar.gz | |
merging
mysql-test/r/show_check.result:
Auto merged
sql/sql_select.cc:
Auto 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 465611a5ebb..1ee812e5c2f 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -474,6 +474,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 |