Bug #40271 SAVE TIME wrong displayed on system variables
Submitted: 23 Oct 2008 2:19 Modified: 24 Oct 2008 2:39
Reporter: Roberto Spadim (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.45, 4.1, 5.0, 5.1, 6.0 bzr OS:Linux
Assigned to: CPU Architecture:Any

[23 Oct 2008 2:19] Roberto Spadim
show variables like 'system_time_zone'
return: BRT

[root@raja1 Brazil]# date
Qui Out 23 00:10:50 BRST 2008

see that right should be BRST

the database didn't turned off since 21 days (before BRST)

How to repeat:
run database before BRST (BRT)
wait the new time
check variable system_time_zone, should be BRST

Suggested fix:
maybe a variable update should be executed?
[23 Oct 2008 2:19] Roberto Spadim
i couldn't restart server to check if will work right with the new timezone
[23 Oct 2008 5:52] Sveta Smirnova
Thank you for the report.

I believe this is same problem as described in bug #9518. So I mark this report as "duplicate"
[24 Oct 2008 2:39] Roberto Spadim
that's right, a duplicate bug
couldn't resolve? since 31 Mar 2005 12:39 it's a bug?!
thanks guys :)