diff options
| author | unknown <ramil@mysql.com> | 2005-11-22 18:29:46 +0400 |
|---|---|---|
| committer | unknown <ramil@mysql.com> | 2005-11-22 18:29:46 +0400 |
| commit | 4e846a3d274357de741aa8c53f6eeba04aa00fc9 (patch) | |
| tree | 636836023b7746f26e84336aa50f7cb2d83ab664 /mysql-test/t/func_group.test | |
| parent | ac5159a86a4d38fc43ca43f5ec804e3f19574f15 (diff) | |
| download | mariadb-git-4e846a3d274357de741aa8c53f6eeba04aa00fc9.tar.gz | |
Fix for bug #10966: Variance functions return wrong data type.
sql/item_sum.cc:
Fix for bug #10966: Variance functions return wrong data type.
Always return Field_double if no grouping.
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index c667f90940c..7e102ebaf29 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -703,3 +703,14 @@ SELECT SUM(a) FROM t1 GROUP BY b/c; DROP TABLE t1; set div_precision_increment= @sav_dpi; +# +# 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; +
\ No newline at end of file |