Bug #11665 information_schema lacks information on available datatypes
Submitted: 30 Jun 2005 12:27 Modified: 30 Jun 2005 12:57
Reporter: Roland Bouman Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.0.7 OS:Any (NA)
Assigned to: CPU Architecture:Any

[30 Jun 2005 12:27] Roland Bouman
The iso 9075 specification for the information schema supports information on the availabel domains, and information on the user defined types. However, it does not specify a table to discover what builtin datatypes are supported. Doing so would be beneficial to database administration / design tools. These tools could use this information to offer the user options for designing tables etcetera.

How to repeat:

Suggested fix:
Add a table to the information schema that describes the builtin datatypes.