bk commit into 5.0 tree (ramil:1.2444) BUG#25834

[ramil]

Below is the list of changes that have just been committed into a local
5.0 repository of ram. When ram does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-02-27 11:01:58+04:00, ramil@stripped +2 -0
  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@stripped, 2007-02-27 11:01:57+04:00, ramil@stripped +15 -15
    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/t/func_group.test@stripped, 2007-02-27 11:01:57+04:00, ramil@stripped +3 -3
    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.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	ramil
# Host:	ramil.myoffice.izhnet.ru
# Root:	/home/ram/work/b25834/b25834.5.0

--- 1.58/mysql-test/r/func_group.result	2007-02-27 11:02:02 +04:00
+++ 1.59/mysql-test/r/func_group.result	2007-02-27 11:02:02 +04:00
@@ -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

--- 1.53/mysql-test/t/func_group.test	2007-02-27 11:02:02 +04:00
+++ 1.54/mysql-test/t/func_group.test	2007-02-27 11:02:02 +04:00
@@ -747,7 +747,7 @@ insert into bug22555 values (1,53,78,53,
 insert into bug22555 values (1,53,78,53,78,53,78),(2,17,78,17,78,17,78),(3,18,76,18,76,18,76);
 
 select i, count(*), std(s1/s2) from bug22555 group by i order by i;
-select i, count(*), std(o1/o2) from bug22555 group by i order by i;
+select i, count(*), round(std(o1/o2), 16) from bug22555 group by i order by i;
 select i, count(*), std(e1/e2) from bug22555 group by i order by i;
 select std(s1/s2) from bug22555;
 select std(o1/o2) from bug22555;
@@ -755,14 +755,14 @@ select std(e1/e2) from bug22555;
 set @saved_div_precision_increment=@@div_precision_increment;
 set div_precision_increment=19;
 select i, count(*), std(s1/s2) from bug22555 group by i order by i;
-select i, count(*), std(o1/o2) from bug22555 group by i order by i;
+select i, count(*), round(std(o1/o2), 16) from bug22555 group by i order by i;
 select i, count(*), std(e1/e2) from bug22555 group by i order by i;
 select round(std(s1/s2), 17) from bug22555;
 select std(o1/o2) from bug22555;
 select round(std(e1/e2), 17) from bug22555;
 set div_precision_increment=20;
 select i, count(*), std(s1/s2) from bug22555 group by i order by i;
-select i, count(*), std(o1/o2) from bug22555 group by i order by i;
+select i, count(*), round(std(o1/o2), 16) from bug22555 group by i order by i;
 select i, count(*), std(e1/e2) from bug22555 group by i order by i;
 select round(std(s1/s2), 17) from bug22555;
 select std(o1/o2) from bug22555;