[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


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 '('

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 Tue Nov 24 23:24:42 EST 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.