← Back to team overview

maria-developers team mailing list archive

Re: Triangular FKs - Cascade delete leaves DB in state with broken referential integrity


On 03/02/18 22:58, Oliver Schonrock wrote:
> I have managed to simplify the test case further, by eliminating the
> "circular" ON DELETE SET NULL Contraints and their fields. Now it's a
> simple:
> parent => child1
>        => child2 with ON DELETE SET NULL FK to child1 to complete a
> "triangle"

Visual version of DB structure (the triangle), see attached png
(hopefully that works on this list).

When I delete member parent record => address child is cascade deleted,
BUT payment_method child is NOT cascade deleted.

Oliver Schönrock

Attachment: maridb_fk.png
Description: PNG image

Attachment: signature.asc
Description: OpenPGP digital signature