Bug #27340 mix_innodb_myisam_binlog test fails
Submitted: 21 Mar 2007 15:56 Modified: 24 Mar 2007 0:09
Reporter: Doug Gilbert Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:Ver 8.41 Distrib 5.0.27 OS:Solaris (Solaris 8 SPARC)
Assigned to: CPU Architecture:Any

[21 Mar 2007 15:56] Doug Gilbert
Description:
After initial package install (sunfreeware binaries) mysql-test-run.pl shows results are the complement of expected:

mix_innodb_myisam_binlog       [ fail ]

Errors are (from /opt/local/mysql/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/mix_innodb_myisam_binlog.result   Wed Jan  3 15:20:44 2007
--- r/mix_innodb_myisam_binlog.reject   Wed Mar 21 17:54:28 2007
***************
*** 273,282 ****
  is not null;
  (@a:=load_file("MYSQLTEST_VARDIR/tmp/mix_innodb_myisam_binlog.output"))
  is not null
! 1
  select
  @a like "%#%error_code=0%ROLLBACK;%ROLLBACK /* added by mysqlbinlog */;%",
  @a not like "%#%error_code=%error_code=%";
  @a like "%#%error_code=0%ROLLBACK;%ROLLBACK /* added by mysqlbinlog */;%"    @ a not like "%#%error_code=%error_code=%"
! 1     1
  drop table t1, t2;
--- 273,282 ----
  is not null;
  (@a:=load_file("MYSQLTEST_VARDIR/tmp/mix_innodb_myisam_binlog.output"))
  is not null
! 0
  select
  @a like "%#%error_code=0%ROLLBACK;%ROLLBACK /* added by mysqlbinlog */;%",
  @a not like "%#%error_code=%error_code=%";
  @a like "%#%error_code=0%ROLLBACK;%ROLLBACK /* added by mysqlbinlog */;%"    @ a not like "%#%error_code=%error_code=%"
! NULL  NULL
  drop table t1, t2;
-------------------------------------------------------

How to repeat:
run mysql-test-run.pl as non-root or root user
[21 Mar 2007 19:19] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.37, and inform about the results.
[23 Mar 2007 13:18] Doug Gilbert
Version 5.0.37 Community does not fail this test.
[24 Mar 2007 0:09] Valeriy Kravchuk
So, the bug is not repeatable with a newer version, 5.0.37.