DDC-1823: Error with IN and UPPER in the same line #2299

Open
opened 2026-01-22 13:47:40 +01:00 by admin · 0 comments
Owner

Originally created by @doctrinebot on GitHub (May 17, 2012).

Originally assigned to: @guilhermeblanco on GitHub.

Jira issue originally created by user patxi1980:

I have a problem making a DQL query

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

:values is an array of possible names of brands.

The error shown is
{quote}
[Syntax Error] line 0, col 109: Error: Expected Doctrine\ORM\Query\Lexer::T_IN, got '('
{quote}

Originally created by @doctrinebot on GitHub (May 17, 2012). Originally assigned to: @guilhermeblanco on GitHub. Jira issue originally created by user patxi1980: I have a problem making a DQL query {quote} SELECT c.id, c.name FROM BrandBundle:Brand c WHERE UPPER(c.name) IN (:values) {quote} :values is an array of possible names of brands. The error shown is {quote} [Syntax Error] line 0, col 109: Error: Expected Doctrine\ORM\Query\Lexer::T_IN, got '(' {quote}
admin added the Bug label 2026-01-22 13:47:40 +01:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#2299