diff options
| author | unknown <hf@deer.(none)> | 2005-03-07 16:38:05 +0400 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2005-03-07 16:38:05 +0400 |
| commit | 34ff8fbdb1833128d69b2154174ef1b0260eba2b (patch) | |
| tree | 8a3dbd22b523956afee19b02413dbecfd8158e7a /mysql-test/r/func_group.result | |
| parent | 07d5ddb75559f87a8286e93de0a4757c1aaa7ee4 (diff) | |
| download | mariadb-git-34ff8fbdb1833128d69b2154174ef1b0260eba2b.tar.gz | |
Fix for bug #8465 (MIN, MAX return incorrect result)
mysql-test/r/func_group.result:
test result fixed
mysql-test/t/func_group.test:
testcase added
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 90757e39612..6b8e729dcf2 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -842,3 +842,16 @@ col1 count(col1) sum(col1) avg(col1) -5.000000000010 4 -20.000000000040 -5.0000000000100000 -5.000000000000 2 -10.000000000000 -5.0000000000000000 DROP TABLE t1; +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; +col1 sum(col1) max(col1) min(col1) +-5.000000000010 -10.000000000020 -5.000000000010 -5.000000000010 +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; +col1 sum(col1) max(col1) min(col1) +5.000000000010 10.000000000020 5.000000000010 5.000000000010 +DROP TABLE t1; |