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/t/strict.test | |
| 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/t/strict.test')
| -rw-r--r-- | mysql-test/t/strict.test | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/t/strict.test b/mysql-test/t/strict.test index d9f4f4f2d0c..4f7c0cfc541 100644 --- a/mysql-test/t/strict.test +++ b/mysql-test/t/strict.test @@ -493,8 +493,8 @@ DROP TABLE t1; # Test INSERT with FLOAT 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'); # We don't give warnings for underflow INSERT INTO t1 (col1) VALUES (3E-46); --error 1264 @@ -527,8 +527,8 @@ DROP TABLE t1; # Test INSERT with DOUBLE 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'); # We don't give warnings for underflow INSERT INTO t1 (col1) VALUES (-2.2E-330); --error 1367 |