MBThread column differs on upgraded database

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.4.13 DXP GA1, 7.4.3.4 CE GA4, Master
• Component/s: Message Boards
• Labels:
  • pt-app-security-review
  • pt-upgrade-review
• Story Points: 1
• Fix Priority: 4
• Sprint: LIMA | QA Sprint 14
• Git Pull Request: https://github.com/liferay-lima/liferay-portal/pull/2363
• QA Test Name:
  • dont-test-again

Steps to Reproduce:

1. Import attached 7.0.10.6 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 MBThread tables between upgraded and fresh database

Expected Result:
Columns match between the 2 databases.

Actual Result:
"title" column has different datatype and constraint

Upgraded database

`title` longtext 

Fresh master database

`title` varchar(75) DEFAULT NULL

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

Reproduced on 7.0.10.6 database, not reproducible on database from 7.1.10 or later.