diff options
| author | Paul McCullagh <paul.mccullagh@primebase.org> | 2009-08-17 17:57:58 +0200 |
|---|---|---|
| committer | Paul McCullagh <paul.mccullagh@primebase.org> | 2009-08-17 17:57:58 +0200 |
| commit | 10cedc20e71d2879edcf3a0ed87d99798a4f8101 (patch) | |
| tree | 160198e1d4c4362656b76ceaa087109c3a972475 /mysql-test/suite/pbxt/r/func_group.result | |
| parent | b8ed67997366e980afd0a822dbc318011f8f09c6 (diff) | |
| download | mariadb-git-10cedc20e71d2879edcf3a0ed87d99798a4f8101.tar.gz | |
Updated all tests for RC2
Diffstat (limited to 'mysql-test/suite/pbxt/r/func_group.result')
| -rw-r--r-- | mysql-test/suite/pbxt/r/func_group.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/pbxt/r/func_group.result b/mysql-test/suite/pbxt/r/func_group.result index d5f804dee03..d1a0d09ad09 100644 --- a/mysql-test/suite/pbxt/r/func_group.result +++ b/mysql-test/suite/pbxt/r/func_group.result @@ -61,7 +61,7 @@ grp sum NULL NULL 1 7 2 20.25 -3 45.483163247594 +3 45.4831632475944 create table t2 (grp int, a bigint unsigned, c char(10)); insert into t2 select grp,max(a)+max(grp),max(c) from t1 group by grp; replace into t2 select grp, a, c from t1 limit 2,1; @@ -613,8 +613,8 @@ id select_type table type possible_keys key key_len ref rows Extra explain select max(t1.a3), min(t2.a2) from t1, t2 where t1.a2 = 2 and t1.a3 < 'MIN' and t2.a3 > 'CA'; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 range k1 k1 3 NULL 1 Using where; Using index -1 SIMPLE t1 range k1 k1 7 NULL 1 Using where; Using index; Using join buffer +1 SIMPLE t1 range k1 k1 7 NULL 1 Using where; Using index +1 SIMPLE t2 range k1 k1 3 NULL 1 Using where; Using index; Using join buffer explain select min(a4 - 0.01) from t1; id select_type table type possible_keys key key_len ref rows Extra @@ -1186,7 +1186,7 @@ std(s1/s2) 0.21325764 select std(o1/o2) from bug22555; std(o1/o2) -0.21325763586649 +0.213257635866493 select std(e1/e2) from bug22555; std(e1/e2) 0.21325764 @@ -1212,7 +1212,7 @@ round(std(s1/s2), 17) 0.21325763586649341 select std(o1/o2) from bug22555; std(o1/o2) -0.21325763586649 +0.213257635866493 select round(std(e1/e2), 17) from bug22555; round(std(e1/e2), 17) 0.21325763586649341 @@ -1237,7 +1237,7 @@ round(std(s1/s2), 17) 0.21325763586649341 select std(o1/o2) from bug22555; std(o1/o2) -0.21325763586649 +0.213257635866493 select round(std(e1/e2), 17) from bug22555; round(std(e1/e2), 17) 0.21325763586649341 |