Bug #7251 "myisam" test fails in current 5.0 tree
Submitted: 14 Dec 2004 7:27 Modified: 16 Jan 2005 4:07
Reporter: Lenz Grimmer Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-pre OS:Linux (Linux/PPC)
Assigned to: Igor Babaev CPU Architecture:Any

[14 Dec 2004 7:27] Lenz Grimmer 
Description:
The "myisam" test fails for me in the myisam test on Linux/PPC:

Last ChangeSet:

ChangeSet@1.1735, 2004-12-13 23:28:24+02:00, anjuta@arthur.local
  Added missing errmsg.txt

The diff:

myisam                         [ fail ]

Errors are (from /home/lenz/my/mysql-5.0-build/mysql-test/var/log/mysqltest-time) :
/home/lenz/my/mysql-5.0-build/client/.libs/mysqltest: At line 542: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/myisam.result     Wed Dec  8 14:13:21 2004
--- r/myisam.reject     Tue Dec 14 01:06:25 2004
***************
*** 716,722 ****
  *a         *a*a         *
  explain select * from t1 where v='a';
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      ref     v,v_2   v_2     13      const   7       Using where
  select v,count(*) from t1 group by v limit 10;
  v     count(*)
  a     1
--- 716,722 ----
  *a         *a*a         *
  explain select * from t1 where v='a';
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      ref     v,v_2   v       13      const   7       Using where
  select v,count(*) from t1 group by v limit 10;
  v     count(*)
  a     1
-------------------------------------------------------

How to repeat:
Run the "myisam" test on a recent 5.0 tree, observe the diff above.
[16 Jan 2005 4:07] Igor Babaev 
On Mon, 3 Jan 2005, Igor Babaev wrote:

> I tried to reproduce bug #7251 assigned to me by running mysql-test-run 
> myisam on my Linux/Dell Dimension machine and failed - the test passed.
> In verification notes you mentioned Linux/PPC. What is it PPC? PowerPC?

Yes, this is Linux/PPC. I just tried to reproduce it again, but failed. It 
seems like it's fixed in the meanwhile, you can disregard that bug report. 
Thanks!

> Please clarify how I could reproduce the problem if it still exists.

Seems like it resolved itself :)

Bye,
LenZ