Bug #28439 date_formats test case fails with binlog disabled

• Submitted: 15 May 2007 8:57
• Modified: 11 Jun 2007 13:47
• Reporter: Daniel Fischer
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• Assigned to: Daniel Fischer
• CPU Architecture: Any

[15 May 2007 8:57] Daniel Fischer

Description:
The date_formats test case fails if binlog is diasbled:

date_formats                   [ fail ]

Errors are (from /dev/shm/var-n_none-132/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/date_formats.result	2007-05-14 19:31:05.000000000 +0300
--- r/date_formats.reject	2007-05-14 20:03:18.000000000 +0300
***************
*** 1,14 ****
  drop table if exists t1;
  SHOW GLOBAL VARIABLES LIKE "%_format%";
  Variable_name	Value
! binlog_format	<format>
  date_format	%d.%m.%Y
  datetime_format	%Y-%m-%d %H:%i:%s
  default_week_format	0
  time_format	%H.%i.%s
  SHOW SESSION VARIABLES LIKE "%_format%";
  Variable_name	Value
! binlog_format	<format>
  date_format	%d.%m.%Y
  datetime_format	%Y-%m-%d %H:%i:%s
  default_week_format	0
--- 1,14 ----
  drop table if exists t1;
  SHOW GLOBAL VARIABLES LIKE "%_format%";
  Variable_name	Value
! binlog_format	
  date_format	%d.%m.%Y
  datetime_format	%Y-%m-%d %H:%i:%s
  default_week_format	0
  time_format	%H.%i.%s
  SHOW SESSION VARIABLES LIKE "%_format%";
  Variable_name	Value
! binlog_format	
  date_format	%d.%m.%Y
  datetime_format	%Y-%m-%d %H:%i:%s
  default_week_format	0
***************
*** 32,38 ****
  set datetime_format= '%h:%i:%s.%f %p %Y-%m-%d';
  SHOW SESSION VARIABLES LIKE "%format";
  Variable_name	Value
! binlog_format	<format>
  date_format	%m-%d-%Y
  datetime_format	%h:%i:%s.%f %p %Y-%m-%d
  default_week_format	0
--- 32,38 ----
  set datetime_format= '%h:%i:%s.%f %p %Y-%m-%d';
  SHOW SESSION VARIABLES LIKE "%format";
  Variable_name	Value
! binlog_format	
  date_format	%m-%d-%Y
  datetime_format	%h:%i:%s.%f %p %Y-%m-%d
  default_week_format	0
-------------------------------------------------------

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

Suggested fix:
Don't select the binlog_format variable, since this is a test case for date formats.

[15 May 2007 9:00] Bugs System

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/26675

ChangeSet@1.2517, 2007-05-15 10:56:39+02:00, [e-mail] +2 -0
  BUG#28439 date_formats test case fails with binlog disabled

[29 May 2007 14:53] Joerg Bruehe

From me: ok to push.

[30 May 2007 16:11] Daniel Fischer

Queued for inclusion in 5.1.

[11 Jun 2007 11:39] Bugs System

Pushed into 5.1.20-beta

[11 Jun 2007 13:47] Paul DuBois

Test suite change. No changelog entry needed.