diff options
| author | holyfoot@hf-ibm.(none) <> | 2005-06-08 15:49:36 +0500 |
|---|---|---|
| committer | holyfoot@hf-ibm.(none) <> | 2005-06-08 15:49:36 +0500 |
| commit | ff9951f221493632c77d92623ebb431adda9e2d4 (patch) | |
| tree | 934ffa52aa1df1de3b1ab029692103e5cee518a1 /mysql-test/t/func_math.test | |
| parent | 71f06aa7782e7775843b1c0f4b83c229c95edb1e (diff) | |
| download | mariadb-git-ff9951f221493632c77d92623ebb431adda9e2d4.tar.gz | |
Fix for bug #8429 (FORMAT returns incorrect result)
Diffstat (limited to 'mysql-test/t/func_math.test')
| -rw-r--r-- | mysql-test/t/func_math.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test index 0eac72782a8..b21f38052b6 100644 --- a/mysql-test/t/func_math.test +++ b/mysql-test/t/func_math.test @@ -67,3 +67,15 @@ explain extended select degrees(pi()),radians(360); --error 1054 select rand(rand); + +# +# Bug #8459 (FORMAT returns incorrect result) +# +create table t1 (col1 int, col2 decimal(60,30)); +insert into t1 values(1,1234567890.12345); +select format(col2,7) from t1; +select format(col2,8) from t1; +insert into t1 values(7,1234567890123456.12345); +select format(col2,6) from t1 where col1=7; +drop table t1; + |