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 21:18	Modified:	30 Nov 2005 18:53
Reporter:	Elliot Murphy
Status:	Closed
Category:	Server: Replication	Severity:	S2 (Serious)
Version:	5.0.10-pre	OS:	Microsoft Windows (Windows)
Assigned to:	Kent Boortz	Target Version:

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.