Bug #7219 information_schema: errors in "columns"
Submitted: 13 Dec 2004 1:36 Modified: 23 Dec 2004 8:32
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
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:36] Peter Gulutzan 
Description:
For some reason there is a PRIVILEGES column and a COLUMN_TYPE column. 
These are redundant and non-standard. 
 
Also, character_set_name and collation_name are VARCHAR(40). 
They should be VARCHAR(64) like other identifiers. 
 

How to repeat:
mysql> select `privileges`,`column_type` from information_schema.`columns` limit 1; 
+---------------------------------+-------------+ 
| privileges                      | column_type | 
+---------------------------------+-------------+ 
| select,insert,update,references | longtext    | 
+---------------------------------+-------------+ 
1 row in set (0.08 sec)
[23 Dec 2004 8:32] Sergei Glukhov 
fixed in 5.0 source tree
PRIVILEGES , COLUMN_TYPE columns are kept(discussed with PGulutzan)