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:	None
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
Tags:	qc, TIME ZIC DATE TIME

Description:
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?

i couldn't restart server to check if will work right with the new timezone

Thank you for the report.

I believe this is same problem as described in bug #9518. So I mark this report as "duplicate"

that's right, a duplicate bug
couldn't resolve? since 31 Mar 2005 12:39 it's a bug?!
thanks guys :)

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.