diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-11-26 14:02:39 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-11-26 14:02:39 +0400 |
| commit | 31e9caa05c9da4d8e7d43428aca747c7cf965502 (patch) | |
| tree | 8be657b6d7e05b82c54b25e9a8cedfb2f76247c7 /mysql-test/r/strict.result | |
| parent | 036a61c2416c0f3b52d5388950552862ee3488a3 (diff) | |
| download | mariadb-git-31e9caa05c9da4d8e7d43428aca747c7cf965502.tar.gz | |
Portability fix: we had problems with -1.1E-38, -2.2E-308 values
on 64-bit platforms (due to compiler's optimization).
-1.1E-38 replaced with -1.1E-37
-2.2E-308 replaced with -2.2E-307
Diffstat (limited to 'mysql-test/r/strict.result')
| -rw-r--r-- | mysql-test/r/strict.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result index 19c4def9b32..b7c5ac38b76 100644 --- a/mysql-test/r/strict.result +++ b/mysql-test/r/strict.result @@ -713,8 +713,8 @@ NULL -99.99 DROP TABLE t1; CREATE TABLE t1 (col1 FLOAT, col2 FLOAT UNSIGNED); -INSERT INTO t1 VALUES (-1.1E-38,0),(+3.4E+38,+3.4E+38); -INSERT INTO t1 VALUES ('-1.1E-38',0),('+3.4E+38','+3.4E+38'); +INSERT INTO t1 VALUES (-1.1E-37,0),(+3.4E+38,+3.4E+38); +INSERT INTO t1 VALUES ('-1.1E-37',0),('+3.4E+38','+3.4E+38'); INSERT INTO t1 (col1) VALUES (3E-46); INSERT INTO t1 (col1) VALUES (+3.4E+39); ERROR 22003: Out of range value adjusted for column 'col1' at row 1 @@ -752,9 +752,9 @@ Warning 1264 Out of range value adjusted for column 'col1' at row 1 Warning 1264 Out of range value adjusted for column 'col2' at row 1 SELECT * FROM t1; col1 col2 --1.1e-38 0 +-1.1e-37 0 3.4e+38 3.4e+38 --1.1e-38 0 +-1.1e-37 0 3.4e+38 3.4e+38 0 NULL 2 NULL @@ -763,8 +763,8 @@ NULL NULL 3.40282e+38 0 DROP TABLE t1; CREATE TABLE t1 (col1 DOUBLE PRECISION, col2 DOUBLE PRECISION UNSIGNED); -INSERT INTO t1 VALUES (-2.2E-308,0),(+1.7E+308,+1.7E+308); -INSERT INTO t1 VALUES ('-2.2E-308',0),('+1.7E+308','+1.7E+308'); +INSERT INTO t1 VALUES (-2.2E-307,0),(+1.7E+308,+1.7E+308); +INSERT INTO t1 VALUES ('-2.2E-307',0),('+1.7E+308','+1.7E+308'); INSERT INTO t1 (col1) VALUES (-2.2E-330); INSERT INTO t1 (col1) VALUES (+1.7E+309); ERROR 22007: Illegal double '1.7E+309' value found during parsing @@ -801,9 +801,9 @@ Warning 1264 Out of range value adjusted for column 'col2' at row 1 Warning 1264 Out of range value adjusted for column 'col2' at row 1 SELECT * FROM t1; col1 col2 --2.2e-308 0 +-2.2e-307 0 1.7e+308 1.7e+308 --2.2e-308 0 +-2.2e-307 0 1.7e+308 1.7e+308 0 NULL 2 NULL |