MySQL Bugs: #12018: test mysqlbinlog2 fails on windows due to TZ offset

Bug #12018	test mysqlbinlog2 fails on windows due to TZ offset
Submitted:	18 Jul 2005 19:18	Modified:	30 Nov 2005 17:53
Reporter:	Elliot Murphy	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	5.0.10-pre	OS:	Windows (Windows)
Assigned to:	Kent Boortz	CPU Architecture:	Any

Description:
The test 'mysqlbinlog2' fails due to improperly calculated local time. After some investigation, it appears that the steps taken by mysql_test_run.pl to set the timezone don't work on Windows.

How to repeat:
Build MySQL on Windows (I used VC6). Run perl 'mysql_test_run.pl mysqlbinlog2' from cygwin. You can use the debugger to break on convert_str_to_timestamp to see that the results are different than expected.

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

There was a work around for a library bug using VisualStudio 6,
initiating the server TZ was set to the empty string in "my_init.c"

  #if defined(_MSC_VER) && (_MSC_VER < 1300)
    /*                                                                                                                     
      Clear the OS system variable TZ and avoid the 100% CPU usage                                                         
      Only for old versions of Visual C++                                                                                  
    */
    _putenv( "TZ=" );
  #endif

We are now compiling with Visual Studio .Net 2003, and this
code will not be enabled. The test case passes.

No changelog entry needed.