diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-05-05 16:06:01 +0500 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-05-05 16:06:01 +0500 |
| commit | 393ed84c9a0cd98479aa8bf8c4de1236740639ea (patch) | |
| tree | 3e92d79cf977b8227075452a38bf4357ea176d40 /mysql-test/r/func_group.result | |
| parent | 575541b9f755425eaeb07babfa07b6fd30f6d5d1 (diff) | |
| download | mariadb-git-393ed84c9a0cd98479aa8bf8c4de1236740639ea.tar.gz | |
a fix (Bug #3435: STDDEV|VARIANCE(constant) returns constant if no rows)
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 5192251795b..57b109e1ee6 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -648,3 +648,11 @@ select a from t1 having a=1; a 1 drop table t1; +create table t1 (a int); +select variance(2) from t1; +variance(2) +NULL +select stddev(2) from t1; +stddev(2) +NULL +drop table t1; |