[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


 Description   

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.



 Comments   
Comment by Guilherme Blanco [ 04/Dec/11 ]

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

Generated at Thu Dec 18 02:29:40 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.