Incorrect syntax warning when executing upgrade from 7.0.10.6 on Sybase

• Type: Bug
• Status: Closed
• Resolution: Duplicate
• Affects Version/s: 7.2.0 RC2, Master
• Fix Version/s: 7.2.X, Master
• Component/s: Business Productivity > Kaleo Workflow Forms
• Labels:
  • QA-AUTOMATION
• Fix Priority: 3
• Databases:
  Sybase ASE 16
• QA Test Name:
  • LocalFile.PortalSmokeUpgrade#ViewPortalSmokeArchive70106
• QA Test Score: 5

Steps to reproduce issue:

1. Import the attached 7.0.10.6 database into Sybase
2. Upgrade the database

Expected result: Upgrade executes successfully, and no warnings are thrown
Actual result: Upgrades executes, but syntax warnings are thrown:

2019-04-09 11:30:57.544 INFO  [main][UpgradeProcess:93] Upgrading com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema
INFO - Upgrading com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema
2019-04-09 11:30:57.545 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema#updateSQL
INFO - Starting com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema#updateSQL
2019-04-09 11:30:57.545 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString
INFO - Starting com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString
2019-04-09 11:30:57.547 WARN  [main][BaseDB:536] Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoTaskForm)
go

WARN - Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoTaskForm)
go

2019-04-09 11:30:57.595 WARN  [main][BaseDB:536] Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoTaskFormInstance)
go

WARN - Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoTaskFormInstance)
go

2019-04-09 11:30:57.623 WARN  [main][BaseDB:536] Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoDefinitionVersion)
go

WARN - Incorrect syntax near the keyword 'IF'.: DROP_TABLE_IF_EXISTS(KaleoDefinitionVersion)
go

2019-04-09 11:30:57.839 INFO  [main][LoggingTimer:43] Completed com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString in 294 ms
INFO - Completed com.liferay.portal.kernel.dao.db.BaseDBProcess#runSQLTemplateString in 294 ms
2019-04-09 11:30:57.840 INFO  [main][LoggingTimer:43] Completed com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema#updateSQL in 295 ms
INFO - Completed com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema#updateSQL in 295 ms
2019-04-09 11:30:57.840 INFO  [main][UpgradeProcess:107] Completed upgrade process com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema in 296 ms
INFO - Completed upgrade process com.liferay.portal.workflow.kaleo.internal.upgrade.v1_4_0.UpgradeSchema in 296 ms

Reproduced on:
Tomcat 9.0.17 + Sybase 16.0
Portal master GIT ID: 32242e6f17cfe39716aa80aa778b073d5ca94524
Portal master-private GIT ID: 1746ff1b29efb42ca90da6abd0ba1be3af1db25d