Bug #30837 Variables are listed twice by SHOW VARIABLES.

• Submitted: 5 Sep 2007 15:57
• Modified: 14 Sep 2007 12:32
• Reporter: Santo Leto
• Status: Can't repeat
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: 6.0.2-alpha
• OS: Windows (XPSP2)
• CPU Architecture: Any
• Tags: dynamic system variables, table_definition_cache, table_lock_wait_timeout

[5 Sep 2007 15:57] Santo Leto

Description:
Variables table_definition_cache and table_lock_wait_timeout are listed twice by SHOW VARIABLES.

How to repeat:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 6.0.2-alpha-community-nt-debug-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like 'table_definition_cache';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| table_definition_cache | 128   |
| table_definition_cache | 128   |
+------------------------+-------+
2 rows in set (0.00 sec)

mysql> show variables like 'table_lock_wait_timeout';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| table_lock_wait_timeout | 50    |
| table_lock_wait_timeout | 50    |
+-------------------------+-------+
2 rows in set (0.00 sec)

mysql>

[6 Sep 2007 5:35] Valeriy Kravchuk

Thank you for a bug report. Verified just as described:

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uroot -proot test -P3311
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 6.0.2-alpha-community-nt-debug MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like 'table_%';
+-------------------------+--------+
| Variable_name           | Value  |
+-------------------------+--------+
| table_definition_cache  | 128    |
| table_definition_cache  | 128    |
| table_lock_wait_timeout | 50     |
| table_lock_wait_timeout | 50     |
| table_open_cache        | 256    |
| table_type              | InnoDB |
+-------------------------+--------+
6 rows in set (0.01 sec)

[9 Sep 2007 15:07] Peter Laursen

Was also reported for 5.1.18

http://bugs.mysql.com/bug.php?id=28580

[14 Sep 2007 12:32] Hakan Küçükyılmaz

This was fixed in latest Falcon 6.0.3-alpha-debug

[14:29] root@test>show variables like 'table_%';
+-------------------------+--------+
| Variable_name           | Value  |
+-------------------------+--------+
| table_definition_cache  | 128    |
| table_lock_wait_timeout | 50     |
| table_open_cache        | 1024   |
| table_type              | Falcon |
+-------------------------+--------+
4 rows in set (0.00 sec)