[DDC-1472] WHERE <<function>> IN ... doesn't work Created: 06/Nov/11  Updated: 04/Dec/11  Resolved: 04/Dec/11

Status: Resolved
Project: Doctrine 2 - ORM
Component/s: DQL
Affects Version/s: 2.1
Fix Version/s: 2.2
Security Level: All

Type: Bug Priority: Minor
Reporter: Christoph Krämer Assignee: Guilherme Blanco
Resolution: Fixed Votes: 0
Labels: None


I have a query which is supposed to compare a result of a user defined function with a set of possible results
SELECT ... WHERE YEAR(w.date) IN (.......)

But I get the error:
[Syntax Error] line 0, col 49: Error: Expected Doctrine\ORM\Query\Lexer::T_IN, got '('

If I only compare the result of the function with a single value everything works as aspected:
SELECT ... WHERE YEAR(w.date) = 2011
.. works!

I also testet it with other functions like DATE_DIFF, etc. but always get the same error.

Comment by Guilherme Blanco [ 04/Dec/11 ]

Fixed in master since this commit: https://github.com/doctrine/doctrine2/commit/0380d5ae580dcbefd63051028fc1ab78599fda6c

Generated at Fri Oct 09 04:59:32 EDT 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.