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

Role column constraints differ on upgraded database

    Details

    • Type: Bug
    • Status: Selected for Development
    • Resolution: Unresolved
    • Affects Version/s: Master
    • Fix Version/s: None
    • Labels:
    • Fix Priority:
      4

      Description

      Steps to Reproduce:

      1. Import attached 7.2.10 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 Role_, UserGroupRole tables between upgraded and fresh database

      Expected Result:
      Column constraints match between the 2 databases.

      Actual Result:
      Upgraded database has some different column constraints.

      Differences (compared with sql dumps)

      Table Upgraded DB Fresh Master DB
      UserGroupGroupRole
      `groupId` bigint(20) NOT NULL
      `roleId` bigint(20) NOT NULL 
      `userGroupGroupRoleId` bigint(20) NOT NULL DEFAULT '0'
      `userGroupId` bigint(20) NOT NULL 
      
      `groupId` bigint(20) DEFAULT NULL
      `roleId` bigint(20) DEFAULT NULL
      `userGroupGroupRoleId` bigint(20) NOT NULL
      `userGroupId` bigint(20) DEFAULT NULL
      
      UserGroupRole
      `groupId` bigint(20) NOT NULL
      `roleId` bigint(20) NOT NULL
      `userGroupRoleId` bigint(20) NOT NULL DEFAULT '0'
      `userId` bigint(20) NOT NULL
      
      `groupId` bigint(20) DEFAULT NULL
      `roleId` bigint(20) DEFAULT NULL
      `userGroupRoleId` bigint(20) NOT NULL
      `userId` bigint(20) DEFAULT NULL
      

      Slimmed down database dumps also attached
      fresh-master-sorted.sql upgraded-7210-sorted.sql

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              victor.ware Victor Ware
              Participants of an Issue:
              Recent user:
              Patricia Perez
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Days since last comment:
                19 weeks, 5 days ago

                  Packages

                  Version Package