diff options
| author | Alexander Barkov <bar@mariadb.org> | 2014-03-23 19:43:01 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2014-03-23 19:43:01 +0400 |
| commit | ce3c457e6d6f282967154cd7a56d1382c652cb2b (patch) | |
| tree | 15da340214c2b54f86046cc18a964f43e68f5e0b /mysql-test/t | |
| parent | 92bd6801b9315607ab7f2af2ea45066a3ffbd70b (diff) | |
| download | mariadb-git-ce3c457e6d6f282967154cd7a56d1382c652cb2b.tar.gz | |
MDEV-5781 Item_sum_std::val_real(): Assertion `nr >= 0.0' fails on query with STDDEV_POP, ROUND and variable
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/func_math.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test index b843cf8c364..92ef362c32c 100644 --- a/mysql-test/t/func_math.test +++ b/mysql-test/t/func_math.test @@ -559,3 +559,21 @@ select 5.0 div 2.0; select 5.0 div 2; select 5 div 2.0; select 5.9 div 2, 1.23456789e3 DIV 2, 1.23456789e9 DIV 2, 1.23456789e19 DIV 2; + +--echo # +--echo # End of 5.5 tests +--echo # + +--echo # +--echo # Start of 10.0 tests +--echo # + +--echo # +--echo # MDEV-5781 Item_sum_std::val_real(): Assertion `nr >= 0.0' fails on query with STDDEV_POP, ROUND and variable +--echo # +SELECT STDDEV_POP(ROUND(0,@A:=2009)) FROM (SELECT 1 UNION SELECT 2) fake_table; + + +--echo # +--echo # End of 10.0 tests +--echo # |