Bug #7956 Test failure: 'strict' ('Illegal double' not reported)
Submitted: 17 Jan 2005 14:52 Modified: 20 Jan 2005 10:15
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-pre OS:Unix (several)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[17 Jan 2005 14:52] Joerg Bruehe
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.
[20 Jan 2005 10:15] Ramil Kalimullin
fixed in 5.0.3