diff options
| author | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-05-21 22:29:39 +0500 |
|---|---|---|
| committer | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-05-21 22:29:39 +0500 |
| commit | 7e1edbd6a5faf38a1d7f7c8fd10a355319870e8c (patch) | |
| tree | e1c6f32174ad2f04c85a1afeaffc0845ecfbfecd /mysql-test | |
| parent | 468c2b2173c5ea9f156971245876c67c0e1c8ce9 (diff) | |
| parent | 1436ceb57b37a09afd61f8cbb9dcd439857c102f (diff) | |
| download | mariadb-git-7e1edbd6a5faf38a1d7f7c8fd10a355319870e8c.tar.gz | |
Merge abotchkov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into mysql.com:/home/hf/work/27984/my50-27984
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/type_newdecimal.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/type_newdecimal.test | 5 |
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/type_newdecimal.result b/mysql-test/r/type_newdecimal.result index d91baaa0394..9e165721033 100644 --- a/mysql-test/r/type_newdecimal.result +++ b/mysql-test/r/type_newdecimal.result @@ -1468,4 +1468,7 @@ Error 1264 Out of range value adjusted for column 'cast(a as DECIMAL(3,2))' at r create table t1 (s varchar(100)); insert into t1 values (0.00000000010000000000000000364321973154977415791655470655996396089904010295867919921875); drop table t1; +SELECT 1.000000000000 * 99.999999999998 / 100 a,1.000000000000 * (99.999999999998 / 100) b; +a b +0.9999999999999800000000000000 0.9999999999999800000000000000 End of 5.0 tests diff --git a/mysql-test/t/type_newdecimal.test b/mysql-test/t/type_newdecimal.test index 09b20fb14d3..d2b808bd5e0 100644 --- a/mysql-test/t/type_newdecimal.test +++ b/mysql-test/t/type_newdecimal.test @@ -1157,4 +1157,9 @@ create table t1 (s varchar(100)); insert into t1 values (0.00000000010000000000000000364321973154977415791655470655996396089904010295867919921875); drop table t1; +# +# Bug #27984 Long Decimal Maths produces truncated results +# + +SELECT 1.000000000000 * 99.999999999998 / 100 a,1.000000000000 * (99.999999999998 / 100) b; --echo End of 5.0 tests |