diff options
author | unknown <holyfoot@hf-ibm.(none)> | 2005-06-08 15:49:36 +0500 |
---|---|---|
committer | unknown <holyfoot@hf-ibm.(none)> | 2005-06-08 15:49:36 +0500 |
commit | 4408350b51278b085533050f4ad5ef59955baccd (patch) | |
tree | 934ffa52aa1df1de3b1ab029692103e5cee518a1 /mysql-test/t/func_math.test | |
parent | b5755ae60b2fac28f450edd64b1e98249d8660d8 (diff) | |
download | mariadb-git-4408350b51278b085533050f4ad5ef59955baccd.tar.gz |
Fix for bug #8429 (FORMAT returns incorrect result)
mysql-test/r/func_math.result:
test result ixed
mysql-test/t/func_math.test:
test case added
sql/item_strfunc.cc:
Item_func_format::val_str now handles 'decimal' and 'double' values in
different way
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; + |