MySQL Bugs: #100801: Wrong datatype for column DATA_TYPE in INFORMATION

Bug #100801	Wrong datatype for column DATA_TYPE in INFORMATION_SCHEMA
Submitted:	10 Sep 2020 13:48	Modified:	10 Sep 2020 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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

Thank you for the bug report.