Bug #59492 SET time_zone not work in mysql proxy
Submitted: 14 Jan 2011 4:25 Modified: 17 Feb 2011 19:59
Reporter: Tommy Ho Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Proxy Severity:S2 (Serious)
Version:all OS:Linux
Assigned to: CPU Architecture:Any
Tags: mysql proxy, time_zone

[14 Jan 2011 4:25] Tommy Ho 
Description:
SET time_zone seems not work in MySQL Proxy:

SET time_zone = "Asia/Hong_Kong";
SELECT NOW();

result:
2011-01-14 04:24:43

SET time_zone = "Europe/London";
SELECT NOW();

result:
2011-01-14 04:24:43

How to repeat:
SET time_zone = "Asia/Hong_Kong";
SELECT NOW();

SET time_zone = "Europe/London";
SELECT NOW();
[17 Jan 2011 19:59] Sveta Smirnova 
Thank you for the report.

I can not repeat described behavior. Please provide options you start mysql-proxy with.
[18 Feb 2011 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".