-
Bug
-
Resolution: Fixed
-
Medium
-
3.5.2
When upgrading to 3.5.2 with Oracle 11, the upgrade fails with:
com.atlassian.confluence.upgrade.UpgradeException: Schema upgrade task [ com.atlassian.confluence.upgrade.upgradetask.ContentPermissionConstraintsUpgradeTask@1b9d14c ] failed due to : StatementCallback; bad SQL grammar [SELECT DISTINCT cp1.* FROM CONTENT_PERM cp1, CONTENT_PERM_SET cps1, CONTENT_PERM cp2, CONTENT_PERM_SET cps2 WHERE cp1.cps_id = cps1.id AND cp2.cps_id = cps2.id AND cp1.id <> cp2.id AND cps1.content_id = cps2.content_id AND cp1.cp_type = cp2.cp_type AND cp1.username = cp2.username ORDER BY cp1.cps_id, cp1.cp_type, cp1.username, creationdate]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
- is caused by
-
CONFSERVER-22123 Add database constraints to prevent duplicate content permission entries
- Closed
- is related to
-
CONFSERVER-22374 Some permissions cannot be added in SQL Server and Oracle
- Closed