[CAY-2687] Modeler Migrate Repeatedly Asks to Set Column Type for MySQL Database

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.0.2, 4.1, 4.2.M1, 4.2.M2
• Fix Version/s: 4.2.M3
• Component/s: Modeler
• Assignee: Nikita Timofeev
• Reporter: Peter Hvass
• Created: 05/Nov/20 08:12
• Updated: 03/Feb/21 01:24
• Resolved: 02/Feb/21 14:33

Description

Appears to be a minor bug that has affected us from versions 4.0 through 4.2.M2.

When migrating schema using modeler we are repeatedly asked to 'Set Column Type' for a range of columns & types - we can migrate these changes time and again only to be asked to do it again on the next run - specific types;

• BIT -> BOOLEAN (the database already reflects that this is TINYBIT)
• LONGVARBINARY -> BLOB (the database already reflects that this is LONGBLOB)

Screenshot of modeler and part of our schema attached for reference.