Bug #7215 information_schema: columns are longtext instead of varchar

Description:
There are information_schema columns which contain catalog identifiers. 
They have data type = 'longtext'. But that's not appropriate. 
They should have data type = 'varchar(x)' where x is the 
maximum identifier size, usually 64. It is now possible for 
a varchar to have more than 255 characters, so this should 
always be possible. 
 

How to repeat:
mysql> select table_schema,table_name, column_name from information_schema.columns 
where data_type = 'longtext'; 
+--------------------+-------------------+--------------------+ 
| table_schema       | table_name        | column_name        | 
+--------------------+-------------------+--------------------+ 
| information_schema | SCHEMATA          | CATALOG_NAME       | 
| information_schema | SCHEMATA          | SQL_PATH           | 
| information_schema | TABLES            | TABLE_CATALOG      | 
| information_schema | TABLES            | CREATE_OPTIONS     | 
| information_schema | COLUMNS           | TABLE_CATALOG      | 
| information_schema | COLUMNS           | COLUMN_TYPE        | 
| information_schema | COLUMNS           | COLUMN_COMMENT     | 
| information_schema | ROUTINES          | ROUTINE_CATALOG    | 
| information_schema | ROUTINES          | ROUTINE_DEFINITION | 
| information_schema | ROUTINES          | SQL_MODE           | 
| information_schema | STATISTICS        | TABLE_CATALOG      | 
| information_schema | VIEWS             | TABLE_CATALOG      | 
| information_schema | VIEWS             | VIEW_DEFINITION    | 
| information_schema | USER_PRIVILEGES   | TABLE_CATALOG      | 
| information_schema | SCHEMA_PRIVILEGES | TABLE_CATALOG      | 
| information_schema | TABLE_PRIVILEGES  | TABLE_CATALOG      | 
| information_schema | COLUMN_PRIVILEGES | TABLE_CATALOG      | 
| information_schema | TABLE_CONSTRAINTS | CONSTRAINT_CATALOG | 
| information_schema | KEY_COLUMN_USAGE  | CONSTRAINT_CATALOG | 
| information_schema | KEY_COLUMN_USAGE  | TABLE_CATALOG      | 
| information_schema | TABLE_NAMES       | TABLE_CATALOG      | 
+--------------------+-------------------+--------------------+ 
21 rows in set (0.11 sec)

Ok to push.

Fixed in 5.0.3

Noted in 5.0.3 changelog.