Bug #28580 Repeatation of status variables
Submitted: 22 May 2007 7:44 Modified: 18 Jun 2007 16:52
Reporter: Sabyasachi Ruj Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.18-beta-community-nt-debug OS:Any
Assigned to: Sergey Glukhov
Tags: staus variables

[22 May 2007 7:44] Sabyasachi Ruj
Description:
In MySQL server version '5.1.18-beta-community-nt-debug', if I execute the following query:-

SHOW GLOBAL VARIABLES;

I can find at least two 'Variable_name's are repeated in the retruned result set.

They are:-
1. table_definition_cache
2. table_lock_wait_timeout

How to repeat:
1. Install '5.1.18-beta-community-nt-debug' (I am using WinXP as my host).
2. Execute the query: SHOW GLOBAL VARIABLES;
3. Go through the result set and you can see 'table_definition_cache' and 'table_lock_wait_timeout' are repeated.
[22 May 2007 8:33] Sveta Smirnova
Thank you for the report.

Verified as described.
[29 May 2007 7:40] Bugs System
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/27533

ChangeSet@1.2513, 2007-05-29 12:37:43+05:00, gluh@mysql.com +3 -0
  Bug#28580 Repeatation of status variables
  removed duplicated variable declarations
[6 Jun 2007 11:04] Bugs System
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/28186

ChangeSet@1.2549, 2007-06-06 15:59:20+05:00, gluh@mysql.com +3 -0
  Bug#28580 Repeatation of status variables
  removed duplicated variable declarations
[14 Jun 2007 19:01] Bugs System
Pushed into 5.1.20-beta
[18 Jun 2007 16:52] Paul Dubois
Noted in 5.1.20 changelog.

SHOW GLOBAL VARIABLES repeated some variable names.