Doctrine 2 - ORM
  1. Doctrine 2 - ORM
  2. DDC-2424

Removing an inherited entity via a delete cascade constraint does not remove the parent row

    Details

    • Type: Bug Bug
    • Status: Awaiting Feedback
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3.3
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Mysql 5.1.66 / Symfony 2.2.1

      Description

      For a parent class:

      /**
       * @ORM\Entity
       * @ORM\Table(name="Base")
       * @ORM\InheritanceType("JOINED")
       * @ORM\DiscriminatorColumn(name="discr", type="string")
       * @ORM\DiscriminatorMap({"child1" = "Child1", "child2" = "Child2"})
       */
      

      and simple Child1 & Child2 entities.

      With another entity (let's call it ExternalEntity) having a bidirectional OneToOne relation owned by Child1:

      class Child1 extends Base
      {
        /**
         * @ORM\OneToOne(targetEntity="ExternalEntity", inversedBy="xxx")
         * @ORM\JoinColumn(onDelete="CASCADE", nullable=false)
         */
         private theForeignKey;
      }
      

      Enough for the context.
      The symptoms:

      $em->remove(instanceOfExternalEntity);

      removes the ExternalEntity row and the Child1 row. But a dangling row in the Base table is still there for the now inexistent Child1 instance.

      Though, a manual delete of either the associated Child1 OR Base row and then the ExternalEntity works.

      The problem with the cascading deletion of the parent seems to be only present when deleting through a MYSQL cascading delete from another row which has a foreign key on a child. (Not tested with a foreign key on the parent though)

        Activity

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Bruno Jacquet
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: