From 393ed84c9a0cd98479aa8bf8c4de1236740639ea Mon Sep 17 00:00:00 2001
From: unknown <ram@gw.mysql.r18.ru>
Date: Wed, 5 May 2004 16:06:01 +0500
Subject: a fix (Bug #3435: STDDEV|VARIANCE(constant) returns constant if no
 rows)

---
 mysql-test/r/func_group.result | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'mysql-test/r/func_group.result')

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;
-- 
cgit v1.2.1