Bug #8033 federated.test fails + produces memory warnings
Submitted: 20 Jan 2005 9:21 Modified: 2 Apr 2005 0:47
Reporter: Sergey Petrunya Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0-bk OS:Linux (linux x86)
Assigned to: Bugs System CPU Architecture:Any

[20 Jan 2005 9:21] Sergey Petrunya
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
[17 Feb 2005 18:20] Patrick Galbraith
changeset 1.1856 fixes this, waiting for second review.
[2 Apr 2005 0:47] Patrick Galbraith
fixed, in 5.0.3