diff options
| author | svoj@mysql.com <> | 2005-02-25 22:19:04 +0400 |
|---|---|---|
| committer | svoj@mysql.com <> | 2005-02-25 22:19:04 +0400 |
| commit | 800aaae1fb347c91c45473a93563296d17110d30 (patch) | |
| tree | dacd1c6c90c80b374fbffd31ffd2a7caed5943fa /mysql-test/r/func_group.result | |
| parent | fe2a800423c96127987d4a9d6eb598bb5a2dca24 (diff) | |
| download | mariadb-git-800aaae1fb347c91c45473a93563296d17110d30.tar.gz | |
BUG#3190 fix (request for STDDEV_SAMP, VAR_SAMP).
This bug is also known as WL#1639.
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index b3eee950656..017a6a239df 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -804,3 +804,10 @@ select cast(min(ifl) as decimal(5,2)) from t3; cast(min(ifl) as decimal(5,2)) 1.00 drop table t1, t2, t3; +CREATE TABLE t1 (id int(11),value1 float(10,2)); +INSERT INTO t1 VALUES (1,0.00),(1,1.00), (1,2.00), (2,10.00), (2,11.00), (2,12.00), (2,13.00); +select id, stddev_pop(value1), var_pop(value1), stddev_samp(value1), var_samp(value1) from t1 group by id; +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; |