Bug #7221 information_schema: errors in "key_column_usage"

• Submitted: 13 Dec 2004 1:41
• Modified: 14 Dec 2004 10:09
• Reporter: Peter Gulutzan
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.3-alpha-debug
• OS: Linux (SUSE 9.2)
• Assigned to: Sergei Glukhov
• CPU Architecture: Any

[13 Dec 2004 1:41] Peter Gulutzan

Description:
This table has three columns (referenced_table_schema, referenced_table_name,  
referenced_column_name) which are non-standard and unnecessary.  
  

How to repeat:
mysql> select referenced_table_name from information_schema.key_column_usage; 
+-----------------------+ 
| referenced_table_name | 
+-----------------------+ 
| tpk                   | 
| tpk                   | 
...

[14 Dec 2004 10:09] Sergei Glukhov

Fixed in 5.0 source tree