diff options
| author | unknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru> | 2007-02-27 11:01:58 +0400 |
|---|---|---|
| committer | unknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru> | 2007-02-27 11:01:58 +0400 |
| commit | 9bbd385a8952159b0d592acbbbd0f66c30c29e77 (patch) | |
| tree | 11063d085beccd779cb83e1b56634072b0033d72 /mysql-test/r/func_group.result | |
| parent | f80babd61720298f8e3862f21b1851203cbcf871 (diff) | |
| download | mariadb-git-9bbd385a8952159b0d592acbbbd0f66c30c29e77.tar.gz | |
Fix for bug #25834: Test failure in "func_group"
Round the results of std() for some calls with double arguments
to avoid double math precision problems.
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index d18837aed41..e421da1c462 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -1180,11 +1180,11 @@ i count(*) std(s1/s2) 1 4 0.00000000 2 4 0.00000000 3 4 0.00000000 -select i, count(*), std(o1/o2) from bug22555 group by i order by i; -i count(*) std(o1/o2) -1 4 0 -2 4 0 -3 4 0 +select i, count(*), round(std(o1/o2), 16) from bug22555 group by i order by i; +i count(*) round(std(o1/o2), 16) +1 4 0.0000000000000000 +2 4 0.0000000000000000 +3 4 0.0000000000000000 select i, count(*), std(e1/e2) from bug22555 group by i order by i; i count(*) std(e1/e2) 1 4 0.00000000 @@ -1206,11 +1206,11 @@ i count(*) std(s1/s2) 1 4 0.000000000000000000000000000000 2 4 0.000000000000000000000000000000 3 4 0.000000000000000000000000000000 -select i, count(*), std(o1/o2) from bug22555 group by i order by i; -i count(*) std(o1/o2) -1 4 0 -2 4 0 -3 4 0 +select i, count(*), round(std(o1/o2), 16) from bug22555 group by i order by i; +i count(*) round(std(o1/o2), 16) +1 4 0.0000000000000000 +2 4 0.0000000000000000 +3 4 0.0000000000000000 select i, count(*), std(e1/e2) from bug22555 group by i order by i; i count(*) std(e1/e2) 1 4 0.000000000000000000000000000000 @@ -1231,11 +1231,11 @@ i count(*) std(s1/s2) 1 4 0.000000000000000000000000000000 2 4 0.000000000000000000000000000000 3 4 0.000000000000000000000000000000 -select i, count(*), std(o1/o2) from bug22555 group by i order by i; -i count(*) std(o1/o2) -1 4 0 -2 4 0 -3 4 0 +select i, count(*), round(std(o1/o2), 16) from bug22555 group by i order by i; +i count(*) round(std(o1/o2), 16) +1 4 0.0000000000000000 +2 4 0.0000000000000000 +3 4 0.0000000000000000 select i, count(*), std(e1/e2) from bug22555 group by i order by i; i count(*) std(e1/e2) 1 4 0.000000000000000000000000000000 |