Not possible to execute a WHERE condition from a parent entity with discriminators (with InheritanceType JOINED and DiscriminatorMap and DiscriminatorColumn) #5485

New Issue

admin · 2026-01-22T15:08:55+01:00

admin commented

2026-01-22 15:08:55 +01:00

Originally created by @josedacosta on GitHub (Mar 29, 2017).

Originally assigned to: @Ocramius on GitHub.

Hello,

Not possible to execute a WHERE condition from a parent entity with discriminators (with InheritanceType JOINED and DiscriminatorMap and DiscriminatorColumn)

It seems that the persist (and the cascade persist) works:

Https://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Persisters/Entity/SingleTablePersister.php#L60

Https://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Persisters/Entity/JoinedSubclassPersister.php#L429

The logic of "parent.children.column = 12" should be the same in the WHERE condition

And well understood a WHERE on a column of a LEFT JOIN and is always possible in MySQL, there is no reason that it is not in Doctrine ...

Manual addition of the WHERE in the MySQL query (just to test):
This works manually in MySQL:
"SELECT a0_.id AS id_0, a0_.name AS name_1, f1_.fin_size AS fin_size_2, d2_.tail_size AS tail_size_3, d2_.ears_size AS ears_size_4, a0_.discriminator AS discriminator_5 FROM animal a0_ LEFT JOIN fish f1_ ON a0_.id = f1_.id LEFT JOIN dog d2_ ON a0_.id = d2_.id WHERE d2_.tail_size = 12"

Here is an example code:

<?php
namespace CoreBundle\Entity;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity(repositoryClass="CoreBundle\Repository\AnimalRepository")
 * @ORM\InheritanceType("JOINED")
 * @ORM\DiscriminatorColumn(name="discriminator", type="string")
 * @ORM\DiscriminatorMap({"animal":"CoreBundle\Entity\Animal","fish":"CoreBundle\Entity\Fish","dog":"CoreBundle\Entity\Dog"})
 */
class Animal
{

    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    /**
     * @ORM\Column(type="string", nullable=true)
     */
    private $name;

}

<?php
namespace CoreBundle\Entity;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 */
class Dog extends \CoreBundle\Entity\Animal
{

    /**
     * @ORM\Column(type="integer", nullable=true)
     */
    private $tailSize;

    /**
     * @ORM\Column(type="integer", nullable=true)
     */
    private $earsSize;

}

<?php
namespace CoreBundle\Entity;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 */
class Fish extends \CoreBundle\Entity\Animal
{

    /**
     * @ORM\Column(type="integer", nullable=true)
     */
    private $finSize;

}

$em = $this->get('doctrine')->getManager();

$dogEntity = new Dog();
$dogEntity->setName('bulldog');
$dogEntity->setTailSize(12);
$dogEntity->setEarsSize(10);
$em->persist($dogEntity);

$fishEntity = new Fish();
$fishEntity->setName('trout');
$fishEntity->setFinSize(6);
$em->persist($fishEntity);

$animalEntity = new Animal();
$animalEntity->setName('test');
$em->persist($animalEntity);

$em->flush();

// OK
$animalRepository = $em->getRepository(Animal::class);
$queryBuilder = $animalRepository->createQueryBuilder('a');
$query = $queryBuilder->getQuery();
dump($query->getDQL());
dump($query->getSQL());
dump($query->getParameters());
$animals = $query->getArrayResult();
dump($animals);

// ERROR : Error: Class CoreBundle\\Entity\\Animal has no field or association named dog.tailSize
$animalRepository = $em->getRepository(Animal::class);
$queryBuilder = $animalRepository->createQueryBuilder('a');
$queryBuilder->where('a.dog.tailSize = 12'); // <<< ERROR <<<
// or : $queryBuilder->where('CoreBundle\Entity\Dog.tailSize = 12'); // <<< ERROR <<<
$query = $queryBuilder->getQuery();
dump($query->getDQL());
dump($query->getSQL());
dump($query->getParameters());
$animals = $query->getArrayResult();
dump($animals);

Yes .. it is possible to filter that the entity child:

$queryBuilder->where('a INSTANCE OF CoreBundle\Entity\Dog');

Which will add:
... WHERE a0_.discriminator IN ('dog')

It is still not possible to make a WHERE

Originally created by @josedacosta on GitHub (Mar 29, 2017). Originally assigned to: @Ocramius on GitHub. Hello, Not possible to execute a WHERE condition from a parent entity with discriminators (with InheritanceType JOINED and DiscriminatorMap and DiscriminatorColumn) It seems that the persist (and the cascade persist) works: Https://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Persisters/Entity/SingleTablePersister.php#L60 Https://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Persisters/Entity/JoinedSubclassPersister.php#L429 The logic of "parent.children.column = 12" should be the same in the WHERE condition And well understood a WHERE on a column of a LEFT JOIN and is always possible in MySQL, there is no reason that it is not in Doctrine ... Manual addition of the WHERE in the MySQL query (just to test): This works manually in MySQL: "SELECT a0_.id AS id_0, a0_.name AS name_1, f1_.fin_size AS fin_size_2, d2_.tail_size AS tail_size_3, d2_.ears_size AS ears_size_4, a0_.discriminator AS discriminator_5 FROM animal a0_ LEFT JOIN fish f1_ ON a0_.id = f1_.id LEFT JOIN dog d2_ ON a0_.id = d2_.id WHERE d2_.tail_size = 12" Here is an example code: ![image](https://cloud.githubusercontent.com/assets/3801119/25262355/c4203264-2657-11e7-8345-a868eb772daa.png) ``` <?php namespace CoreBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * @ORM\Entity(repositoryClass="CoreBundle\Repository\AnimalRepository") * @ORM\InheritanceType("JOINED") * @ORM\DiscriminatorColumn(name="discriminator", type="string") * @ORM\DiscriminatorMap({"animal":"CoreBundle\Entity\Animal","fish":"CoreBundle\Entity\Fish","dog":"CoreBundle\Entity\Dog"}) */ class Animal { /** * @ORM\Id * @ORM\Column(type="integer") * @ORM\GeneratedValue(strategy="AUTO") */ private $id; /** * @ORM\Column(type="string", nullable=true) */ private $name; } ``` ``` <?php namespace CoreBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * @ORM\Entity */ class Dog extends \CoreBundle\Entity\Animal { /** * @ORM\Column(type="integer", nullable=true) */ private $tailSize; /** * @ORM\Column(type="integer", nullable=true) */ private $earsSize; } ``` ``` <?php namespace CoreBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * @ORM\Entity */ class Fish extends \CoreBundle\Entity\Animal { /** * @ORM\Column(type="integer", nullable=true) */ private $finSize; } ``` ``` $em = $this->get('doctrine')->getManager(); $dogEntity = new Dog(); $dogEntity->setName('bulldog'); $dogEntity->setTailSize(12); $dogEntity->setEarsSize(10); $em->persist($dogEntity); $fishEntity = new Fish(); $fishEntity->setName('trout'); $fishEntity->setFinSize(6); $em->persist($fishEntity); $animalEntity = new Animal(); $animalEntity->setName('test'); $em->persist($animalEntity); $em->flush(); // OK $animalRepository = $em->getRepository(Animal::class); $queryBuilder = $animalRepository->createQueryBuilder('a'); $query = $queryBuilder->getQuery(); dump($query->getDQL()); dump($query->getSQL()); dump($query->getParameters()); $animals = $query->getArrayResult(); dump($animals); // ERROR : Error: Class CoreBundle\\Entity\\Animal has no field or association named dog.tailSize $animalRepository = $em->getRepository(Animal::class); $queryBuilder = $animalRepository->createQueryBuilder('a'); $queryBuilder->where('a.dog.tailSize = 12'); // <<< ERROR <<< // or : $queryBuilder->where('CoreBundle\Entity\Dog.tailSize = 12'); // <<< ERROR <<< $query = $queryBuilder->getQuery(); dump($query->getDQL()); dump($query->getSQL()); dump($query->getParameters()); $animals = $query->getArrayResult(); dump($animals); ``` Yes .. it is possible to filter that the entity child: $queryBuilder->where('a INSTANCE OF CoreBundle\Entity\Dog'); Which will add: ... WHERE a0_.discriminator IN ('dog') It is still not possible to make a WHERE

admin added the Invalid Question labels 2026-01-22 15:08:55 +01:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5485