Upgrades fail on Sybase

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.3.0 CE GA1, 7.3.10 DXP GA1, Master
• Component/s: Core Infrastructure > Database Access
• Labels: None
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/81675
• Bug Type: Regression Bug

Steps to Reproduce

1. Start 7.0 ga1 with sybase
2. Upgrade from 7.0 to master
3. You will see the error

Expect Result
Upgrade successfully.

Actually Result
Fail to upgrade with following error

2019-11-27 14:52:23.255 INFO  [main][UpgradeProcess:107] Failed upgrade process com.liferay.portal.upgrade.PortalUpgradeProcess in 1148180 ms
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'IF'.
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:173)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:140)
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:122)
        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:151)
        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:183)
        at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:109)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'IF'.
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:123)
        at com.liferay.portal.upgrade.PortalUpgradeProcess.doUpgrade(PortalUpgradeProcess.java:129)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
        ... 11 more
Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near the keyword 'IF'.
        at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4131)
        at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3247)
        at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
        at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:294)
        at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:276)
        at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2749)
        at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2733)
        at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:588)
        at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117)
        at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
        at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:349)
        at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:315)
        at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:66)
        at com.liferay.portal.upgrade.v7_3_x.UpgradeLayout.doUpgrade(UpgradeLayout.java:51)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
        ... 14 more