system_time_zone is set wrong
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Medium
|
Vladislav Vaintroub |
Bug Description
In v5.5.23 on XP SP3, the server variable system_time _zone is set to a wrong value on server startup. Its value is "ope" (without the quotes), not a valid time zone designation.
IMHO, this is possibly derived form the string "Westeuropäische Sommerzeit" which is returned by the GetTimeZoneInfo
Note: I have an environment variable called TZ, whose current value is "CET" (without the quotes).
If I unset this variable inside a cmd.exe window, and then start mysqld.exe --console from same window, system_time _zone will be different, namely "Westeuropische Sommerzeit" (without the quotes) - note the missing "ä".
Again, this appears not to be a valid timezone name according to the mysql.time_
The correct value would probably be CET or Europe/Berlin.
Changed in maria: | |
assignee: | nobody → Vladislav Vaintroub (wlad-montyprogram) |
Changed in maria: | |
milestone: | none → 5.5 |
Changed in maria: | |
importance: | Undecided → Medium |
After some searching, the problem is most probably that the time zone name returned from the windows registry.by GetTimeZoneInfo rmation( ) is a) non-standard and b) localized. You could probably scan the subkeys of HKEY_LOCAL_ MACHINE\ SOFTWARE\ Microsoft\ Windows NT\CurrentVersi on\Time Zones until you find one whose Std or Dlt value is equal to the GetTimeZoneInfo rmation( ) result (not necessarily identical to the subkey name!). Then parse the TZI value of the same entry for the appropriate bias'es (cf http:// www.pcmag. com/article2/ 0,1895, 1166624, 00.asp for format info), and use the computed bias as +|-nn:nn.