Issue Feature Closed

#67301Don't suggest database alterations for functionally equivalent field types with DBAL

Morton Jonuschat 06/05/15, 09:20 updated 10/02/18, 11:44

Description

When using the InstallTool with the DBAL extension a lot of database alterations will be suggested that can never be resolved due to MySQL specific field types.
When the extension DBAL is loaded accept field types that only differ in their storage space requirements as long as they are functionally equivalent. Example:

TINYTEXT -> VARCHAR is OK
TINYINT -> SMALLINT, INTEGER, BIGINT is OK
INTEGER -> BIGINT is OK
MEDIUMINT -> INTEGER is OK
MEDIUMINT -> SMALLINT is NOT OK

Especially integer types which have lower min/max values should still be migrated.

Also ignore length information for INT fields as this information is purely for display purposes and doesn’t change anything in regard to the values that can be stored in the field. Also the display width is ignored when the value exceeds it.

Reviews 1