Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-93640

Incorrect syntax warning when executing upgrade from 7.0.10.6 on Sybase

    Details

    • Fix Priority:
      3
    • Databases:
      Sybase ASE 16

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              anthony.chu Anthony Chu
              Reporter:
              anthony.chu Anthony Chu
              Participants of an Issue:
              Recent user:
              Rodrigo Cunha
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 50 weeks ago

                  Packages

                  Version Package
                  7.2.X
                  Master