MySQL Bugs: #28373: mysqltest test case fails with binlog disabled

Bug #28373	mysqltest test case fails with binlog disabled
Submitted:	11 May 2007 9:00	Modified:	11 Jun 2007 13:49
Reporter:	Daniel Fischer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Magnus Blåudd	CPU Architecture:	Any

Description:
The test case mysqltest fails when binlog is disabled.

mysqltest                      [ fail ]

Errors are (from /shared/home/df/mysql/build/mysql-5.0/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/mysqltest.result	Fri Apr 27 09:23:17 2007
--- r/mysqltest.reject	Fri May 11 11:54:35 2007
***************
*** 409,417 ****
  mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a b'
  mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a 1'
  mysqltest: At line 1: Wrong column number to replace_column in 'replace_column 1 b c '
! mysqltest: At line 1: Invalid integer argument "10!"
! mysqltest: At line 1: End of line junk detected: "!"
! mysqltest: At line 1: Invalid integer argument "a"
  mysqltest: At line 1: Missing required argument 'connection name' to command 'connect'
  mysqltest: At line 1: Missing required argument 'connection name' to command 'connect'
  mysqltest: At line 1: Missing required argument 'host' to command 'connect'
--- 409,417 ----
  mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a b'
  mysqltest: At line 1: Wrong column number to replace_column in 'replace_column a 1'
  mysqltest: At line 1: Wrong column number to replace_column in 'replace_column 1 b c '
! mysqltest: At line 1: empty result in show master status
! mysqltest: At line 1: empty result in show master status
! mysqltest: At line 1: empty result in show master status
  mysqltest: At line 1: Missing required argument 'connection name' to command 'connect'
  mysqltest: At line 1: Missing required argument 'connection name' to command 'connect'
  mysqltest: At line 1: Missing required argument 'host' to command 'connect'
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Result from queries before failure can be found in r/mysqltest.log

How to repeat:
perl mtr --mysqld=--skip-log-bin mysqltest

Thank you for the report.

Verified as described.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/27816

ChangeSet@1.2506, 2007-05-31 15:58:22+02:00, msvensson@pilot.(none) +2 -0
  Bug#28373 mysqltest test case fails with binlog disabled
   - Update tests to be independent how the mysqld was started

Pushed into 5.1.20-beta

Pushed into 5.0.44

Test suite change. No changelog entry needed.