diff options
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index f28ce234b73..c2dd77e662a 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -675,3 +675,15 @@ SELECT SQL_NO_CACHE FROM t1 t, t2 c WHERE t.a = c.b; DROP TABLE t1,t2; + +# +# Bug #10966: Variance functions return wrong data type +# + +create table t1 select variance(0); +show create table t1; +drop table t1; +create table t1 select stddev(0); +show create table t1; +drop table t1; + |