[LPS-134918] Role column constraints differ on upgraded database - Liferay Issues

XML

Word

Printable

Steps to Reproduce:

Import attached 7.2.10 database to MySQL data-archive-portal-mysql.zip
Upgrade this database to Master (with DXP profile)
- tools/portal-tools-db-upgrade-client/db_upgrade.sh
Connect Master to a different, empty database schema
Start master against blank database schema
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

relates

LPS-135351 Contact_ table constraint differences on database upgrade from 6.2

Participants of an Issue:: Alberto Chaparro, Drew Brokke, SE Support, Victor Ware

Version	Package