Bug #43672 Test main.myisamlog fails when run with option --no-check-testcases

• Submitted: 16 Mar 2009 10:40
• Modified: 8 Apr 2009 18:39
• Reporter: Øystein Grøvlen
• Status: Duplicate
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 6.0 bzr, 5.1
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[16 Mar 2009 10:40] Øystein Grøvlen

Description:
If I run test main.myisamlog with option --no-check-testcases, I get the following
result diff:

--- /home/oysteing/mysql/mysql-6.0-wl4760/mysql-test/r/myisamlog.result	2009-03-16 12:53:03.000000000 +0300
+++ /home/oysteing/mysql/mysql-6.0-wl4760/mysql-test/r/myisamlog.reject	2009-03-16 13:29:38.000000000 +0300
@@ -14,13 +14,13 @@
 truncate table t1;
 flush table t1;
 Commands                         Used count    Errors Recover errors
-open                       26         0              0
+open                       16         0              0
 write                       4         0              0
 update                      1         0              0
 delete                      1         0              0
 close                       8         0              0
 extra                       #         0              0
-lock                       82         0              0
+lock                       48         0              0
 Total               #         0                0
 select * from t1;
 a	b
@@ -29,13 +29,13 @@
 Tables updated successfully
 
 Commands                         Used count    Errors Recover errors
-open                       27         0              0
+open                       17         0              0
 write                       4         0              0
 update                      1         0              0
 delete                      1         0              0
 close                       9         0              0
 extra                       #         0              0
-lock                       84         0              0
+lock                       50         0              0
 Total               #         0                0
 select * from t1;
 a	b

mysqltest: Result content mismatch

How to repeat:
./mtr --no-check-testcases myisamlog

Suggested fix:
It seems the counts presented includes the run of check-testcases.
This should be filtered out somehow.

[16 Mar 2009 10:46] Sveta Smirnova

Thank you for the report.

Verified as described.

[8 Apr 2009 18:39] Patrick Crews

The bug as described was fixed as part of Bug#38133	Myisamlog test fails on Windows

Ingo added extra cleanup code to ensure that the test gets a fresh start before delving into the test itself.

I tried to repeat the bug on both Mac OSX and Windows XP 32bit without success.  I did this as part of the full test suite as well as running the test by itself.