Description:
This is different from bug#7275 (recently closed).
This is happening in a release build (attempt) based on changeset
ChangeSet
1.1771 05/01/13 15:10:12 lenz@mysql.com +1 -0
- keep 5.0.3-alpha version string (after-merge fix)
The test suite fails on some machines with this symptom:
-------------------------------------------------------
*** r/strict.result Thu Jan 13 21:08:43 2005
--- r/strict.reject Sat Jan 15 01:59:23 2005
***************
*** 768,774 ****
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
INSERT INTO t1 (col2) VALUES (-1.1E-3);
ERROR 22003: Out of range value adjusted for column 'col2' at row 1
INSERT INTO t1 (col1) VALUES ('+1.8E+309');
--- 768,774 ----
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 22003: Out of range value adjusted for column 'col1' at row 1
INSERT INTO t1 (col2) VALUES (-1.1E-3);
ERROR 22003: Out of range value adjusted for column 'col2' at row 1
INSERT INTO t1 (col1) VALUES ('+1.8E+309');
***************
*** 794,805 ****
Warnings:
Error 1365 Division by 0
INSERT IGNORE INTO t1 VALUES (+1.9E+309,-1.9E+309);
- ERROR 22007: Illegal double '1.9E+309' value found during parsing
INSERT IGNORE INTO t1 VALUES ('+2.0E+309','-2.0E+309');
Warnings:
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
- Warning 1264 Out of range value adjusted for column 'col2' at row 1
SELECT * FROM t1;
col1 col2
-2.2e-307 0
--- 794,803 ----
***************
*** 810,815 ****
--- 808,814 ----
2 NULL
NULL NULL
1.79769313486232e+308 0
+ 1.79769313486232e+308 0
DROP TABLE t1;
CREATE TABLE t1 (col1 CHAR(5), col2 VARCHAR(6));
INSERT INTO t1 VALUES ('hello', 'hello'),('he', 'he'),('hello ', 'hello ');
-------------------------------------------------------
This happens on butch (both 32 and 64 bit), intelxeon3, sunfire100b (32 + 64), and sunfire100c (32 + 64). It passes on all other platforms (which built successfully). There is no difference by product (table handlers included etc.).
How to repeat:
Build + test on these platforms.
