Bug #7587 bdb.test fails in tree compiled with compile-pentium-max
Submitted: 30 Dec 2004 11:18 Modified: 31 Dec 2004 13:04
Reporter: Sergey Petrunya Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0-bk OS:Linux (linux)
Assigned to: Sergei Golubchik CPU Architecture:Any

[30 Dec 2004 11:18] Sergey Petrunya
Description:
bdb.test fails in current 5.0 tree compiled with compile-pentim-max. The failures are different on different systems. 
The test passes when the tree is compiled with compile-pentium-debug-max.
Last changeset in tree: ChangeSet@1.1760, 2004-12-29 23:22:25+02:00, marko@hundin.mysql.fi
===== Test failure type1 (observed on "build") ========
*** r/bdb.result        Fri Dec 24 00:37:52 2004
--- r/bdb.reject        Thu Dec 30 13:34:36 2004
***************
*** 140,152 ****
  1015  102     2
  explain select level from t1 where level=1;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      ref     level   level   1       const   6       Using index
  explain select level,id from t1 where level=1;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      ref     level   level   1       const   6       Using index
  explain select level,id,parent_id from t1 where level=1;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      ref     level   level   1       const   6
  select level,id from t1 where level=1;
  level id
  1     1002
--- 140,152 ----
  1015  102     2
  explain select level from t1 where level=1;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      ref     level   level   1       const   5       Using index
  explain select level,id from t1 where level=1;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      ref     level   level   1       const   5       Using index
  explain select level,id,parent_id from t1 where level=1;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      ref     level   level   1       const   5
  select level,id from t1 where level=1;
  level id
  1     1002
***************
....and so on, many explain (and only explains) result differences ....
======= Test failure type 2 ========
/home/psergey/mysql-5.0/client/mysqltest: At line 296: query 'replace into t1 (ggid,passwd) values ('test2','this will work')' failed: 1032: Can't find record in 't1'
(the last lines may be the most important ones)
Ending Tests
Shutting-down MySQL daemon

How to repeat:
Compile 5.0 with compile-pentium-max and run the test.
[30 Dec 2004 11:56] Joerg Bruehe
The second part was already reported on Dec 14 as bug#7260 which is still un-assigned in state 'verified' ...