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.