diff options
| author | hf@deer.(none) <> | 2005-03-07 16:38:05 +0400 |
|---|---|---|
| committer | hf@deer.(none) <> | 2005-03-07 16:38:05 +0400 |
| commit | cef95249bd993e5a6cb983d6deff64fcaed02ef5 (patch) | |
| tree | 8a3dbd22b523956afee19b02413dbecfd8158e7a /mysql-test/t/func_group.test | |
| parent | b8e5df4b7d2da080f9010d342538fea8b827963c (diff) | |
| download | mariadb-git-cef95249bd993e5a6cb983d6deff64fcaed02ef5.tar.gz | |
Fix for bug #8465 (MIN, MAX return incorrect result)
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index b90fa49db93..3564918df9c 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -548,3 +548,16 @@ insert into t1 select * from t1; select col1,count(col1),sum(col1),avg(col1) from t1 group by col1; DROP TABLE t1; +# +# BUG#8465 decimal MIN and MAX return incorrect result +# + +create table t1 (col1 decimal(16,12)); +insert into t1 values (-5.00000000001); +insert into t1 values (-5.00000000001); +select col1,sum(col1),max(col1),min(col1) from t1 group by col1; +delete from t1; +insert into t1 values (5.00000000001); +insert into t1 values (5.00000000001); +select col1,sum(col1),max(col1),min(col1) from t1 group by col1; +DROP TABLE t1; |