From 9bbd385a8952159b0d592acbbbd0f66c30c29e77 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 27 Feb 2007 11:01:58 +0400 Subject: 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. --- mysql-test/r/func_group.result | 30 +++++++++++++++--------------- 1 file changed, 15 insertions(+), 15 deletions(-) (limited to 'mysql-test/r') 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 -- cgit v1.2.1