diff options
| author | unknown <hf@deer.(none)> | 2005-03-07 16:08:06 +0400 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2005-03-07 16:08:06 +0400 |
| commit | 07d5ddb75559f87a8286e93de0a4757c1aaa7ee4 (patch) | |
| tree | 67d13c87ba3892a2ddde8bde4784bde2142770a3 /mysql-test/r/func_group.result | |
| parent | 0ae5efb4dc1df3af598030cf7b96b95841306c70 (diff) | |
| download | mariadb-git-07d5ddb75559f87a8286e93de0a4757c1aaa7ee4.tar.gz | |
Fix for bug #8464 (AVG returns incorrect result)
Actually problem was not in AVG function, but in SUM before the AVG in the
query.
mysql-test/r/func_group.result:
appropriate test result
mysql-test/t/func_group.test:
test case added
strings/decimal.c:
in this case we also need to make fsizes equal
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index ea299455364..90757e39612 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -832,3 +832,13 @@ id stddev_pop(value1) var_pop(value1) stddev_samp(value1) var_samp(value1) 1 0.816497 0.666667 1.000000 1.000000 2 1.118034 1.250000 1.290994 1.666667 DROP TABLE t1; +CREATE TABLE t1 (col1 decimal(16,12)); +INSERT INTO t1 VALUES (-5.00000000001),(-5.00000000002),(-5.00000000003),(-5.00000000000),(-5.00000000001),(-5.00000000002); +insert into t1 select * from t1; +select col1,count(col1),sum(col1),avg(col1) from t1 group by col1; +col1 count(col1) sum(col1) avg(col1) +-5.000000000030 2 -10.000000000060 -5.0000000000300000 +-5.000000000020 4 -20.000000000080 -5.0000000000200000 +-5.000000000010 4 -20.000000000040 -5.0000000000100000 +-5.000000000000 2 -10.000000000000 -5.0000000000000000 +DROP TABLE t1; |