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.