[DDC-1823] Error with IN and UPPER in the same line Created: 17/May/12  Updated: 27/May/12  Resolved: 27/May/12

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

Type: Bug Priority: Major
Reporter: Aitor Suso Assignee: Guilherme Blanco
Resolution: Fixed Votes: 0
Labels: None


 Description   

I have a problem making a DQL query

SELECT c.id, c.name
FROM BrandBundle:Brand c
WHERE UPPER(c.name) IN (:values)

:values is an array of possible names of brands.

The error shown is

[Syntax Error] line 0, col 109: Error: Expected Doctrine\ORM\Query\Lexer::T_IN, got '('



 Comments   
Comment by Guilherme Blanco [ 27/May/12 ]

This is already fixed in master for a long time and should be available in 2.3, since it requires major changes in DQL.

Generated at Sun Nov 23 11:07:23 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.