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

MDRRuleGroupInstance column constraint differences on database upgraded from 6.2

    Details

      Description

      Steps to Reproduce:

      1. Import attached 6.2.10.21 database to MySQL data-archive-portal-mysql.zip
      2. Upgrade this database to Master (with DXP profile)
        • tools/portal-tools-db-upgrade-client/db_upgrade.sh
      3. Connect Master to a different, empty database schema
      4. Start master against blank database schema
      5. Compare MDRRuleGroupInstance tables between upgraded and fresh database

      Expected Result:
      Columns match between the 2 databases.

      Actual Result:
      DDM key columns have different datatype

      Upgraded database

      `createDate` datetime DEFAULT NULL
      `modifiedDate` datetime DEFAULT NULL
      

      Fresh master database

      `createDate` datetime(6) DEFAULT NULL
      `modifiedDate` datetime(6) DEFAULT NULL
      

      Slimmed down database dumps also attached
      fresh.sql upgraded.sql

      Not reproducible when upgrading a database from 7.x

        Attachments

        1. data-archive-portal-mysql.zip
          82 kB
        2. fresh.sql
          420 kB
        3. upgraded.sql
          438 kB

          Issue Links

            Activity

              People

              Assignee:
              victor.ware Victor Ware
              Reporter:
              victor.ware Victor Ware
              Participants of an Issue:
              Recent user:
              Victor Ware
              Engineering Assignee:
              Hai Yu
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                36 weeks, 1 day ago

                  Packages

                  Version Package
                  7.4.13 DXP GA1
                  7.4.3.4 CE GA4
                  7.4.3.5 CE GA5
                  7.4.13 DXP U1
                  Master