Bug #7490 Test failure: 'index_merge' (join_buffer_size differs)
Submitted: 22 Dec 2004 16:59 Modified: 31 Dec 2004 13:05
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.3-pre OS:Linux (Linux 2.4 / Athlon)
Assigned to: Sergey Petrunya CPU Architecture:Any

[22 Dec 2004 16:59] Joerg Bruehe
Description:
Test 'index_merge' fails for me in current 5.0, both in a default and a '--ps-protocol' run.

The value of 'join_buffer_size' differs:
-------------------------------------------------------
*** r/index_merge.result	2004-12-21 12:46:54.000000000 +0300
--- r/index_merge.reject	2004-12-22 17:13:58.000000000 +0300
***************
*** 342,348 ****
  set join_buffer_size= 4000;
  show variables like 'join_buffer_size';
  Variable_name	Value
! join_buffer_size	8228
  explain select max(A.key1 + B.key1 + A.key2 + B.key2 + A.key3 + B.key3 + A.key4 + B.key4 + A.key5 + B.key5) 
  from t0 as A force index(i1,i2), t0 as B force index (i1,i2) 
  where (A.key1 < 500000 or A.key2 < 3)
--- 342,348 ----
  set join_buffer_size= 4000;
  show variables like 'join_buffer_size';
  Variable_name	Value
! join_buffer_size	8200
  explain select max(A.key1 + B.key1 + A.key2 + B.key2 + A.key3 + B.key3 + A.key4 + B.key4 + A.key5 + B.key5) 
  from t0 as A force index(i1,i2), t0 as B force index (i1,i2) 
  where (A.key1 < 500000 or A.key2 < 3)
-------------------------------------------------------

Pem had the same difference on his machine.

This is a non-debug build: 'compile-pentium-max'. My latest changesets:
=== cut ===
ChangeSet@1.1743, 2004-12-22 01:02:48+03:00, petr@mysql.com
  Merge bk-internal.mysql.com:/home/bk/mysql-5.0
  into mysql.com:/home/cps/mysql/trees/mysql-5.0

ChangeSet@1.1732.27.1, 2004-12-22 01:00:29+03:00, petr@mysql.com
  Bug #7468 Instance Manager fails to compile: thread_registry.cc
  This fix icludes workaround for Irix compiler bug & removs some unused
  variables (resulted in warnings)
=== cut ===

The test passed in a run last week (Dec 14) and failed yesterday (Dec 21), I had no runs in between.

How to repeat:
Run the test suite.