[CAY-2853] Incorrect deletion of entities from flattened attributes

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2, 5.0-M2
• Fix Version/s: 5.0-M1
• Component/s: Core Library
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jurgen Doll
• Created: 07/May/24 16:38
• Updated: 13/Jun/24 12:29
• Resolved: 13/Jun/24 12:29

Description

When deleting an ObjEntity with flattened attributes Cayenne deletes the related DB attribute's row as well.

So if we have for example an ObjEntity "FlatPainting" with flattened attribute "galleryName". If we then delete a "FlatPainting" then the associated gallery will also be deleted, leaving all other paintings at that gallery without a valid Gallery link.

Furthermore if we add to our "FlatPainting" a "gallery" relationship attribute with delete rule Deny, the gallery is still deleted.

Sub-Tasks

• Improve delete prevention detection of flattened attribute row: Closed