Affects Version/s: 6.2.10 EE GA1, 7.0.0 DXP SP1
Component/s: Dynamic Data Mapping > Upgrades
The upgradeProcess for dynamic data mapping for 6.2 does not properly create the templateKey column for table ddmtemplate.
Instead of creating a column type VARCHAR, STRING is used, which leads to selecting a BLOB/CLOB depending on the database being used. For the cause of MYSQL, column type LONGTEXT would be used.
The actual column type that should be created for column templateKey should be VARCHAR(75).
Steps to Reproduce
- Start an instance of 6.1 with MYSQL as the database
- Upgrade the 6.1 instance to 6.2
- Upgrade the 6.2 instance to 7.0
- Check the database table schema for ddmtemplate and look for column templateKey
Expected Result: templateKey column has a column type VARCHAR(75)
Actual Result: templateKey column has a column type LONGTEXT
Obs: To test on master you can run the upgrade direct from 6.1 to master.
Reproduced on 62x: cb415314d33b316db280ac979729885fdd440112
Reproduced on master: 994e3a5a2d00917a01a0c99ee75e9d0fbf91c93e