diff options
author | unknown <kaa@kaamos.(none)> | 2008-03-19 14:25:36 +0300 |
---|---|---|
committer | unknown <kaa@kaamos.(none)> | 2008-03-19 14:25:36 +0300 |
commit | e829d36367a831974d081d8fa7cb9273204b5b25 (patch) | |
tree | e5616a3156ac5506cc8a5ce194ecad7054282c34 /mysql-test/t/func_group.test | |
parent | c690b6673af4fcdc473ad0dab08db80d27f354dc (diff) | |
parent | 8270d9875ff44900f3c57c15711c03d0b83cbe5d (diff) | |
download | mariadb-git-e829d36367a831974d081d8fa7cb9273204b5b25.tar.gz |
Merge kaamos.(none):/data/src/opt/bug34512/my50
into kaamos.(none):/data/src/opt/bug34512/my51
mysql-test/r/func_group.result:
Auto merged
mysql-test/t/func_group.test:
Auto merged
sql/item_sum.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/func_group.test')
-rw-r--r-- | mysql-test/t/func_group.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 36d360780cf..b6143bc0c78 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -923,5 +923,15 @@ DROP VIEW v1; DROP TABLE t1; SET SQL_MODE=DEFAULT; +# +# Bug #34512: CAST( AVG( double ) AS DECIMAL ) returns wrong results +# + +CREATE TABLE t1(a DOUBLE); +INSERT INTO t1 VALUES (10), (20); +SELECT AVG(a), CAST(AVG(a) AS DECIMAL) FROM t1; + +DROP TABLE t1; + ### --echo End of 5.0 tests |