Bug #12063 column 'TABLE_SCHEMA' is missing in table INFORMATION_SCHEMA.USER_PRIVILEGE
Submitted: 20 Jul 2005 15:48 Modified: 20 Jul 2005 17:23
Reporter: Carsten Segieth Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.9 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[20 Jul 2005 15:48] Carsten Segieth 
Description:
The table INFORMATION_SCHEMA.USER_PRIVILEGE has only 4 columns (GRANTEE, TABLE_CATALOG, PRIVILEGE_TYPE, IS_GRANTABLE). The 3rd in the requirement document specified column 'TABLE_SCHEMA' is currently missing.

How to repeat:
desc information_schema.user_privileges;

Suggested fix:
add missing column