Feature request DQL IN/NOT IT (entity.x, entity.y, entity.z) #5587

New Issue

admin · 2026-01-22T15:12:00+01:00

admin commented

2026-01-22 15:12:00 +01:00

Originally created by @agirot on GitHub (Jun 23, 2017).

Originally assigned to: @Ocramius on GitHub.

Hi,
What do you think to add IN/NOT IN with field entity (like native mysql/pg) ?

SELECT a FROM AppBundle:A a INNER JOIN a.fk_b b WHERE a.c NOT IN (b.x, b.y)

Currently the result is a Doctrine\ORM\Query\QueryException :-)

Originally created by @agirot on GitHub (Jun 23, 2017). Originally assigned to: @Ocramius on GitHub. Hi, What do you think to add IN/NOT IN with field entity (like native mysql/pg) ? ` SELECT a FROM AppBundle:A a INNER JOIN a.fk_b b WHERE a.c NOT IN (b.x, b.y) ` Currently the result is a Doctrine\ORM\Query\QueryException :-)

admin added the Improvement Duplicate Question labels 2026-01-22 15:12:00 +01:00

admin closed this issue

2026-01-22 15:12:02 +01:00

admin commented

2026-01-22 15:12:03 +01:00

@Ocramius commented on GitHub (Jun 23, 2017):

@agirot you could modify InParameter parsing (http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/dql-doctrine-query-language.html#literal-values) to support ArithmeticExpression

@Ocramius commented on GitHub (Jun 23, 2017): @agirot you could modify `InParameter` parsing (http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/dql-doctrine-query-language.html#literal-values) to support `ArithmeticExpression`

admin commented

2026-01-22 15:12:04 +01:00

@lcobucci commented on GitHub (Jun 23, 2017):

@Ocramius Isn't that being handled by #6476?

@lcobucci commented on GitHub (Jun 23, 2017): @Ocramius Isn't that being handled by #6476?

admin commented

2026-01-22 15:12:04 +01:00

@Ocramius commented on GitHub (Jun 23, 2017):

@lcobucci ah yes, indeed. Still, that PR requires checking, as I have no idea if/how the query parsing would react to that change :-\

@Ocramius commented on GitHub (Jun 23, 2017): @lcobucci ah yes, indeed. Still, that PR requires checking, as I have no idea if/how the query parsing would react to that change :-\

admin commented

2026-01-22 15:12:04 +01:00

@lcobucci commented on GitHub (Jun 23, 2017):

@Ocramius sure thing, I was just referencing 😄

@lcobucci commented on GitHub (Jun 23, 2017): @Ocramius sure thing, I was just referencing 😄

admin referenced this issue

2026-01-22 16:14:09 +01:00

[PR #10587] Handle null comparisons in `ManyToManyPersister` #12474

Sign in to join this conversation.