Bug #20759 federated.test fails when used with non-standard ports
Submitted: 28 Jun 2006 19:05 Modified: 29 Jun 2006 10:03
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S1 (Critical)
Version:5.0-engines OS:Linux (Linux)
Assigned to: Kristian Nielsen CPU Architecture:Any

[28 Jun 2006 19:05] Ingo Strüwing
Description:
federated                      [ fail ]
  
Errors are (from /home/mytest/mysql-5.0-engines/tmp/test1/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/federated.result  2006-06-28 19:55:50.000000000 +0300
--- r/federated.reject  2006-06-28 20:47:38.000000000 +0300
***************
*** 1605,1612 ****
  DROP TABLE federated.bug_17377_table;
  create table federated.t1 (i1 int, i2 int, i3 int);
  create table federated.t2 (id int, c1 varchar(20), c2 varchar(20));
! create table federated.t1 (i1 int, i2 int, i3 int) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:9308/federated/t1';
! create table federated.t2 (id int, c1 varchar(20), c2 varchar(20)) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:9308/federated/t2';
  insert into federated.t1 values (1,5,10),(3,7,12),(4,5,2),(9,10,15),(2,2,2);
  insert into federated.t2 values (9,"abc","def"),(5,"opq","lmn"),(2,"test t","t test");
  select * from federated.t1 order by i1;
--- 1605,1612 ----  
  DROP TABLE federated.bug_17377_table;
  create table federated.t1 (i1 int, i2 int, i3 int);
  create table federated.t2 (id int, c1 varchar(20), c2 varchar(20));
! create table federated.t1 (i1 int, i2 int, i3 int) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:10243/federated/t1';
! create table federated.t2 (id int, c1 varchar(20), c2 varchar(20)) ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:10243/federated/t2'; 
  insert into federated.t1 values (1,5,10),(3,7,12),(4,5,2),(9,10,15),(2,2,2);
  insert into federated.t2 values (9,"abc","def"),(5,"opq","lmn"),(2,"test t","t test");
  select * from federated.t1 order by i1;
***************

How to repeat:
BUILD/compile-pentium-debug-max
cd mysql-test
MTR_BUILD_THREAD=24
export MTR_BUILD_THREAD
./mysql-test-run federated

Suggested fix:
--replace_result $SLAVE_MYPORT SLAVE_PORT
in front of each statement that uses the slave port.
[29 Jun 2006 10:03] Kristian Nielsen
Fixed in mysql-5.0.24, pushed to mysql-5.0.

Test suite problem only, no documentation needed.