Bug #100801 Wrong datatype for column DATA_TYPE in INFORMATION_SCHEMA
Submitted: 10 Sep 13:48 Modified: 10 Sep 14:47
Reporter: Martin Schuffenhauer Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:8.0.21 OS:Any
Assigned to: CPU Architecture:Any

[10 Sep 13:48] Martin Schuffenhauer
Description:
Wrong datatype for column DATA_TYPE in INFORMATION_SCHEMA ?

It actually makes no sense to define the columns DATA_TYPE with a data type of 4GB (long text). Further reason: COLUMN_TYPE is mediumtext and represents the long description.

-------------------------------------------------------------------------------

DATA_TYPE - The column data type.

The DATA_TYPE value is the type name only with no other information. The COLUMN_TYPE value contains the type name and possibly other information such as the precision or length. 

How to repeat:
describe information_schema.COLUMNS
[10 Sep 14:47] MySQL Verification Team
Thank you for the bug report.