Description:
current 5.0 tree, compiled with compile-pentium-debug-max, tip cset
federated.test fails with these differences:
Errors are (from /home/psergey/mysql-5.0-look3/mysql-test/var/log/mysqltest-time) :
/home/psergey/mysql-5.0-look3/client/.libs/mysqltest: At line 506: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/federated.result Thu Jan 20 09:29:57 2005
--- r/federated.reject Thu Jan 20 11:59:34 2005
***************
*** 38,44 ****
5 Fifth Name 55555 2004-04-04 04:04:04
select * from federated.t1 where name = 'Sixth Name';
id name other created
- 6 Sixth Name 66666 2004-04-04 04:04:04
select * from federated.t1 where id = 6 and name = 'Sixth Name';
id name other created
6 Sixth Name 66666 2004-04-04 04:04:04
--- 38,43 ----
***************
*** 58,68 ****
update federated.t1 set name = '3rd name' where id = 3;
select * from federated.t1 where name = '3rd name';
id name other created
- 3 3rd name 33333 2004-04-04 04:04:04
update federated.t1 set name = 'Third name' where name = '3rd name';
select * from federated.t1 where name = 'Third name';
id name other created
- 3 Third name 33333 2004-04-04 04:04:04
select * from federated.t1 order by id DESC;
id name other created
10 Tenth Name 101010 2004-04-04 04:04:04
--- 57,65 ----
***************
*** 72,82 ****
6 Sixth Name 66666 2004-04-04 04:04:04
5 Fifth Name 55555 2004-04-04 04:04:04
4 Fourth Name 44444 2004-04-04 04:04:04
! 3 Third name 33333 2004-04-04 04:04:04
2 Second Name 22222 2004-04-04 04:04:04
1 First Name 11111 2004-04-04 04:04:04
select * from federated.t1 order by name;
id name other created
8 Eigth Name 88888 2004-04-04 04:04:04
5 Fifth Name 55555 2004-04-04 04:04:04
1 First Name 11111 2004-04-04 04:04:04
--- 69,80 ----
6 Sixth Name 66666 2004-04-04 04:04:04
5 Fifth Name 55555 2004-04-04 04:04:04
4 Fourth Name 44444 2004-04-04 04:04:04
! 3 3rd name 33333 2004-04-04 04:04:04
2 Second Name 22222 2004-04-04 04:04:04
1 First Name 11111 2004-04-04 04:04:04
select * from federated.t1 order by name;
id name other created
+ 3 3rd name 33333 2004-04-04 04:04:04
8 Eigth Name 88888 2004-04-04 04:04:04
5 Fifth Name 55555 2004-04-04 04:04:04
1 First Name 11111 2004-04-04 04:04:04
***************
Also the following warnings are produced:
Warning: Not freed memory segments: 52
Warning: Memory that was not free'ed (132637 bytes):
How to repeat:
see above