Bug #35517 Foreign keys: no @@foreign_key_all_engines
Submitted: 24 Mar 2008 17:22 Modified: 20 Apr 2008 13:41
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:6.1.0-fk-debug OS:Linux (SUSE 10 | 32-bit)
Assigned to: Dmitry Lenev CPU Architecture:Any

[24 Mar 2008 17:22] Peter Gulutzan
Description:
I'm using mysql-6.1-fk.
I start mysqld with --foreign-key-all-engines=1.

I can start mysqld with --foreign-key-all-engines=1.
But I cannot see the value.
There should be a variable @@foreign_key_all_engines.

How to repeat:
mysql> select @@foreign_key_all_engines;
ERROR 1193 (HY000): Unknown system variable 'foreign_key_all_engines'
[24 Mar 2008 22:13] MySQL Verification Team
Thank you for the bug report.

mysql> select @@foreign_key_all_engines;
ERROR 1193 (HY000): Unknown system variable 'foreign_key_all_engines'
mysql>
[18 Apr 2008 20:55] 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/45642

ChangeSet@1.2607, 2008-04-19 00:55:06+04:00, dlenev@mockturtle.local +5 -0
  Fix for bug #35517 "Foreign keys: no @@foreign_key_all_engines".
  
  Value specified via --foreign_key_all_engines option was not
  available through SHOW VARIABLES statement, I_S.GLOBAL_VARIABLES
  and @@foreign_key_all_engines syntax.
  
  Publish this value as global read-only variable.
[20 Apr 2008 13:41] Dmitry Lenev
Fix for this bug was pushed into 6.1-fk tree. Since this tree is not publicly available yet I am simply closing this bug.