@ManyToMany relation matching criteria ignores isNull(column)

[RusAlex]

I have an entity class where ManyMany relation described.

Then Im trying to do something like

public function getActiveRel()
{
   $criteria = Criteria::create()
   ->where(Criteria::expr()->isNull('column'));

   return $this->rel->matching($criteria);
}

IsNull condition is ignored in SqlValueVisitor.php
https://github.com/doctrine/doctrine2/blob/master/lib/Doctrine/ORM/Persisters/SqlValueVisitor.php#L57

And no any IS NULL in final SQL statement.

[RusAlex]

But documentation says , that isNull(x) must work:

http://doctrine-orm.readthedocs.org/projects/doctrine-orm/en/latest/reference/working-with-associations.html#filtering-collections

[waltertamboer]

I can confirm that this is happening. I'm also experiencing this issue.

[oprokidnev]

Still happening in 2k19.
In my case managed to solve by multiple collection transformation.

        $this->collection->matching(
            \Doctrine\Common\Collections\Criteria::create()
        )->matching(
            \Doctrine\Common\Collections\Criteria::create()->where(
                \Doctrine\Common\Collections\Criteria::expr()->isNull('deletedAt')
            )
        )

Problem is with
\Doctrine\ORM\Persisters\Collection\ManyToManyPersister::expandCriteriaParameters

It uses SqlValueVisitor that does not understand Comparison::EQ expression with null values.

[ThomasLabstep]

Still an issue.

ManyToMany + isNull Criteria is 100% not working.

Thx for the pointer to SqlValueVisitor.

I guess we need a little PR to add the use case to support isNull?

[astronati]

@beberlei news about this issue? @MatTheCat

[MatTheCat]

Well #10587 is open so maintainers will look at it when they’ll got time.