Bug #40631 Show variables like 'fo%' does not show foreign_key_checks

• Submitted: 11 Nov 2008 9:28
• Modified: 11 Nov 2008 14:14
• Reporter: Janek Bogucki
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S4 (Feature request)
• Version: 5.0.51a-3ubuntu5.3-log
• OS: Linux (Ubuntu 8.04.1)
• CPU Architecture: Any
• Tags: foreign_key_checks, MySQL, variables

[11 Nov 2008 9:28] Janek Bogucki

Description:
foreign_key_checks is not shown by `show variables like 'fo%'`

How to repeat:
mysql> set foreign_key_checks=0;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'fo%';
Empty set (0.00 sec)

mysql> select @@foreign_key_checks;
+----------------------+
| @@foreign_key_checks |
+----------------------+
|                    0 |
+----------------------+
1 row in set (0.00 sec)

[11 Nov 2008 14:14] MySQL Verification Team

Thank you for the bug report. Repeatable on 5.0 but already fixed on 5.1:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.74-debug Source distribution

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

mysql> show variables like 'fo%';
Empty set (0.36 sec)

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.31-debug Source distribution

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

mysql> set foreign_key_checks=0;
Query OK, 0 rows affected (0.38 sec)

mysql> show variables like 'fo%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| foreign_key_checks | OFF   | 
+--------------------+-------+
1 row in set (0.00 sec)