Uploaded image for project: 'Alfresco'
  1. Alfresco
  2. ALF-16030

Use ON DELETE CASCADE for node aspects and properties

    Details

    • Type: Improvement
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Won't Do
    • Affects Version/s: Community Edition 201704 GA
    • Fix Version/s: None
    • Component/s: Repository, Upgrades
    • Labels:
      None
    • Resolution Time Custom Field:
      266 weeks, 4 days, 10 hours, 11 minutes, 50 seconds

      Description

      Node properties and aspects are tightly linked to nodes i.e. any update to nodes or properties is always accompanied by a version increment on the node.
      Therefore we can, when deleting a node, cascade-delete the aspects and properties.

      The FK constraint on the 'node_id' columns needs to get ON DELETE CASCADE and then a thorough check needs to be done on the different databases. Following this, the SQL upgrade scripts will be fairly simple: drop and recreate the FK constraint.

      This will alleviate some of the changes to deleteNodesByCommitTime required for ALF-16029. It needs to be investigated thoroughly

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                closedissues Closed Issues
                Reporter:
                dhulley Derek Hulley
              • Votes:
                1 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: