Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-66018

Upgrading from 6.1 to 6.2 fails to properly create the templateKey column in table ddmtemplate

    Details

      Description

      Description
      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

      1. Start an instance of 6.1 with MYSQL as the database
      2. Upgrade the 6.1 instance to 6.2
      3. Upgrade the 6.2 instance to 7.0
      4. 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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                linda.sui Linda Sui
                Reporter:
                eric.yan Eric Yan
                Participants of an Issue:
                Recent user:
                Csaba Turcsan
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 5 weeks, 4 days ago

                  Packages

                  Version Package
                  6.2.X EE
                  7.0.0 DXP FP22
                  7.0.0 DXP SP4
                  7.0.X EE
                  7.0.4 CE GA5
                  Master