diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_math.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/func_math.test | 7 |
2 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result index c7674c57c8d..b7188092b41 100644 --- a/mysql-test/r/func_math.result +++ b/mysql-test/r/func_math.result @@ -146,3 +146,9 @@ drop table t1; select round(150, 2); round(150, 2) 150.00 +select ceil(0.09); +ceil(0.09) +1 +select ceil(0.000000000000000009); +ceil(0.000000000000000009) +1 diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test index 03057af6911..da4b8335e07 100644 --- a/mysql-test/t/func_math.test +++ b/mysql-test/t/func_math.test @@ -84,3 +84,10 @@ drop table t1; # Bug #10083 (round doesn't increase decimals) # select round(150, 2); + +# +# Bug @10632 (Ceiling function returns wrong answer) +# +select ceil(0.09); +select ceil(0.000000000000000009); + |