Bug #411 The TZ environment variable is cleared on Windows Servers
Submitted: 9 May 2003 14:29 Modified: 27 Sep 2008 8:00
Reporter: Miguel Solorzano Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:All OS:Any (All Windows)
Assigned to: CPU Architecture:Any

[9 May 2003 14:29] Miguel Solorzano
Due the code above the TZ variable doesn't works on Windows servers.

static void my_win_init(void)
 /* Clear the OS system variable TZ and avoid the 100% CPU usage */
 _putenv( "TZ=" ); 

The introduction of the above code is for a C run-time library bug.

How to repeat:
Set the variable TZ for any value and it won't effect.

Suggested fix:
Open for disccusion.
[3 Jun 2003 7:38] Thomas Studer
More than just that. The --timezone=# variable is not even recognized. Neither in the .ini file nor as a command line variable.
[12 Feb 2004 22:31] Todd Buiten
Any thoughts on when this might get fixed?  We do quite a bit of cross-platform development and we run our production servers in GMT.  Any time we have to try to repro a bug in Windows with data from our Linux machines then our times are all off by eight hours (PST).


- todd
[27 Sep 2008 7:59] Konstantin Osipov
Looking at 5.1 code base, it's been fixed by adding an #ifdef:

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