MariaDB SQL syntax error on upgrade

• Type: Bug
• Status: Closed
• Resolution: Won't Fix
• Affects Version/s: 7.0.X, 7.1.X, Master
• Fix Version/s: None
• Component/s: Database Upgrade Framework, Environments > Databases
• Labels:
  • QA-AUTOMATION
• Fix Priority: 2
• Databases:
  MariaDB 10.2
• QA Test Name:
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive612
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive6130
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive621015
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive621021
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive625
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive70106
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive704
• QA Test Score: 35

Steps to Reproduce:

1. Import the attached 7.0.4 portal database into MariaDB 10
2. Upgrade to 7.0/7.1/master

Expected Result:
No sql statement issues.

Actual Result:
Upgrade throws warnings:

2018-12-13 00:25:58.607 WARN  [main][UpgradeProcess:447] Attempting to upgrade table Counter by recreating the table due to: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'PRIMARY on Counter' at line 1_Query is:_drop index PRIMARY on Counter [Sanitized]
2018-12-13 00:25:58.607 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#Counter
2018-12-13 00:25:58.614 INFO  [main][Table:168] Starting backup of Counter to /var/folders/zv/5zswc4cd7rq93lr2t_vr1slm0000gn/T/temp-db-Counter-7856952594392737640.tmp
2018-12-13 00:25:58.616 INFO  [main][Table:204] Finished backup of Counter to /var/folders/zv/5zswc4cd7rq93lr2t_vr1slm0000gn/T/temp-db-Counter-7856952594392737640.tmp in 2 ms
2018-12-13 00:25:58.648 INFO  [main][LoggingTimer:43] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#Counter in 41 ms
2018-12-13 00:25:58.648 WARN  [main][UpgradeProcess:466] Successfully recreated and upgraded table Counter