diff options
| author | unknown <holyfoot/hf@hfmain.(none)> | 2007-05-21 22:28:04 +0500 |
|---|---|---|
| committer | unknown <holyfoot/hf@hfmain.(none)> | 2007-05-21 22:28:04 +0500 |
| commit | 95b2152e7801e5d27d1a1fafa23989fd0bd66634 (patch) | |
| tree | 159ee86635ea76b121100a657d7daba96dd32333 /mysql-test/r/type_newdecimal.result | |
| parent | 2a399133515139e879b4332cb33e565952be90d7 (diff) | |
| parent | 322265882f1198a374f7002b0e85f89569e8ea2a (diff) | |
| download | mariadb-git-95b2152e7801e5d27d1a1fafa23989fd0bd66634.tar.gz | |
Merge bk@192.168.21.1:mysql-5.1-opt
into mysql.com:/home/hf/work/27984/my51-27984
mysql-test/r/type_newdecimal.result:
merging
mysql-test/t/type_newdecimal.test:
merging
Diffstat (limited to 'mysql-test/r/type_newdecimal.result')
| -rw-r--r-- | mysql-test/r/type_newdecimal.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/type_newdecimal.result b/mysql-test/r/type_newdecimal.result index 759116684dd..fc6955f11d2 100644 --- a/mysql-test/r/type_newdecimal.result +++ b/mysql-test/r/type_newdecimal.result @@ -1478,6 +1478,9 @@ Error 1264 Out of range value for column 'cast(a as DECIMAL(3,2))' at row 1 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 select cast(143.481 as decimal(4,1)); cast(143.481 as decimal(4,1)) |