Wrong SQL Statements in Upgrade Script to BAMOE 8.0.1

A merge for the fix to RHPAM-4540 was done in the incorrect order causing wrong SQL statements in the upgrade script for the databases Oracle, MS SQL Server, Postgres, Postgres Plus/EDB and Sybase. As this issue is only applicable to the upgrade scripts, then a new fresh installation using the scripts located in ddl-scripts folder, will work fine for any database. To fix this, user should use the corresponding DDL scripts located at https://github.com/kiegroup/jbpm/tree/7.67.x/jbpm-db-scripts/src/main/resources/db/upgrade-scripts (scripts rhpam-7.13-to-7.13.1.sql ). By using these upgrade scripts, besides RHPAM-4540 , the current issue described in the Jira RHPAM-4253 is also be resolved.

To fix this, user should use the corresponding DDL scripts located at https://github.com/kiegroup/jbpm/tree/7.67.x/jbpm-db-scripts/src/main/resources/db/upgrade-scripts (scripts rhpam-7.13-to-7.13.1.sql ) . By using these upgrade scripts, besides RHPAM-4540 , the current issue described in the Jira RHPAM-4253 is also be resolved.