Bug #12792 @@system_time_zone is not SELECTable.
Submitted: 25 Aug 2005 1:42 Modified: 2 May 2006 1:19
Reporter: Lachlan Mulcahy Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.11 OS:
Assigned to: Jim Winstead CPU Architecture:Any
Triage: D5 (Feature request)

[25 Aug 2005 1:42] Lachlan Mulcahy
Description:
system_time_zone can not be SELECTed like other variables in SHOW VARIABLES output.

How to repeat:
SELECT @@system_time_zone;

Suggested fix:
Make it SELECTable.
[20 Dec 2005 11:05] Carsten Segieth
similar (but other variables touched) to http://bugs.mysql.com/bug.php?id=15684
[21 Apr 2006 4:58] Jim Winstead
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/5247
[1 May 2006 16:04] Jim Winstead
Fixed in 5.0.22 and 5.1.10.
[2 May 2006 1:19] Paul Dubois
Noted in 5.0.22, 5.1.10 changelogs.

The <literal>system_time_zone</literal> and
<literal>version_*</literal> system variables could not be
accessed via <literal>SELECT
@@<replaceable>var_name</replaceable></literal> syntax. (Bug
#12792, Bug #15684)
[17 Jul 2006 19:47] Walt Nimylowycz
I tested in 5.0.22 and am still receiving the error.
[17 Jul 2006 20:09] Paul Dubois
Sorry, the 5.0.x fix actually ended up going to 5.0.23.